NEW Some Win11 Desktops Not Reporting as 11 in SCCM

[Greg Shafer]

I have multiple dynamic device collections within SCCM based on OS based on queries. Some of my workstations, however, are not properly reporting in the correct group. The workstations that have not reported correctly have all been in-place upgrades from 10 to 11. It is also not all in-place upgrades, but there are a few. The OS build reports correctly in both SCCM and ADUC (26100), but still appear in Windows 10 collections. I have not been able to find any specific constant between any of these workstations - different Win10 builds upgraded to 24H2, different subnets/boundary groups, different hardware vendors, etc.

In my Windows 10 20H2 group, I show 2 Windows 11 workstations. In Windows 10 21H2, I also show 2 Windows 11 workstaitons, and in 22H2, I show 4 Windows 11 workstations. I have tested the queries in SCCM, and everything still shows up the same in reporting these 11 builds as 10. This does not appear to be happening in server collections. I am curious as to what might cause this, has anyone else seen this before, and what might be the fix to get these workstations to report in the correct collections.

My query for 22H2 is a query rule that uses incremental updates and the following query (similar queries for other OS builds)-

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 = "19045"

 

[Greg Shafer]

A couple of items to add...
The limiting collection for the above query is for all Windows 10 workstations.
The query for Windows 10 workstations is as follows, with a limiting collecton of all systems.

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 10 Enterprise" or SMS_G_System_OPERATING_SYSTEM.Caption = "Windows 10 Pro"

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_R_System.OperatingSystemNameandVersion like "%Workstation 10%" and   SMS_G_System_OPERATING_SYSTEM.Caption like "%Windows 10 Pro%"