List all Agents with online status, version and OS type

Products

• CA Release Automation - Release Operations Center (Nolio)
• CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

Sometimes a Support Engineer may benefit from generating a comprehensive list of all agents that exist in a customer environment. 

Environment

Release Automation 6.8 and above

Resolution

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

SELECT
       jxta_name, server_name, server_ip, server_reachable, os_type, agent_version
FROM servers;