Creating a report with filters, summarization, and calculations

The following example demonstrates how to retrieve the number of jobs that exist in job folders.

You add a filter so that deleted jobs are not counted. You add the Concatenate summarization function to concatenate the Parent Folder Path and Job Folder Name columns to get the full path of a job. You use the Count summarization function to count the number of jobs.

To create a report with filters, summarization, and calculations

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/Parent Folder Path
   • Job/Job Folder Name
   • Job/Job Name
7. Open the Job Activity Filters folder and drag the Job is not deleted filter to the right pane.
8. Select the Parent Folder Path and Job Folder Name column names and click Calculate on the toolbar.
9. From the Operation list, select Concatenation.
10. In the Separator between report items field, specify / as the separator.
11. Click Insert.
    The calculated results appear in a new column, Parent Folder Path/Job Folder Name. By default, the expression used in the calculation is used as the heading name.
12. Right-click the Job Name column and select Summarize.
13. Click the Advanced link.
14. From the Summary for cells list, select Count.
15. From the Summary for footers list, select None, and click OK.
16. Select the Parent Folder Path column and click Delete on the toolbar.
17. Select the Job Folder Name column and click Delete on the toolbar.
18. Double-click the Job Name column and specify Job Count as the new name of the column.
19. Click the Run Report link.
20. Click the Run with All Data link.
21. 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