WQL - Identifying Clients requiring Adobe Acrobat and Reader 8.1.2 Security Update 1
After reading this post on the SANS ISC weblog, I thought I would provide the WQL I'm currently using in SMS to deploy the Adobe Acrobat and Reader 8.1.2 security update.
The following WQL will query Add/Remove Programs on clients and identify those who have Acrobat or Reader 8.1.2 but not the Security Update 1. Hope someone finds this useful:
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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_R_System.Name not in (select SMS_R_System.Name from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Adobe Acrobat and Reader 8.1.2 Security Update 1 (KB403742)" ) and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName in ( "Adobe Acrobat 8.1.2 Professional", "Adobe Acrobat 8.1.2 Standard", "Adobe Reader 8.1.2" )