/build/static/layout/Breadcrumb_cap_w.png

Find all PC's that Don't have a specific version of Adobe Reader

I'm trying to create a label that will include all PCs that have Adobe Reader that is not version 18.009.20044.  Trying to generate this via the wizard isn't being fruitful at all, and my SQL admin isn't being able to make heads or tails of the existing SQL generated by the label wizard.  Can anyone give me a jumping off point of how to do this via SQL?

Thanks in advance for your help.


0 Comments   [ + ] Show comments

Answers (2)

Posted by: akmagnum 5 years ago
Red Belt
1

The following search filter in your label management should find what you want.

All Adobe reader that is not version 18.009.20044.... Right ??


Comments:
  • Two issues with this - one, Adobe has changed their naming convention a few times. Sometimes it's Adobe Reader, sometimes Adobe Acrobat Reader, etc. So having to do Publisher contains Adobe and Title contains Reader. Also, it seems despite selecting "AND" for the operator, it's not actually being AND. It's returning machines that have Adobe Reader and *any* software that's not version 18.blah - basically all machines with Adobe Reader installed. - vyperhand 5 years ago
    • To get around that problem .....USE...

      Display name - contains - adobe acrobat reader
      OR
      Display name - contains - adobe reader
      AND
      Version does not contain 18.009.2004 - akmagnum 5 years ago
Posted by: lpansarini 5 years ago
Senior Yellow Belt
0
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID
FROM MACHINE
WHERE ((( exists  (
select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like '%Adobe Reader%')) ) OR (( exists  (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like '%adobe acrobat reader%')) ) AND ((not exists  (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_VERSION like '%18.009.20044%'))
))
 
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