Create SCCM Collection for Windows 11 Upgrade Compatible Devices

Let’s create SCCM collection for Windows 11 compatible devices to help with Windows 10 to 11 migrations. You can use this collection to deploy the Windows 11 Feature Update and In-place Upgrade Task Sequence (IPU).

Microsoft’s new attribute explained in the below sections helped system admins to get the Window 11 Upgrade Compatible Matrix report and collection without writing complex WQL and SQL queries. SCCM Windows 11 Upgrade Readiness Report Using SQL Query helps to create a custom report for Windows 11 upgrade readiness scenario.

The collection helps to group Windows 11 upgrade compatible Windows 10 devices this collection is useful in many upgrade deployment scenarios and reporting scenarios. I recently learned about the hardware inventory and CMPivot entity details available in the SCCM from MVP colleague Matthew Hudson.

I recommend creating All Windows 11 Devices collection if you have not created one. All Windows 10 and All Windows 11 SCCM Collections help the admins to target applications and software updates to the appropriate group of devices (and produce reports).

You can use requirements rules, global conditions, etc to segregate the Windows 10 and Windows 11 devices without creating collections. You also need to take care of best practices while creating SCCM (aka ConfigMgr) dynamic collections.

• Install Box Drive with Intune Enterprise App Catalog App
• New Entra Phishing Resistant Passwordless Authentication | Zero-Trust Security Strategy | Explicit Verification
• Microsoft Surface Pro 11th Edition a Copilot PC with 14 Hours of Battery 45 Trillion Operations per Second
• Microsoft Intune Enhances PKCS Certificate Issuance with SID Support
• Best Guide to Setup Conditional Access for Remote Help with Intune | RemoteAssistanceService

Check Window 11 Upgrade Compatible Matrix from Resource Explorer

You can use SCCM resource explorer to check the details of Windows 11 upgrade compatible Windows 10 device properties such as Build Number, OS Caption, or OS edition details. This SCCM report available in Resource Explorer provides Window 11 Upgrade Compatible Matrix.

The Windows 11 Upgrade Experience Insidcator is the new attribute that SCCM is collecting as part of hardware inventory and you can check the details from SCCM resource explorer. The Upgrade Experience Insidcator gives you a better view of Windows 11 upgrade compatibility details in a simplified way.

• Navigate to \Assets and Compliance\Overview\Devices\ and select any one of the Windows 10 devices.
• Right-click on one of the devices and select Start and click on Resource Explorer.
• Navigate to UPGRADE_EXPERIENCE_INDICATOR tab on the left side to get the details of Windows 11 upgrade compatible Windows 10 devices related details.

NOTE! – For each version of Windows 11 release, there will be a different code. The code for Windows 11 21H2 is CO21H2 and for Windows 11 22H2, it’s NI22H2.

The following table gives you the details of the Windows 11 compatibility matrix with the reason for not being compatible with some of the Windows 10 devices. These are super useful details instead of going through many complex scenarios.

Appraiser Version	Reason	Upg Ex Prop	Upg Ex U	Version
10019645	None,	Green	Green	21H1
10019645	None,	Green	Green	21H2
10019645				UNV
10019645	CpuFms, Tpm, UefiSecureBoot,	Red	Red	CO21H2

Create SCCM Collection for Windows 11 Upgrade Compatible Devices

Let’s create Create SCCM Collection for Windows 11 Upgrade Compatible Devices. This collection is limited to the All Windows 10 Devices collection so that we can avoid evaluating other devices using the WQL query.

• Navigate to \Assets and Compliance\Overview\Device Collections.
• Right-click on Device Collections -> select Create Device Collection.

Let’s start the collection creation process to group Windows 11 Upgrade compatible Windows 10 devices. I have selected the Limiting Collection as All Windows 10 Devices so that any other devices will not be part of the Windows 11 Upgrade compatible Collection.

• Name of the Collection – WIndows 11 Compatible Devices.
• Description for the collection – Based on Upgrade Experience Indicators inventory.
• Limiting Collection – I have selected All Windows 10 Devices.

Read More – Stop Using Collections Limited to All Systems or All Users.

Now, it’s time to create a dynamic collection with Windows 11 upgrade compatible devices using Query Rule (aka WQL query).

• 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.

NOTE! – You can configure multiple rules for each collection if there is a requirement. This is not required for Windows 11 upgrade compatible devices collection.

