Create Windows 11 SCCM Device Collection

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 very soon. 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.

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.

Windows 11 Build Number
Windows 11 Build Number

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 Build Version
Windows 11 Build Version

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.

Create Windows 11 SCCM Device Collection
Create Windows 11 SCCM Device Collection

Click Add Rule and from the drop-down select Query Rule.

Create Windows 11 SCCM Device Collection
Create Windows 11 SCCM Device Collection

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.

Create Windows 11 SCCM Device Collection
Create Windows 11 SCCM Device Collection

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.

Create Windows 11 SCCM Device Collection
Create Windows 11 SCCM Device Collection

Need Assistance?

Send us a message or post your question in forums.

1 thought on “Create Windows 11 SCCM Device Collection”

  1. 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. 🙂

    Reply

Leave a Comment