Example of Sums in a SQL Template
The following steps can be used to create the NetBackup Catalog Space by Client List. This example demonstrates how to include sums of a field.
In the SQL Template Designer, check .
In the Query window, enter the following select statement and click :
SELECT client_host_name, sum(nbr_of_files),sum(nbr_of_files)*150/1024/1024 FROM apt_v_nbu_job_detail WHERE client_id in (${hosts}) AND summary_status is not null AND expiration_date <= sysdate GROUP BY client_host_name ORDER BY sum(nbr_of_files) DESCIn the Formatting window, select all the fields to be displayed and display the report as a .
Click , enter a report name and click .The output will look something like this:
