How to create a AM Query to list all computers which have a specific Agent Version ?
Example :
How to create a AM Query to list all computers with version 14.5.0.430 (14.5 CU4)
Client Automation - Any Versions
1- In DSM Explorer go under Queries and create a AM Query of type Computers
2- Click on Advanced Argument and put this :
Pseudo text = CU4 Agent Version (this is an example and it is possible to put any text)
Table = -Any-
WHERE Clause
select object_uuid from ca_agent where agent_type=1 and agent_version='14.5.0.430'
Above example is for version 14.5.0.430.
Adapt the version number by one to be searched.
3- Click OK and save the query.
This query returns all computers with agent version = 14.5.0.430