Query for Java GUID

This SCCM Query will return PC’s in a specified collection that have Java¬†installed along with the Computer Name, Application Display Name, Product ID / GUID and Version number. The results of the SCCM Query will be similar to the image below. This Java query will remove %java auto updater% from the results.
Java Query

Java Query

select SMS_R_System.NetbiosName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version, SMS_G_System_ADD_REMOVE_PROGRAMS.ProdID 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 “%java%” and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like “%java auto updater%”

Sponsors