Creating a report with filters, summarization, and charts

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

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 Sort 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 Chart 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:
    

Related topics

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