Client Automation - DSM Query on detected release versions gives wrong result

Products

• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

DSM Query on detected release versions gives wrong result.

Research on software inventory for all products greater than a specific version does not return the correct list of machines. There are missing machines.

Example :

Machine JY-W* has "Screenpresso 1.7.2.0" in Software inventory.

Machine JY-W2*  has "Screenpresso 1.7.7.0" in Software inventory

But the DSM Query (Product 'Screenpresso' installed, version >= 1.7.2.0) returns only machine JY-W*

Environment

Client Automation - All Versions

Resolution

1- Open the properties of the DSM Query.

2-  Right click on (Product 'Screenpresso' installed, version >= 1.7.2.0) and select "Edit SQL.." in menu

 

3- In SQL Query, replace 

ca_software_def.sw_version_label='1.7.2.0'

by

ca_software_def.sw_version_label>='1.7.2.0'

4- Click OK