NetBackup IT Analytics User Guide

In the SQL Template Designer, check Date Range and Host Groups and Client Scope.

In the Query window, enter the following select statement and click Validate Query:

with spark as (
select trunc(start_date), client_id, client_name, product_type_name,count(job_id) failed_count
FROM apt_v_job
WHERE client_id in(${hosts})
AND start_date between ${startDate} AND ${endDate}
AND summary_status = 2
group by client_id, client_name, product_type_name, trunc(start_date)
)
select display_name, product_type_name, rtd.collectString(cast(collect(TO_CHAR(failed_count)) as StringListType), ', ') failed_count, rtd.collectString(cast(collect(TO_CHAR(failed_count)) as StringListType), ', ') failed_count_area
from apt_v_server h, spark s
where h.server_id = s.client_id
group by display_name, product_type_name
order by 1,2

In the Formatting window, select all the fields to be displayed and display the report as a Table.

In the Formatting window, for failed_count, select the Column Sparkline formatter and for the failed_count_area, select the Area Sparkline formatter.

Click Next, enter a report name and click Finish.The output will look something like this: