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: 6.x
Component:  CA RELEASE AUTOMATION RELEASE OPERATIONS CENTER

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;