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.Create a limiting collection structure in SCCM 2012 1
  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 a limiting collection structure in SCCM 2012 2

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.

Create a limiting collection structure in SCCM 2012 3

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 have passed 17 Microsoft certifications since then. My main expertise is on client management with Microsoft Endpoint Manager: Intune and Configuration Manager. I also do a lot of work on the security side with Microsoft Defender for Endpoint. In addition to my Microsoft certification, I also have an ITIL v3 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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.