Getting everyone who doesn’t have Java 7 cu13
Create a Collection to get Everyone who has Java 7 Update 13
Create A NEW Collection Called Java 7 cu13
Click Next
Click “add query Rule”
Click “show Query Language”
Edit Query
PASTE the below code into the query Box
Paste the below into the Query Box
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 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 13"
Click next, next, next
NOTE the collection ID
MV100013
Create a NEW Collection Called
Workstations WITHOUT Java 1.7 cu13
Next
Click “add query Rule”
Click “show Query Language”
Edit Query
PASTE the below code into the query Box
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ResourceId not in (select ResourceID from SMS_FullCollectionMembership where collectionID=’MV100013‘)
Change the collection ID to the previous collection
Click OK
Click Next, Summary
Done:
You now have those systems WITH Java and those systems that are NOT in the collection of workstations with Java