How to extract all Application and Event names defined in the CA Workload Automation DE (dSeries) Server

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

The DE server keeps applications and events in the database.  The artifacts names can be listed from the database.

Question:

How to extract all Application and Event names defined in the CA Workload Automation DE (dSeries) Server?

Environment:
CA Workload Automation DE
Answer:

To list all Application and Event names defined in the CA Workload Automation DE (dSeries) Server database by running following query;

  • Application names
    SELECT ESP_AMS_DF.IDENTIFIER from ESP_AMS_DF where ESP_AMS_DF.ARTIFACTTYPE = 'APPLICATION' and ESP_AMS_DF.IDENTIFIER LIKE '%'; 

  • Events 
    SELECT ESP_EVENT_RP.IDENTIFIER from ESP_EVENT_RP;
Additional Information:

Alternatively, you can extract the application from the server by using the import/export utility to export all applications as the xml files.