Create a summary dynamic report

A summary dynamic report displays key report data in a bar or pie chart, accompanied by a table with the corresponding data. Summary reports can be generated in .html, .doc, .pdf, .rtf, or .xls format.

Unless you choose the HTML format, you can configure the report to run automatically at scheduled intervals and send the report as an email attachment.

Note: Microsoft Excel format is available for detailed reports only.

Procedure for creating a summary report remains same for Dynamic Alert Reports, Dynamic VA Result Reports, and Dynamic System Reports.

The following procedure explains how to create a detailed Dynamic Alert Reports:

Task

  1. On the Reports page, in the Dynamic Alert Reports tab, click New Report.
  2. In the Name field, enter a name for the dynamic report.
    Tip: Provide the name that reflects the nature of the report.
  3. In the Description field, enter a brief description of the dynamic report.
  4. From the Report type drop-down list, select Summary.
  5. In the Filter by area, set the filters to be applied for the report:
    • To define a filter, select the required criteria from the Filter by drop-down lists, then click Add. The filter is added to the Selected Filter Fields table.

    • To remove a filter from the Selected Filter Fields table, click Remove the corresponding row.

  6. From the Report Format drop-down list, select the format in which the report needs to be generated.
  7. From the Graph type drop-down list, select the type of graphic such as, Bar, Multi-Bar or Pie to display the data summary.
    Note: A Multi-Bar graph stacks data based on two different variables. For example, you can create a Multi-Bar graph that groups the data according to both DBMS and severity levels to view the distribution of alerts across the databases. If Multi-Bar is selected, you must define the properties assigned to the two axes in Group (subtotal) by.
  8. From the Group B (x axis) drop-down list, select the criteria such as, Level, DBMS, or Sensor for grouping data in the report.
  9. To run the report based on a schedule (available only for .pdf, .doc, or .rtf report formats), select Schedule Enabled check box, and configure one of these parameters:
    • To run a report at intervals, select by hour every, then select the interval between each report generation.
    • To run the report on the required days, select by day, then select the days of the week and the time to run the report.
    • To run the report on a monthly basis, select by month every, then select the number of months between each report generation and the time to run the scan.
    • To run the report on an advance scheduling, select advanced cron, and enter the expression based on the cron syntax.
    • To run the report only once on the scheduled time, select Run Only Once.
  10. Configure the report notification settings as follows:
    • If you want to send a notification when the report is ready, enter the email address in the Send notification by email to field.
    • If you want the report to be sent as an attachment to an email message, enter the email address in the Send notification by email to field, then select Attach report.
  11. Click Save to save the report without running it, or click Run to generate the report.