SCCM Dynamic Collection for Windows 10 / 11 Devices

Updated: Oct 9

In ConfigMgr / MECM , a dynamic collection membership is based on query rules. A dynamic collection can have multiple queries and collection membership updates at each collection evaulation cycle.


In this blog post, we will discuss about dynamic collection queries for Windows 10 / Windows 11 devices.




Table of Contents

  • Dynamic Collection Queries

  • Dynamic Collection Queries for all Windows 11 22H2 devices

  • Dynamic Collection Queries for all Windows 10 21H2 devices

  • Windows 10 / 11 OS build versions


Dynamic Collection Queries


Dynamic collection queries for all Windows 11 22H2 devices



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.Version = "​10.0.22621"


Dynamic collection queries for all Windows 10 21H2 devices


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.Version = "10.0.19044"



To create a collection for other Windows 10 or Windows 11 vers