Skip to content
Create Windows 11 SCCM Device Collection Process

Create Windows 11 SCCM Device Collection Process

Written By Anoop C Nair
Last Updated March 24, 2022
Posted In SCCM
SHARE

Let’s quickly check the process to create Windows 11 SCCM device collection. Microsoft released the 2107 version of Configuration Manager (a.k.a SCCM), which supports Windows 11 PCs. So, it’s worth creating a dynamic device collection for grouping all Windows 11 devices.

Grouping of Windows 11 PCs dynamically will help admins target applications and policies only to those devices. However, before going into further details of the creation process, let’s pause and analyze the best practices you need to follow while creating a dynamic collection.

You can create collections for Windows 11 PCs only when you install the SCCM client and it’s working fine. More details on How to Install SCCM Client on Windows 11 PC. Once the client is installed you can use any of the following WQL queries to build a dynamic collection for Windows 11 PCs.

Let’s have a quick look at the Windows 11 build numbers and version numbers. The Windows 11 version build number starts with 22000. I think it’s safe to assume that the build number is still supported in Windows 11 world, unlike the ReleaseID (deprecated).

Patch My PC

SCCM Collections help to group users or devices. Here you are going to learn how to create Windows 11 Devices collection. Windows 11 is released in production now and you can have a look at Windows 11 version numbers to build collections.

Best way to Create Windows 11 SCCM Device Collection

Let’s have a look into the best options to create Windows 11 SCCM device collection. There are several ways to query all devices in your SCCM environment and select only Windows 11 devices. I think you will need to settle down with the optimized WQL query to build a collection for All Window 11 Devices.

Create Windows 11 SCCM Device Collection Process ConfigMgr
Create Windows 11 SCCM Device Collection Process ConfigMgr

You can analyze the performance of the queries using different options in SMS_G_System_OPERATING_SYSTEM properties. The following is the list of options you have to build All Windows 11 device collection in SCCM. I think you will need to use Build Number or Caption properties to group all Windows 11 devices.

  • Build Number -> Example for Windows 11 build version -> 22000
  • Caption -> Example for Caption for Windows 11 -> Microsoft Windows 11 Enterprise
  • Version -> Example for Windows 11 Full version number -> 10.0.22000.100
  • Name -> Example for Name of Windows 11 OS -> Microsoft Windows 11 Enterprise|C:\WINDOWS|\Device\Harddisk0\Partition2

The Windows 11 version number property would be helpful to create an SCCM device collection of Windows 11 devices with a particular update or hotfix installed. I would avoid using the Name property because you might need to use the % symbol to filter things, which is not good for the performance of the WQL collection query.

Use Resource Explorer to Find Window 11 Device Properties

You can use SCCM resource explorer to find the details of Windows 11 device properties such as Build Number, OS Caption, or OS edition details.

  • Navigate to \Assets and Compliance\Overview\Devices\ and select any one of the Windows 11 devices.
  • Right-click on one of the devices and select Start and click on Resource Explorer.
  • Navigate to Operating System tab on the left side to get the details of Windows 11 OS related details.
Use Resource Explorer to Find Window 11 Device Properties

The following paragraph gives more details about all the Windows 11 operating system-related properties available in SCCM Resource explorer. These details along with column names help you to build an SCCM collection query for Windows 11 devices.

  • Name = Microsoft Windows 11 Enterprise
  • Build Number = 22000
  • OS Caption = Microsoft Windows 11 Enterprise
  • OS Vesion = 10.0.22000

Create All Windows 11 Devices Collections

Now, it’s time to learn how to create SCCM Windows 11 device collection (dynamic). The ConfigMgr Windows 11 Device Collection can be created using the following steps.

  • Navigate to SCCM console – Assets and ComplianceDevice Collections to create Windows 11 Device.
  • Right-click and select “Create Device Collection” from the Device Collections node.
  • From the General page, provide a Name and a Comment (optional).
  • You can be limiting the collection; choose to Browse to select a limiting collection. The collection contains members from the limiting collection
    • -> Avoid using All Systems collection as limiting collection.
  • Click on the NEXT button.
Create Windows 11 SCCM Device Collection Process ConfigMgr
Create Windows 11 SCCM Device Collection Process ConfigMgr

On the Membership Rules page of the Create Device Collection Wizard, in the Add Rule list, select the type Query Rule membership rule for this collection.

 Create SCCM Collection for All Windows 11 Devices
Create SCCM Collection for All Windows 11 Devices

You can configure multiple rules for each collection if there is a requirement. This is not required for creating All Windows 11 device collections.

  • Enter the name of the Dynamic query – All Windows 11 Devices.
  • Click on Edit Query Statement to add All Windows 11 devices.
Create SCCM Collection for All Windows 11 Devices

Click on the Criteria tab and then click on the show query Language button to create a new Criteria.

 Create SCCM Collection for All Windows 11 Devices
Create SCCM Collection for All Windows 11 Devices

Copy any of the below WQL queries to build a query statement for grouping All Windows 11 Devices in your SCCM. Before that, you will need to decide whether you will use a WQL query based on the Build Number of the Windows 11 operating system or based on the Caption value of the Windows 11 Operating System.

SCCM Windows 11 Collection based on Build Number

I think this is the best query to create a collect all Windows 11 devices based on build numbers. You can also use the WQL based on Caption to group only the enterprise version of Windows 11 devices.

