Disclaimer
This is my personal blog. The opinions and views I express are my own. The information I provide is on an as-is basis. I make no representations as to accuracy, completeness, currentness, suitability, or validity of any information on this blog and will not be liable for any errors, omissions, or delays in this information or any losses, injuries or damages arising from its use.

SCCM Query machines that DO NOT have Flash Player version 11.4.402.265 installed (SCCM)

Queries machines that DO NOT have Flash Player version 11.4.402.265 installed. select * 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 like "Adobe Flash Player 11 Plugin%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version != "11.4.402.265"  

SCCM Query any machine that has Adobe Reader X installed but not version 10.1.4 (SCCM)

Queries any machine that has Adobe Reader X installed but not version 10.1.4. select * 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 like "Adobe Reader X%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version != "10.1.4"