How to get a list of applications that have run in last one month or by specific time period?

Document ID : KB000014697
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

CA Workload Automation DE (dSeries) has several built-in or canned reports that provide detailed information on the workload.  The JOBS_RUN_FOR_TIME_PERIOD can be used to get the list of applications executed within a time period.  Once the report has been executed, the data can be exported in various format. 

Question:

How to show only applications that have executed or run within a specific time period?

Environment:
CA Workload Automation DE R11.3 or R12CA Workload Automation Desktop Client
Answer:

Log in to DE Desktop Client as user that has REPORTX permission for JOBS_RUN_FOR_TIME_PERIOD or user that is member of SCHEDMASTER group.

In the Desktop client, navigate to Services perspective and select Reports.  Run JOBS_RUN_FOR_TIME_PERIOD report, it will open a Report Parameters box.

Select the From and To dates and press OK.

8 AM.png

 

The report will execute and will show the summary and graph.  Select Export Report from the report (see screenshot below).

7 AM.png

Next, select the appropriate fields from the Export Data window.  Select ELEMENT_562 to from the results sets.  This will show the Application and other fields.  Select Application, State, Application generation, Start and End time fields (see screenshot)

20 AM.png

Once all the desired fields have been selected, click on OK and save the exported CSV file on Desktop.  The CSV file contains data about all the applications and the state and end times.

9 AM.png