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

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

book

Article ID: 133672

calendar_today

Updated On:

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

Powered by Wolken Software