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

Products

• DSERIES- SERVER
• CA Workload Automation DE - Scheduler (dSeries)

Issue/Introduction

Extract all Application and Event names defined in the Workload Automation DE (dSeries) Server database.

Environment

Workload Automation DE dSeries)

Resolution

To list all Application and Event names defined in the database.

For Example;

• List Applications
  SELECT ESP_AMS_DF.IDENTIFIER from ESP_AMS_DF where ESP_AMS_DF.ARTIFACTTYPE = 'APPLICATION' and ESP_AMS_DF.IDENTIFIER LIKE '%'; 
• List Events 
  SELECT ESP_EVENT_RP.IDENTIFIER from ESP_EVENT_RP;

Additional Information

Extract Application and Event artifacts from the server using the imexutil (import/export) utility (in XMLformat).