SCCM Dynamic Collection Based on Device Type | Collection Queries

Updated: 1 day ago


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


A dynamic or query based collection reduce the efforts required to manage a deployment as devices are automatically included or excluded in a collection based on query rules.


In this blog post, we will discuss about collection queries for virtual Devices, Desktops and Laptops. This collection queries can be used in a collection to get the desired results.




In This Article:



SCCM Collection Query for Virtual Machines:



SCCM Collection Query for Virtual Machines (Client & Server OS)


The below WMI Query Language ( WQL ) query will include all virtual machines in a collection.


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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM