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