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

Creating SCCM device collections based on computer hardware details allows administrators to target deployments, compliance settings, and reporting more effectively. This step‑by‑step guide explains how to build collections using attributes such as processor type, memory, disk size, and other hardware inventory data in Configuration Manager. By leveraging WQL queries and hardware inventory, you can design dynamic collections that simplify management and improve precision in your SCCM environment.”

Below are the most commonly used hardware attribute classes for SCCM queries and dynamic device collections in Configuration Manager. These attributes help administrators build collections based on computer hardware details such as processor, memory, disk size, and model.

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 the computer system. The information is 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 the computer. The information is 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 the 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 the 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 the physical memory of computers.

Related post: If you are looking for a 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 Operating System Attribute Class
• SCCM Collection Queries for System Resource (SMS_R_System) Attribute Class

SCCM device collection based on Hardware Model

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

Attributes to select from the 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 query below can be used to create a dynamic collection for all computer hardware based on device manufacturers such as HP, Dell, Lenovo, etc. If you are using the query designer, then select the attribute class and attribute name below. Otherwise, you can also copy the below WQL query and paste it directly into the query editor.

Attributes to select from the Query Designer

Attribute Class: Computer System

Attribute Name: Manufacturer

SCCM Collection Query / WQL Query

Collection membership query to include all HP computers in the 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 a specific BIOS version

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

Attributes to select from the 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, Tablet, 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 WQL query below will add all laptops to the 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 the 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 the device collection.

Attributes to select from the 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 legacy BIOS in the device collection.

Attributes to select from the 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 is not enabled

Attributes to select from the 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 the total RAM is less than or Equal to 4 GB

Attributes to select from the 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 that are compatible with Windows 11

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

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

Attributes to select from the 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