Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Creating a report with filters, summarization, and charts


The following example demonstrates how to retrieve a weekly Audit job run trend.

Domain

Report name

Features used

Audit

Weekly Audit job run trend

  • Add filters
  • Summarize data
  • Add charts

You add a filter to retrieve the number of Audit job runs for a particular year. The Count summarization function enables you to count the number of job runs.

To create a report with filters, summarization, and charts

  1. Launch Query Studio from the BMC Decision Support for Server Automation portal.
  2. Select a package (for example, BladeLogic) from the list of available packages.
  3. Click the Run Report link.
  4. Click the Preview with No Data link.
  5. Click the Insert Data link.
  6. Open the Audit folder and drag the following query items to the right pane:
    • Audit Job Run Date/Year
    • Audit Job Run Date/Week of Year
    • Audit Job/Job Run Start Time
  7. Select the Year column, and click Filter on the toolbar.
  8. In the Filters dialog box, select the Prompt every time the report runs check box.
     Each time you open or run the report, you can select or type in the filter values. If you do not specify any filter values, all relevant data is returned.
  9. From the Condition list, select the check box corresponding to the year that you want to display as default filter values. When you run the report, these values are selected by default. You can change the filter values a required.
  10. Click OK.
  11. Right-click the Job Run Start Time column and select Summarize.
  12. Click the Advanced link.
  13. From the Summary for cells list, select Count.
  14. From the Summary for footer list, select Total, and click OK.
  15. Select the Year column and click SortSortButton.gif on the toolbar.
  16. Select the Week of Year column and click Sort on the toolbar.
  17. Double-click the Job Run Start Time column and specify Number of Job Runs as the new name of the column.
  18. Click ChartChartButton.gif on the toolbar.
  19. In the Chart type field, select Column as a chart style, and click OK.
  20. Click the Run Report link.
  21. Click the Run with All Data link.
     The calculated results appear in a new column. By default, the expression used in the calculation is used as the heading name.
  22. Save the report.
     The following figure shows a sample report, which is created by using the preceding steps:
    WeeklyAuditJobRunTrend.gif

Related topics

Query-Studio
Creating-reports-with-Query-Studio
Domain-specific-report-examples

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*