If you need to create a Device Collection in System Center 2012 Configuration Manager that shows you only workstations (not laptops and virtual machines), you can create a query that consists of two criteria, System Enclosure – Chassis Type and Computer System – System Manufacturer.

Here’s the query to show only Dell workstations:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM_ENCLOSURE
on SMS_G_System_SYSTEM_ENCLOSURE.ResourceId = SMS_R_System.ResourceId inner join
SMS_R_System.ResourceId where SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes
in ("3","4","5","6","7","13") and SMS_G_System_COMPUTER_SYSTEM.Manufacturer like "%Dell%"

Nickolaj Andersen
Principal Consultant and Enterprise Mobility MVP. Nickolaj has been in the IT industry for the past 10 years specializing in Enterprise Mobility and Security, Windows deployments and Automation. In 2015 Nickolaj was awarded as PowerShell Hero by the community for his script and tools contributions. Author of ConfigMgr Prerequisites Tool, ConfigMgr OSD FrontEnd, ConfigMgr WebService and a frequent speaker at user groups.


There are no comments.

Leave a Reply