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.ResourceID = SMS_R_System.ResourceID where
SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Java(TM) 6%"