search cancel

Is There a Way to Extract all FTP Remote Server Address used in Jobs?


Article ID: 75521


Updated On:


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


We would like to know all the remote server names used in jobs? Is there anyway I can extract this list?


CA Workload Automation DE (dSeries)


All application definitions with jobs information are stored in DE database ESP_AMS_DF table where ARTIFACTTYPE like 'APPLICATION' but the job information details cannot be extracted directly.

In DE r12.0.01.0 and higher, you can use the JOBMAP cli command with keywords like FTP, SERVERADDRESS to display jobs' information like ftp and server address.

If you are running lower version of DE, you can use the imexutil export utility to export application artifacts, then parse the data for the information required.