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 groups

The following example demonstrates how to create a Job Activity report that lists the jobs that were run in last three weeks on a number of servers and the users who ran those jobs.

Report nameFeatures used
Jobs run in last 3 weeks on a number of servers and the users who ran those jobs
  • Add filters
  • Create groups

To create a Job Activity report with filters 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/Job Type
    • Job/Job Name
    • Job Runs/Job Run Start Time
  7. Apply a filter on the Job Run Start Time as follows:
    1. Select the column and click Filter on the toolbar.
    2. From the Operation type list, select Last number of days.
    3. In the Number of days before today field, type 21.
    4. Click OK.
  8. Drag the following query items to the right pane:
    • Job Runs/Run by User
    • Job Runs/Run Status
    • Job Activity Calculations/# Servers Attempted
  9. Group the report by the Job Type column.
  10. Sort the Job Run Start Time column in descending order.
  11. Click the Run Report link.
  12. Click the Run with All Data link.
  13. 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

Was this page helpful? Yes No Submitting... Thank you

Comments