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-W10-1803 has "Screenpresso 1.7.2.0" in Software inventory.

Machine JY-W2K16-14SP2  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-W10-1803.

Environment

Release:

Component:

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