Create Config Mgr Collection with multiple criteria

I recently deployed Config Mgr 2012 in a higher level educational institute and configured a solution for software updates.

The Active Directory structure included a parent resource domain and two child domains (Staff and Students). There were different requirements for patching clients in the two domains. Therefore I had to create collections with two criteria:

Windows 7 Computers AND
Member of specific domain


This was carried out in 2 steps 

1. Created "All Windows 7 Computers" collection
2. Created Student Collection utilising the "All Windows 7 Collection"


1. "All Windows 7 Computers" collection
I created a simple "All Windows 7 Computers" using the SQL Query

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.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 6.1"


2. Created Student Collection utilising the "All Windows 7 Collection"
I then created a new Collection for Windows 7 Computers in Students Domain using "All Windows 7 Computers" as the "Limiting Collection"

Created a Query Rule to choose computers in the Students domain (this is more useful than a Direct Rule as it populates dynamically when new computers are added to this domain)

Edited Query Statement

Selected Criteria tab and added a criteria (by clicking gold star) - chose Resouce Domain or Workgroup as the System Resource

 Typed Student domain name

Completed the Create Collection Wizard

Collection now available