There is a need to gather comprehensive agent version details (Release and Build) for all agents within an AutoSys environment for inventory management, auditing, or troubleshooting purposes.
CA Workload Automation AE (AutoSys) 12.x, 24.x
It is recommended to leverage available commands and utilities rather than querying the database directly, as the database schema may change between versions, potentially breaking custom queries in future releases.
To list all machines with their agent release and build information, run: autorep -M ALL -p | grep -e "Agent Release" -e "Agent Build" -e "Machine Name"
To retrieve details for a specific host: autorep -M <machinename> -p
You can use curl to programmatically retrieve machine details:
All Machines: curl -X GET "https://<AEWSHOSTNAME>:9443/AEWS/machine" -k --user "<username>:<password>" -i
Specific Machine: curl -X GET "https://<AEWSHOSTNAME>:9443/AEWS/machine/<machinename>" -k --user "<username>:<password>" -i
Navigate to the Agent Inventory tab.
List all agents or search for a specific host.
The results can be exported to a CSV file for reporting.
Additional Information: If there is a specific requirement that necessitates a database query, you can reference the ujo_comm_send_alias table. Notable fields include:
host_alias
agent_release
agent_build
agent_os