Is there any way I can check the OS of certain Agent using SQL queries?
Client Automation - All Versions
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.