Where is the agent information store in the Event Server database?

Products

• Autosys Workload Automation
• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

I am preparing some reports that concerns agent machines and I would like to use the information that is provided by autorep -M ALL –p command (example output below).

I would like to refer to that information in the sql query hence my question – is this data available in some autosys database table?

Environment

Autosys ALL Versions
CA Workload Automation AE (AutoSys)

Resolution

The agent information is stored in the ujo_comm_send_alias and ujo_comm_send_node tables.