How to Create SCCM Device Collection Based on Computer Hardware Details | ConfigMgr

SCCM provider WMI server classes can be used to retrieve computer hardware related information from site database. These attribute classes can be used to create query based collection based on hardware information. A collection or query created in Configuration Manager uses WMI Query Language (WQL) to request objects from the SMS Provider WMI Schema, which in turn retrieves the data from site database.

Below are the most commonly used attribute classes used for SCCM Queries and dynamic collections based on computer hardware details.

Computer System: The Computer System attribute class (SMS_G_System_COMPUTER_SYSTEM) Windows Management Instrumentation (WMI) class) is an SMS Provider server class in Configuration Manager. This class contains hardware information (Model, Manufacturer etc) of computer system. The information are collected by hardware inventory.

PC BIOS: The PC BIOS attribute class (SMS_G_System_PC_BIOS) Windows Management Instrumentation (WMI) class) is an SMS Provider server class in Configuration Manager. This class contains hardware information (BIOS Version, BIOS Serial Number etc.) of computer. The information are collected by hardware inventory.

System Enclosure: The System Enclosure attribute class (SMS_G_System_SYSTEM_ENCLOSURE) Windows Management Instrumentation (WMI) class) is an SMS Provider server class in Configuration Manager. This class contains System Enclosure information (Chassis Types, Manufacturer, Model etc.) of computer.

TPM : The TPM attribute class (SMS_G_System_TPM) Windows Management Instrumentation (WMI) class) is an SMS Provider server class in Configuration Manager. This class contains information about Trusted Platform Module ( TMP ) manufacturer, version, activation status etc.

Firmware : The Firmware attribute class (SMS_G_System_firmware) Windows Management Instrumentation (WMI) class) is an SMS Provider server class in Configuration Manager. This class contains information about Firmware such as secure boot.

Memory: The Memory attribute class (SMS_G_System_X86_PC_MEMORY) Windows Management Instrumentation (WMI) class) is an SMS Provider server class in Configuration Manager. This class contains information about physicals memory of computers.

Related post: If you are looking for step by step process to create a dynamic / query based collection then follow this article : How to Create Dynamic Collection in SCCM

Other posts in this series:

• SCCM Collection Queries for Opearting System Attribute Class
• SCCM Collection Queries for System Resource (SMS_R_System) Attribute Class

SCCM device collection based on Hardware Model

The below WQL query will add all workstations in device collection which computer hardware model is HP ProDesk 400 G5 Desktop Mini. If you are using query designer then select the below attribute class and attribute name. Otherwise you can also copy the below WQL query and paste that directly in query editor. Save and update the membership for collection to see the result.

Attributes to select from Query Designer

Attribute Class : Computer System

Attribute Name : Model

SCCM Collection Query / WQL Query

select distinct 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.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model = "HP ProDesk 400 G5 Desktop Mini"

SCCM device collection based on Device Manufacturer

The below collection query can be used to create a dynamic collection for all computer hardware based on device manufacturer such as HP , Dell , Lenovo etc. If you are using query designer then select the below attribute class and attribute name. Otherwise you can also copy the below WQL query and paste that directly in query editor.

Attributes to select from Query Designer

Attribute Class : Computer System

Attribute Name : Manufacturer

SCCM Collection Query / WQL Query

Collection membership query to include all HP computers in device collection.

select distinct 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.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Manufacturer = "HP"    

SCCM device collection for all computers with specific BIOS version

