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

Document ID : KB000075521
Last Modified Date : 02/04/2018
Show Technical Document Details
Question:
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)
Answer:
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.