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

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.