SCCM 2012 Sub select collections – getting everyone who “doesn’t” have Java 7 cu13

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

 

image

Click Next

 

Click “add query Rule”

Click “show Query Language”

 

Edit Query

PASTE the below code into the query Box

 

image

 

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"

 

image

 

Click next, next, next

 

image

 

NOTE the collection ID

 

image

 

image

 

 

MV100013

 

 

 

Create a NEW Collection Called

Workstations WITHOUT Java 1.7 cu13

image

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

 

image

image

Click Next, Summary

 

 image

Done:

You now have those systems WITH Java and those systems that are NOT in the collection of workstations with Java

Leave a Reply