Creating Device Collection based on an Active Directory Security Group in SCCM 2012

1. Browse to Assets and Compliance, right click on Device Collections and select “Create Device Collection”.

2. Give the collection a meaningful name, and set the limiting collection.

3. Add a Query Rule.

4. Edit Query Statement.

5. Head to the criteria tab, and click on the new star item.

2. Click on Select, and set the attribute class to System Resource and attritube to Security Group Name.

3. Click on value and choose from one of the populated entries, or manually enter the security group name.

4. Next, Next through the rest of the wizard.

5. The device collection has now been created.

Query Language : 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%"