Sample Job Activity report with filters and charts

The following example demonstrates how to create a Job Activity report that provides a graphical view of the number of servers on which a job was run.

To create a Job Activity report with filters 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 Job Activity folder and drag the following query item to the right pane: Job/Job Name.
7. Apply a filter on the Job Name column with the Hardware Info Snapshot value selected.
8. Drag the following query items to the right pane:
   
   1. Job Runs/Job Run Start Time
   2. Job Activity Calculations/# Servers Attempted
9. Create a line chart that plots job run start time against the number of servers on which a job was run.
10. Click the Run Report link.
11. Click the Run with All Data link.
12. Save the report.
    The following figure shows a sample Job Activity report created by using this procedure:
    

Related topics

Sample reports demonstrating Query Studio features
Creating reports with Query Studio