/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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

Comments


Community Chosen Answer


Answers

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

Answered 04/12/2018 by: akmagnum
Red Belt

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

Answers

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%'))
))
Answered 04/19/2018 by: lpansarini
Senior Yellow Belt

Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share