/build/static/layout/Breadcrumb_cap_w.png

How do you scope a software search to a specific version?

I'm trying to create a device Smart Label containing all devices that have VMWare Workstation installed that isn't version 16. I try:

"Software/Software Titles" = "VMWare Workstation" AND

"Software/Software Version" does not begin with "16". 


The problem is that it's not limiting the scope of the version search to the VMWare software title. If the device has ANY software installed that is version 16, it's excluded from the search. Is there anyway to specify which software item the version number is relating to? 


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: IgorAngelini 9 months ago
Second Degree Blue Belt
0

Top Answer

Try this query as a smart label, it will get all machines that have VMWare Workstation installed but not version 16.


SELECT MACHINE.ID AS TOPIC_ID,
       MACHINE.NAME AS SYSTEM_NAME
       
FROM MACHINE

LEFT JOIN MACHINE_SOFTWARE_JT MSJ
     ON   MSJ.MACHINE_ID = MACHINE.ID
LEFT JOIN SOFTWARE
     ON   SOFTWARE.ID = MSJ.SOFTWARE_ID


WHERE MACHINE.ID IN ( SELECT MACHINE.ID

                      FROM MACHINE

                      LEFT JOIN MACHINE_SOFTWARE_JT MS
                           ON   MS.MACHINE_ID = MACHINE.ID
                      LEFT JOIN SOFTWARE S
                           ON S.ID = MS.SOFTWARE_ID

                      WHERE S.DISPLAY_NAME LIKE "%VMWare Workstation%"
                      and   S.DISPLAY_VERSION NOT LIKE "16%"
                      AND   S.IS_PATCH = 0
                      GROUP BY MACHINE.ID
                    )

GROUP BY MACHINE.ID


Comments:
  • That worked out great. Thanks so much. - jlfrank 9 months ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