Example of a Query of Failed Backup Jobs
The following example results in a table of failed jobs.
In the SQL Template Designer, check both and .
In the Query window, enter the following select statement and click :
SELECT apt_v_job.job_id,apt_v_job.client_id, apt_v_job.client_name, apt_v_job.server_id, apt_v_job.server_name, apt_v_job.start_date,apt_v_job.vendor_state_name, apt_v_job.vendor_status_name FROM apt_v_job WHERE apt_v_job.summary_status = 2 --Failed jobs AND apt_v_job.start_date > ${startDate} AND apt_v_job.start_date < ${endDate} AND apt_v_job.client_id IN (${hosts})In the Formatting window, select the fields to be displayed. For this example, it makes sense to and display the report as a .
Click , enter a report name and select a Menu Group. Then, click .
When you run this report, specify either a time period or start and end dates. You also can modify the scope to generate the report for a specific host group. The output will look something like this:
