SCCM 2007 Query
I need to create a collection of machines that have Acrobat reader 11. so that I can patch them. The query I created used the acrord32.exe and file versions but is not working properly
If I remove the second version it will give me a collection of all machines with a file version less than 18.104.22.168 but some of these machines have version 10 which this patch will not work on.
Any suggestion on how to fix this?
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "ACRORD32.exe" and (SMS_G_System_SoftwareFile.FileVersion < "22.214.171.124" and SMS_G_System_SoftwareFile.FileVersion >= "126.96.36.199")