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.

Combining query items from the Job Activity domain

This topic provides information about the query subjects in the Job Activity domain folder and it describes how to generate a useful report by using the query items from the Job Runs query subject.

Query subjects in the Job Activity domain folder

The Job Activity domain folder contains the query subjects shown in the following figure:

 

The query subjects in the Job Activity domain are divided into generic, detail-level, and summary-level categories. Query items from the generic query subjects can be combined with query items from the detail- or summary-level query subjects. BMC recommends that you do not combine query items from the detail- and summary-level query subjects because the combination might produce inconsistent results.

Generic query subjects

Detail-level query subjects

Summary-level query subjects

  • Job
  • Job Run Date
  • Job Activity job Property
  • Job Runs
  • Job Approval/Remedy Approval
  • Job Schedule
  • Job Activity Server Property

Job Activity Calculations

Generating reports using the Job Runs query subject

You can combine one or more query items in the Job Runs query subject with one or more query items in the following query subjects to generate useful reports:

  • Job
  • Job Run Date
  • Server
  • Job Activity Calculations

The following figure shows the query items present in the Job Runs query subject that you can combine with the query items present in other query subjects. BMC recommends that you combine only the query items that are shown in the figure.

Example

To create a report displaying the parent folder path and job folder for latest job runs and the number of servers on which those job runs were attempted, combine the following query items:

  • Job/Parent Folder Path
  • Job/Job Folder Names
  • Job/Job Name
  • Job Runs/Job Run Start Time
  • Job Runs/Run Status
  • Job Runs/Time To Execute (Sec)
  • Job Activity Calculations/# Servers Attempted
  • Job Activity Filters/Job Latest Run

Related topics

Creating reports with Query Studio
Creating reports with Report Studio

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

Comments