Client Automation - How can I check the OS of an Agent using SQL queries?

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

Is there any way I can check the OS of certain Agent using SQL queries?

Environment

Client Automation - All Versions

Resolution

One way to perform this is involving 2 tables: "ca_agent" and "ca_agent_prop".

First, find the desired Agent on 'ca_agent' table using the following query:

SELECT * FROM ca_agent

WHERE  agent_name='XXX'

Once this is obtained, the value of 'object_uuid' of that specific Agent needs to be copied and placed in the following query:

SELECT genOS FROM ca_agent_prop

WHERE object_uuid='YYY'

Using this queries as basis, the information can be obtained using a single query combining both.