Back up reports

Please have a look at this thread: https://www.dell.com/community/NetWorker/Daily-automated-report-of-failed-backups/m-p/7136617

As I have no idea if and what any requirement is to report or note anything down in excel, here are some things to look into:

You can also talk to the NW rest-api, for example listing only the failed backups. For rest-api usage look at https://developer.dell.com/apis/2378/versions/v3/docs/GettingStarted.md, specifically wrg to monitoring specifically https://developer.dell.com/apis/2378/versions/v3/docs/examples/Example-8Monitoring.md.

Or use a script calling nsrpolicy to look through all defined policies for each workflow and their actions and show the result of their last run?

NOTE: It will generate errors for workflows that are not enabled as those will not have any output (Can not fetch workflow record for policy: xxxx, workflow: yyyy).

nsrpolicy policy list | while read POL
do
nsrpolicy workflow list -p "${POL}" | while read WF
do
# -n is non-tabular overview
echo "#########################################"
echo status of policy "${POL}" workflow "${WF} :"
nsrpolicy monitor -p "${POL}" -w "${WF}" 2>&1
echo
done
done

Besides DPA, you can also give a look at DPC (data protection central) an appliance to be deployed as OVA, part of the whole Dell DPS solution.

https://www.dell.com/support/home/en-us/product-support/product/data-protection-central/overview

https://dl.dell.com/content/manual50278947-data-protection-central-19-7-getting-started-guide.pdf

Data Protection Central is an active monitoring application with management capabilities. Data Protection Central provides a solution for data protection administrators who manage multiple independent data protection applications and storage devices.
When you work with multiple data protection applications, operational monitoring and management can be a complex, time consuming effort.
Data Protection Central enables administrators to monitor and manage the software products within the Data Protection Suite family from a single user interface, simplifying the entire data protection experience.

Comprehensive dashboards
Data Protection Central has a comprehensive and customizable dashboard for at-a-glance monitoring of systems and activities.
Data Protection Central supports up to 20 dashboards per user.

You can also connect DPC and DPA together:

Report capabilities
Data Protection Central provides the capability for you to run Data Protection Advisor reports for supported systems.
Supported systems include:
● Avamar
● NetWorker
● Data Domain
● PowerProtect Data Manager
You can run, and then view these reports directly in the Data Protection Central user interface. You can also specify the reporting period for these reports within the Data Protection Central interface.
Data Protection Central reporting features require you to have Data Protection Advisor in the environment. For more information about Data Protection Advisor, see the Data Protection Advisor documentation set.
NOTE: To take full advantage of Data Protection Central capabilities, it is recommended that all systems that are configured in Data Protection Advisor be configured also in Data Protection Central.

To list failed backups with use of REST API, do I need to list failed jobs? Backup endpoint do not provide status like suceeded/failed.

the link I mentioned https://developer.dell.com/apis/2378/versions/v3/docs/GettingStarted.md also refers to https://developer.dell.com/apis/2378/versions/v3/docs/examples/Example-9JobMonitoring.md for "for more details on jobs".

"

If you want to search the job database for a specific set of jobs, for example, all the failed jobs in the last 2 hours, you can build an API query like the following:

 GET /nwrestapi/v3/global/jobs?q=completionStatus:Failed AND startTime:['2020-03-25T10:00:00' TO '2020-03-25T12:00:00']&fl=id,command,exitCode

"