Advanced Reports

Advanced reports allows you to create customized reports that cover multiple metric categories (availability, inventory, configuration and performance metrics) from monitors of various resources types. You can create reports based on various monitoring parameters from different monitor types and customize them by configuring various criteria to display data and generate reports accordingly.

To create a new Advanced Report, follow the steps given below:

1. Go to Settings → Reporting and click on Advanced Reports. Alternatively, you can access the same under the dropdown next to the Reports tab.
   • From Applications Manager v180200 onwards, Advanced Reports can be accessed by expanding OVERVIEW from the left side pane and then clicking Custom Reports → Advanced Reports from the Reports tab.
2. Click on Create New Report button available on the top right corner. New advanced reports configuration page will appear.
3. Specify the required Name and Description for the report to be created.

4. In the Select Columns tab, you will find the complete list of parameter categories and their corresponding metrics that are available for generating reports (under Available Monitors section), and are broadly classified into three types - General, Configuration Data, and Performance Data. Upon selecting the parameter category, choose the required metrics (from the Available Columns section) for which data is to be shown and move them to the Selected Columns section.

   • By default, selecting a Performance Data column generates three sub-columns for Min, Max, and Avg. values of the required metric. From Applications Manager v180200 onwards, you can customize the generated sub-columns based on your requirement and configure Avg, Max, Min, and the newly-supported 95th Percentile. This option is present in the Available Columns section.

   

   Note: The Custom Fields category under Advanced Reports is supported starting from Applications Manager version 176700. Refer to this KB to learn more about Custom Fields behavior and special cases.

5. In the Group by Columns tab, select a metric for which you want to group and sort the column elements in the report, if required. You can specify the sorting criteria for a maximum of two metric columns in the report.

   • From Applications Manager v180200 onwards, the Group by Columns tab includes an additional Sort by option along with the existing Group by functionality. You can choose either option based on your reporting requirements.
   • When using the Sort by option, you can also use the View Records setting to limit the number of rows displayed in the report.

   Note: Metrics selected from the Availability and Performance Data categories will not be listed in this tab.

   

6. In the Apply Criteria tab, specify the criteria for the selected metric columns based on which report needs to be generated. You can add multiple criteria for all the selected metric columns, if required. You can use AND or OR to combine multiple criteria in the Criteria Pattern input field for filtering.

   Note: The Apply Criteria tab does not support the following columns:

   1. Inventory columns:
      • Creation time
      • Credential manager name
      • IP Address
      • Monitor groups
      • RCA message
   2. Performance Metrics

7. For metric columns selected from the Availability and Performance Data categories, a new tab named Filter by Period appears. In this tab, specify the Time Period and Time Window / Business Hour based on which data needs to be shown for the selected columns in the report.

   

8. Once the configurations are done, click on Preview button located at the bottom right corner to display a preview of the report to be generated. You can click on Edit button to return to the previous page in case you need to make additional changes to the report configuration.
9. Finally, click on Save to finish adding the report.

Upon saving, the report will be generated and stored, and can be viewed by clicking on the report name in the Advanced Reports page. You can choose to export and download the required report in PDF/Excel format as well as create a copy of the required report using the Copy Report option. You can also select and delete the required reports using the Delete button.

Enhancements in Advanced Reports

The following section outlines the enhancements implemented in Advanced Reports across various releases: