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.
Domain | Report name | Features used |
---|---|---|
Job Activity | 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
- Launch Query Studio from the BMC Decision Support for Server Automation portal.
- Select a package (for example, BladeLogic) from the list of available packages.
- Click the Run Report link.
- Click the Preview with No Data link.
- Click the Insert Data link.
- 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
- Select the Job Creation Date column and click Filter on the toolbar.
- From the Operation list, select Last number of days.
- In the Number of days before today field, type 30, and click OK.
- Right-click the Job Name column and select Summarize.
- Click the Advanced link.
- From the Summary for cells list, select Count Distinct, and click OK.
- From the Summary for footers list, select Total, and click OK.
- Select the Created Role Name column and click Group on the toolbar.
- Select the Created User Name column and click Group on the toolbar.
- Select the Job Creation Date column and click Delete on the toolbar.
- Clear the Job Creation Date: 30 days before today filter check box, and click OK.
- Click the Run Report link.
- Click the Run with All Data link.
- 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
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*