Windows 11 reports the Operating System property as Microsoft Windows NT Workstation 10.0, which is identical to Windows 10. To distinguish devices running Windows 11, use the Operating System Build device property for build number 10.0.22000 or later.

 Create SCCM Collection for All Windows 11 Devices
Create SCCM Collection for All Windows 11 Devices
select * from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.BuildNumber >= "22000" and SMS_G_System_OPERATING_SYSTEM.BuildNumber < "30000" and 
SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 11 Enterprise"

NOTE! – It seems Server 2022 operating system also follows the same build number 20348. Hence it’s better to add Caption also into the dynamic collection query.

Best SCCM Collection Query for Windows 11 21H2 Oct 2021 Version

I think it’s better to create a collection for Windows 11 21H2 using the following WQL query. In the following query, I use the build number for Windows 11 OCT 2021 release (21H2). This is the best way to create Windows 11 Collection.

select * from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.BuildNumber = "22000" 
Create SCCM Collection for All Windows 11 Devices

SCCM Collection Query using Windows 11 OS Caption

You can use caption property as another option to build the All Windows 11 Device collection. But, you need to be careful whether you need to include only the enterprise version of Windows 11 or plan to use both enterprise and professional versions of Windows 11. The following query covers only the Enterprise version.

select * from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 11 Enterprise"

Query Statement

Let’s copy any query statements and create a dynamic device collection for Windows 11 devices. I’m going to use Build number as an example in this post. You can click on Green Video like the button to evaluate the WQL query using the SCCM collection query preview tool.

  • Click OK, OK, and Next button to continue to schedule option page of SCCM collection creation wizard.
Create Windows 11 SCCM Device Collection Process ConfigMgr
Create Windows 11 SCCM Device Collection Process ConfigMgr

Schedule Windows 11 Dynamic Device Collection

You can now configure the regular update options for Windows 11 device collection. The regular update of the collection with new Windows 11 devices is achieved through Schedule options.

By default, the schedule is 7 seven days. However, in the real-world probably, you might need to change the schedule to get better results. You can click on the Schedule button to change the schedule and select the custom intervalRecur every1day. Click on the OK button to continue.

Note! Don’t configure an aggressive schedule for updates. However, you will need to ensure that you have an automatic schedule to update the dynamic collections. Also, I think an incremental update option is good for All Windows 11 collections during the migration phase.

  • Enable the following option – Use Incremental updates for this collection.
  • Keep the default value – Schedule a full update on this collectiononce in every 7 days.
  • Click on the Next, Next, Close button to finish the creation of All Windows 11 Devices.
Create Windows 11 SCCM Device Collection Process ConfigMgr
Create Windows 11 SCCM Device Collection Process ConfigMgr

Results SCCM Collection for All Windows 11 Devices

You can check the SCCM Collection for All Windows 11 Devices contains all the Windows 11 devices or not using the following method.

Results SCCM Collection for All Windows 11 Devices
Results SCCM Collection for All Windows 11 Devices

Resources

Author

Written by

Anoop C Nair is Workplace Technology solution architect with 25+ years of experience in global enterprise organizations such as JP Morgan, Capgemini, etc. Microsoft Certified Trainer. Microsoft MVP from 2015 onwards for consecutive 11+ years! He also conducts Intune and modern workplace tech training for enterprise organizations. He is Blogger, Speaker, and Founder of HTMD Community and HTMD Conference. His main focus is on Device Management technologies like Intune, Windows, Cloud PC. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security.

Discussion · 1 comment

  1. The query does not consider non-English names, example from my company: ‘Microsoft Windows 11 企业版’ in result not covering all W11 devices. I use the following 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 “%Workstation 10.0%” and SMS_R_System.Build like “10.0.22%”

Join the discussion

Your email address will not be published. Required fields are marked *

Related guides

Intune

Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws

Key Takeaways Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws! In the July 2026 Patch, Microsoft introduced new features designed to improve the overall Windows experience. The update adds enhancements to Windows Update for more flexible update management and introduces Point-in-Time Restore, providing an additional recovery option for […]

AC Anoop C Nair 9 min read
Intune

2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws

Key Takeaways 2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws! The June 2026 Windows 11 Patch Tuesday update brings several improvements to File Explorer. It adds support for additional archive formats, including UU, CPIO, XAR, and NuGet Packages (NUPKG). The update also preserves View and Sort preferences in […]

AC Anoop C Nair 10 min read
Intune

2026 May KB5089549 KB5087420 Windows 11 Patch | 0 Zero Day Vulnerabilities and 120 Flaws

Key Takeaways The Windows 11 May 2026 Patch KB5089549 KB5087420 Update brings important security fixes, performance improvements, and reliability enhancements across the operating system. The update introduces new features such as Xbox Mode for gaming, File Explorer improvements, enhanced input and sharing experiences, better taskbar and Windows Hello reliability, and additional enterprise management capabilities for […]

AC Anoop C Nair 8 min read
SCCM

ConfigMgr 2603 Introduces New Early Update Enrollment Process

Key Takeaways In this post we are discussing the ConfigMgr 2603 Introduces New Early Update Enrollment Process. Microsoft has officially released Configuration Manager version 2603 to the Early Update Ring, giving organizations an opportunity to test upcoming improvements before the global production rollout. The release is targeted at enterprises running ConfigMgr version 2409 or later […]

AC Anoop C Nair 3 min read