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

book

Article ID: 75521

calendar_today

Updated On:

Products

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

Issue/Introduction



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

Environment

CA Workload Automation DE (dSeries)

Resolution

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.