Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

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.

Report name

Features used

Number of servers on which a job was run

  • Add filters
  • Create charts

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:
    SampleJA2.png

Related topics

Sample-reports-demonstrating-Query-Studio-features
Creating-reports-with-Query-Studio

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*