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 64 bit machines with Java 7 installed but not update 7 (SCCM)

select * from
SMS_R_System inner join
SMS_G_System_ADD_REMOVE_PROGRAMS_64 on
SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceID where
SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Java(TM) 7%" and
SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version != "7.0.70"

 

Leave a Reply

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