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)
Please log in to answer
Posted by:
akmagnum
6 years ago
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 6 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 6 years ago
Posted by:
lpansarini
6 years ago
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%'))
))