It’s time to design the WQL query criteria for Windows 11 upgrade compatible devices. You need to create two WQL query criteria for this dynamic SCCM collection creation process.

• Enter the name of the Dynamic query – Windows 11 Upgrade Compatible Devices.
• Click on Edit Query Statement to add All Windows 11 devices.

It’s time to start the WQL query design to discover Windows 11 upgrade compatible devices.

• Click on the Criteria tab
• And then Click on the Show Query Language button and copy the WQL query from the below section to complete the collection creation process.

What is Windows 11 UPGRADE EXPERIENCE INDICATORS

The SCCM collection for Windows 11 upgrade compatible devices is based on a new attribute class available on Windows devices called UPGRADE EXPERIENCE INDICATORS. The inventory details of this attribute class are collected.

I don’t see any official documentation about the attribute class UPGRADE_EXPERIENCE_INDICATORS and the two attributes mentioned below. The values of these two attributes must be GREEN to pass the compatibility test for the Window 11 upgrade.

• UpgExProp – Upg Ex Prop as per Resource Explorer.
• UpgExU – Upg Ex U as per Resource Explorer.

You need to create two different criteria(s) for Windows 11 Upgrade Compatible devices SCCM collection. The following are the two WQL queries that would help complete this task. The following is the list of Attributes available for the UPGRADE_EXPERIENCE_INDICATORS attribute class.

1. AppraiserVersion
2. GroupID
3. Reason
4. ResourceID
5. RevisionID
6. TimeStamp
7. EpgExProp
8. UpgExU
9. Version

SCCM Collection Query to check UpgExProp, UpgExU, and Version values

The following is the SCCM Collection Query to check Windows 11 UPGRADE EXPERIENCE INDICATORS UpgExProp, UpgExU, and Version values. Copy the below WQL query in the Query Statement Properties as you indicated in the above screenshot.

This WQL query helps you filter the Windows 10 devices based on the attribute values UpgExProp and UpgExU. The value for the UpgExProp and UpgExU attributes must be GREEN to pass the Windows 11 21H2 compatibility test. Also, the version must be CO21H2.

• Copy the following WQL query Query Statement Properties.
• Click OK and OK to continue.

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_UPGRADE_EXPERIENCE_INDICATORS on SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExProp = "Green" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.Version = "CO21H2" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExU = "Green"

NOTE! – Windows 11 21H2 compatibility test, you need to use and WQL query for 22H2 version of Windows 11 is given below. SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.Version = “NI22H2“

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_UPGRADE_EXPERIENCE_INDICATORS on SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExProp = "Green" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.Version = "NI22H2" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExU = "Green"

Windows 11 22H2 Compatibility Collection

Windows 11 22H2 compatibility collection query is given below.

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_UPGRADE_EXPERIENCE_INDICATORS on SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExProp = "Green" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.Version = "NI22H2" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExU = "Green"

Full Collection Update and Use Incremental Updates Settings

It’s time to configure “use incremental updates” for the SCCM collection for Windows 11 upgrade compatibility of devices. I don’t recommend configuring the incremental updates for this collection. The regular update of the SCCM collection for Windows 11 Upgrade compatible devices.

By default, the regular Full update schedule of the collection is 7 days. However, you might probably need to change the schedule in the real world to get better results. You can click on the Schedule button to change the schedule and select the custom interval – Recur every – 1 – day. 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.

• Disable the following option – Use Incremental updates for this collection.
• Regular Full Update- Schedule a full update on this collection – once every 1 day.
• Click on the Next button to continue.

The following is the Setting Summary to confirm the collection query and other details. Click on the Next, Next, Close button to finish the creation of All Windows 11 Devices.

General
• Collection Name: Windows 11 Upgrade Compatible Devices
• Comment: Based on UpgradeExperienceIndicators inventory
Membership Rules
• (Query) Windows 11 Upgrade Compatible Devices

Results – SCCM Collection for Windows 11 Upgrade Compatible Devices

You can use the SCCM collection for Windows 11 Upgrade Compatible Devices to deploy feature updates and other specific Windows 11 upgrade deployments. This also helps avoid sending Windows 11 upgrade packages to noncompatible Windows 10 devices.

Navigate to \Assets and Compliance\Overview\Devices\WIndows 11 Upgrade Compatible Devices to confirm whether the collection is working as expected.

Author