Create a limiting collection structure in SCCM 2012

In this guide for System Center Configuration Manager 2012 I will show how to create a limiting device collection structure. We start with All Systems as root, and create one collection for all servers and one for all workstations.

Create the All Servers Collection.

  1. Create a Device Collection with the name All Servers. Use All Systems as the limiting collection.
  2. Click Add Rule and select Query Rule.
  3. Type All Servers as the name of the query rule. Make sure System Resource is selected as the resource class and click Edit Query Statement.
  4. Make sure Simple Value is selected, click Select and choose System Resource as the attribute class and Operating System Name and Version as the attribute.
  5. Make sure Operator is set to “is like” and Value to %server%.

Create the All Workstations Collection.

Do the same for the All Workstation Collections, but replace %server% with %workstation% as the search string.

Create a collection for All Windows 7 Workstations.

Next we create collections for all Windows 7 workstations. As you can see from the table below, both server and workstation share the same version number. We are limiting this collection to All Workstations to make sure that no servers will be part of this collection.

  1. Create a query rule with system resource as the resource class.
  2. Define the criteria with “System Resource” as the attribute class and “Operating System Name and Version” as the attribute to search.
  3. Make sure te operator is set to “is like”, and use “%version number%” as the value to search for.

Windows Version Numbers.

Operating System Version Number
 Windows Server 2012 6.2
 Windows 8 6.2
 Windows 7 6.1
 Windows Server 2008 R2 6.1
 Windows Vista 6.0
 Windows Server 2008 6.0
 Windows Server 2003 R2 5.2
 Windows Server 2003 5.2
 Windows XP 64-bit 5.2
 Windows XP 5.1
 Windows 2000 5.0



Anders Rødland

Anders Rødland started his IT career in 2006. My main focus is MS Configuration Manager and client management, and I currently hold active 15 Microsoft certifications. Certified on Windows Server, Windows Client, SQL, Exchange and System Center Configuration Manager. Anders Rødland also holds an ITIL Foundation certification. This is my private blog and do not represent my employer. I use this to share information that I find useful. Sharing is caring.