ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 14697


Updated On:


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


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?


CA Workload Automation DE R11.3 or R12CA Workload Automation Desktop Client


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">




1558709148068000014697_sktwi1f5rjvs16rdx.png get_app
1558709146260000014697_sktwi1f5rjvs16rdw.png get_app
1558709144320000014697_sktwi1f5rjvs16rdv.png get_app
1558709142147000014697_sktwi1f5rjvs16rdu.png get_app