Creating a report with filters, summarization, and groups

The following example demonstrates how to retrieve the number of jobs created by a user with a particular role in the last 30 days.

You add the Count summarization function so that the total number of jobs for each user is displayed in the report.

To create a report with filters, summarization, and groups

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 Job Activity folder and drag the following query items to the right pane:
   • Job/Created Role Name
   • Job/Created User Name
   • Job/Job Name
   • Job/Job Creation Date
7. Select the Job Creation Date column and click Filter on the toolbar.
8. From the Operation list, select Last number of days.
9. In the Number of days before today field, type 30, and click OK.
10. Right-click the Job Name column and select Summarize.
11. Click the Advanced link.
12. From the Summary for cells list, select Count Distinct, and click OK.
13. From the Summary for footers list, select Total, and click OK.
14. Select the Created Role Name column and click Group on the toolbar.
15. Select the Created User Name column and click Group on the toolbar.
16. Select the Job Creation Date column and click Delete on the toolbar.
17. Clear the Job Creation Date: 30 days before today filter check box, and click OK.
18. Click the Run Report link.
19. Click the Run with All Data link.
20. 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