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

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/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. 

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

Resolution

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.

<Please see attached file for image>

style="display: block; margin-left: auto;" src="/servlet/servlet.FileDownload?file=0150c000004AKjCAAW" alt="8 AM.png" width="403" height="216">

 

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

<Please see attached file for image>

style="display: block; margin-left: auto;" src="/servlet/servlet.FileDownload?file=0150c000004AKjBAAW" alt="7 AM.png" width="335" height="115">

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)

<Please see attached file for image>

style="display: block; margin-left: auto;" src="/servlet/servlet.FileDownload?file=0150c000004AKjAAAW" alt="20 AM.png" width="333" height="354">

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.

<Please see attached file for image>

style="display: block; margin-left: auto;" src="/servlet/servlet.FileDownload?file=0150c000004AKjDAAW" alt="9 AM.png" width="330" height="221">