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 64bit machines with Java 6 (any version #) installed (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) 6%"

 

Leave a Reply

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