Using multiple WQL queries, you can create Windows 11 device collection in SCCM. Let’s look at Windows 11 SCCM device collection creation process.
Windows 11 is the latest client operating system by Microsoft. Microsoft has finally unveiled the Windows 11 operating system. It features a cleaner, more Mac-like design and a number of new features.
Windows 11 will be available as a free download for existing Windows 10 users. So Windows 10 users can upgrade to Windows 11. You can refer the following guide to upgrade Windows 10 to Windows 11 using Intune.
To group all the Windows 11 computers into one device collection in SCCM, you can create a device collection for Windows 11. The query runs with a schedule and adds new Windows 11 computers to SCCM device collection.
Collections in Configuration Manager are groups of users or devices. After you create a collection, you can use it for tasks like managing applications, deploying compliance settings, or installing software updates.
Table of Contents
Windows 11 Build Number (Windows 11 21H2)
The Windows 11 (also known as Windows 11 21H2) operating system build number is 10.0.22000 and the full operating system build number is 10.0.22000.51.
The Windows 11 build number in SCCM can be retrieved under the computer properties. Go to General tab and under Discovery data, look for Operating System build number value.
If I run resource explorer on my Windows 11 computer, I can see the following details.
- Name – Windows 11 Enterprise
- Build Number – 22000
- Caption – Microsoft Windows 11 Enterprise
The above information should be sufficient to create Windows 11 SCCM device collection.
Windows 11 SCCM Queries for Device Collection
I will list three WQL queries using which you can create a device collection for Windows 11 in SCCM. If you have got a new query that works, let me know in the comments section.
Windows 11 SCCM Query using Build Number
Use the below WQL query to create a Windows 11 device collection using build number. Make sure you replace the build number as new versions of Windows 11 are released.
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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.BuildNumber = "22000"
Windows 11 SCCM Query using Caption
Use the below WQL query to create a Windows 11 device collection using caption.
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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 11 Enterprise"
Windows 11 SCCM Query using OS Name
Use the below WQL query to create a Windows 11 device collection using OS Name.
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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Name like "%Microsoft Windows 11 Enterprise%"
Create Windows 11 SCCM Device Collection
Let’s create a new SCCM device collection for Windows 11 computers. To create a device collection, select the “Device Collections” node in SCCM console. On the Home tab of the ribbon, select “Create Device Collection“.
On the General window of create device collection wizard, specify the name of the collection. For ex. Windows 11 device collection and select the limiting collection. Click Next.
Click Add Rule and from the drop-down select Query Rule.
Specify the name for the query rule and click Edit Query Statement. On the Query statement properties window, select Criteria tab. Click Show query language and enter the Windows 11 WQL query.
Click OK twice.
Click Next on summary window and on Completion window, click Close. Wait for a few minutes while the collection is updated. You should find all the Windows 11 computers added to your device collection.
thank you Prajwal, you give me so many time the solution for my “challenges”
Thanks Praj. Doing my job for me for as long as I can remember haha
Thank you for the distinguished query versions. This is extremely helpful for precision object version targeting and it’s something I didn’t realize I needed. I appreciate your hard work! Cheers. 🙂