NetBackup IT Analytics User Guide

From the Template Designer tab, click Query custom combo box.

With the Query custom combo box selected, click Configure.

In the Heading field, enter the heading that will display in the report template's scope selector drop-down list. For example Array Vendor.

In the Query field, enter the SQL query that returns a list of values that will be available in the combo box:

SELECT DISTINCT vendor_name,vendor_name FROM aps_v_storage_array UNION ALL SELECT ' All', ' All' FROM dual ORDER BY 1

Click Validate and OK.

Click the Query tab and enter the following. This query will use the value selected in the populated combo box to retrieve the data to be rendered in the report. The custom combo variable is represented as ${queryCombo1} in the query.

SELECT
Array_name,
allocated_gb, available_gb
FROM aps_v_storage_array
WHERE
'${queryCombo1}' IN
  CASE
    WHEN '${queryCombo1}' NOT IN (' All') THEN
      CASE
        WHEN vendor_name = '${queryCombo1}' THEN '${queryCombo1}'
      END
   ELSE ' All'
END
ORDER BY available_gb DESC

Click the Formatting tab.

In the Formatting window, select Area Chart or Stacked Area Chart from the Display the report as a drop-down list.

For the Caption field, select array_name from the drop-down list.

Select all the fields to be displayed.

Assign a color to each field that will be displayed as an area. In the example, assign a color to the fields allocated_gb and available_gb.

Assign a name for the report template and save it to a report menu group. You can also assign sharing if required.

Generate a report from the new template. The output will look similar to the following example: