NetBackup IT Analytics User Guide

From the Template Designer tabbed window, select Data Range and Array Scope Selector.

Create a query:

select storage_array_id, array_name, storage_pool_name, 
max(used_capacity_kb/1024/0124) used_gb,
trunc(log_date) log_date
from aps_v_storage_pool_log
where storage_array_id IN (${arrays})
and log_date BETWEEN ${startDate} AND ${endDate}
group by storage_array_id, array_name, storage_pool_name, trunc(log_date)

Validate the query.

In the Formatting tabbed section, choose to display the report as a Line Chart and the select log_date as the Caption field.

Expectation for the legend is that only three fields are enabled for the formatter. One should be the Legend, next one should be the data and the last one should be a date.

Select select storage_pool_name, used_gb and log_date.

For storage_pool_name select Legend as the Formatter.

Save the report. When you generate it from the Reports tab, the output will display something like this: