Device Collection of all Workstations
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:
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_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId =
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%"
Chief Technical Architect and Enterprise Mobility MVP since 2016. Nickolaj has been in the IT industry for the past 10 years specializing in Enterprise Mobility and Security, Windows devices and deployments including automation. Awarded as PowerShell Hero in 2015 by the community for his script and tools contributions. Creator of ConfigMgr Prerequisites Tool, ConfigMgr OSD FrontEnd, ConfigMgr WebService to name a few. Frequent speaker at conferences and user groups.