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-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




Attachments