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

Products

• DSERIES- SERVER
• CA Workload Automation DE
• CA Workload Automation DE - Scheduler (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

ESP dSeries Workload Automation (DE)

Resolution

All application definitions with jobs information are stored in DE database ESP_AMS_DF table where ARTIFACTTYPE like 'APPLICATION'.

You can use the JOBMAP cli command with keywords like FTP, SERVERADDRESS to display jobs' information like ftp and server address (Release 12.0.01.0 and higher). 

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

Additional Information

Jobmap Command - Create a Job Activity Report

The Import and Export Utility