Workstations with less than Oracle Java 7 Update 60 Collection in ConfigMgr 2012

Print Friendly, PDF & Email

WQL query for finding workstations that have Java 7 installed but less than update 60.Untitled

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 "%Java 7 Update%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "7.0.600"