Sometimes a Support Engineer may benefit from generating a comprehensive list of all agents that exist in a customer environment.
Component: CA RELEASE AUTOMATION RELEASE OPERATIONS CENTER
The below select query can be used to fetch agent details
# Below select query is tested on Oracle/MSSQL. It should ideally work with MYSQL, please alter syntax as needed
jxta_name, server_name, server_ip, server_reachable, os_type, agent_version