The below collection query can be used to create a dynamic collection for all computers with specific BIOS version. The PC BIOS attribute class (SMS_G_System_PC_BIOS WMI class contain these information. The below query will include all computers which BIOS version is “HPQOEM – 0, R23 Ver. 02.03.00, HP – 20300” to the collection.

Attributes to select from Query Designer

Attribute Class : PC BIOS

Attribute Name : BIOS Version

SCCM Collection Query / WQL Query

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_PC_BIOS on SMS_G_System_PC_BIOS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_PC_BIOS.BIOSVersion = "HPQOEM - 0, R23 Ver. 02.03.00, HP - 20300"

SCCM device collection Based on Device Types (Laptops or Desktops)

The System Enclosure attribute class can be used to identify device type (Desktop, Laptop, Tablets etc.) The information can be used to create a collection for Laptops or Desktops. You can find more details about System Enclosure Chassis Types in our post Enclosure Chassis Types Value & Description

The below WQL query will add all laptops in device collection. You can find more examples for laptop, desktop and virtual machine device collection in another post SCCM Dynamic Collection Based on Device Type

Attributes to select from Query Designer

Attribute Class : System Enclosure

Attribute Name : Chassis Types

SCCM Collection Query / WQL Query

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_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId where  SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in("8","9","10","11","12","14","18","21")

SCCM Device collection for the computers with TPM 2.0

The below collection membership query will include all computers with TMP version 2.0 * in device collection.

Attributes to select from Query Designer

Attribute Class : TPM

Attribute Name : Spec Version

SCCM Collection Query / WQL Query

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_TPM on SMS_G_System_TPM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_TPM.SpecVersion like "2.0%"

SCCM Device collection for all computers with legacy BIOS

The below collection membership query will include all computers with with legacy BIOS in device collection.

Attributes to select from Query Designer

Attribute Class : Firmware

Attribute Name : UEFI

SCCM Collection Query / WQL Query

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_FIRMWARE on SMS_G_System_FIRMWARE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_FIRMWARE.UEFI = "0"

SCCM Device collection for all computers where SecureBoot not enabled

Attributes to select from Query Designer

Attribute Class : Firmware

Attribute Name : Secure Boot

SCCM Collection Query / WQL Query

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_FIRMWARE on SMS_G_System_FIRMWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_FIRMWARE.SecureBoot = "0"

SCCM Device collection for all computers where Total RAM is less than or Equal to 4 GB

Attributes to select from Query Designer

Attribute Class : Memory

Attribute Name : Total Physical Memory (KB)

SCCM Collection Query / WQL Query

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_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceId = SMS_R_System.ResourceId where SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory <= 4194304

SCCM Device collection for all computers which are compatible with Windows 11

The below collection membership query will include all computers in device collection which are compatible with Windows 11. This will be based on following criteria. The collection can be used to target in place upgrade task sequence.

• UEFI is enabled
• Secure Boot is enabled
• TPM version is compatible with Windows 11

Attributes to select from Query Designer

Attribute Class : Firmware & TPM

Attribute Name : Firmware – UEFI, Firmware – SecureBoot , TPM – Spec Version

SCCM Collection Query / WQL Query

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_FIRMWARE on SMS_G_System_FIRMWARE.ResourceId = SMS_R_System.ResourceId inner join SMS_G_System_TPM on SMS_G_System_TPM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_FIRMWARE.UEFI = "1" and SMS_G_System_FIRMWARE.SecureBoot = "1" and SMS_G_System_TPM.SpecVersion in ("2.0, 0, 1.16","2.0, 0, 1.38")

Related Posts:

• How to Create Dynamic Collection in SCCM
• Enclosure Chassis Types Value & Description | ConfigMgr | SCCM
• ConfigMgr: Maintenance Window for member of specific collection – SQL Query
• SCCM Dynamic Collection for Windows 10 / 11 Devices
• SCCM Device Collection Equivalents in Microsoft Intune for App Deployment
• SCCM Dynamic Collection Based on Device Type | Collection Queries
• SCCM Collection Based on Operating System Optional Features
• SCCM Device Collection Based on Installed Software Products & Inventoried Files
• SCCM Device Collection Based on Computer Hardware Details
• SCCM Collection Queries for Opearting System Attribute Class
• SCCM Collection Queries for System Resource (SMS_R_System) Attribute Class
• SCCM Dynamic Collection using Application Deployment Status
• SCCM Dynamic Collection Based on Configuration Baseline Compliance Status
• How to Create , View and Organize SCCM Maintenance Windows
• How to Provision Windows 10 / 11 Device using Intune and Windows Autopilot