Windows OS Hub
  • Windows Server
    • Windows Server 2016
    • Windows Server 2012 R2
    • Windows Server 2012
    • Windows Server 2008 R2
    • SCCM
  • Active Directory
    • Group Policies
  • Windows Clients
    • Windows 10
    • Windows 8
    • Windows 7
    • MS Office
    • Outlook
  • Virtualization
    • VMWare
    • Hyper-V
  • PowerShell
  • Exchange
  • Home
  • About

Windows OS Hub

  • Windows Server
    • Windows Server 2016
    • Windows Server 2012 R2
    • Windows Server 2012
    • Windows Server 2008 R2
    • SCCM
  • Active Directory
    • Group Policies
  • Windows Clients
    • Windows 10
    • Windows 8
    • Windows 7
    • MS Office
    • Outlook
  • Virtualization
    • VMWare
    • Hyper-V
  • PowerShell
  • Exchange

 Windows OS Hub / SCCM / SCCM and WMI Query to Find All Laptops and Desktops

March 24, 2016 SCCM

SCCM and WMI Query to Find All Laptops and Desktops

To install special software on all portable devices of the company it was necessary to build an SCCM collection, which would include all laptops (an other portable mobile systems) in a corporate network. At once I could not find the system property to explicitly identify a computer as a laptop or a desktop.

To begin with, I tried to filter portable devices using WMI filters of GPO and install software to them using group policies. There were several variants to create WMI queries by means of checking:

  • Battery status (only laptops have it): SELECT * FROM Win32_Battery WHERE (BatteryStatus <> 0)
  • RAM type (SODIMM for laptops): Select * from Win32_PhysicalMemory WHERE (FormFactor = 12)
  • PCSystemType properties: SELECT * FROM Win32_ComputerSystem WHERE PCSystemType = 2
Note. Possible PCSystemType values

Value System Type
0 Unspecified
1 Desktop
2 Mobile
3 Workstation
4 Enterprise Server
5 Small Office and Home Office (SOHO) Server
6 Appliance PC
7 Performance Server
8 Maximum

Each of these queries has its advantages and disadvantages. In theory, the most optimal one should be the filtration by PCSystemType value, but this class appeared only in Vista, and we have many computers running the obsolete Windows XP, which won’t be filtered using this queries.

A WMI queries to determine ChassisTypes, being a part of Win32_SystemEnclosure class has seemed more interesting:

WMI-Explorer ChassisTypes

The possible values of ChassisTypes are given in the table below.

ChassisTypes Value System Type
1 Other
2 Unknown
3 Desktop (including virtual machines)
4 Low Profile Desktop
5 Pizza Box
6 Mini Tower
7 Tower
8 Portable
9 Laptop
10 Notebook
11 Hand Held
12 Docking Station
13 All in One
14 Sub Notebook
15 Space-Saving
16 Lunch Box
17 Main System Chassis
18 Expansion Chassis
19 Sub Chassis
20 Bus Expansion Chassis
21 Peripheral Chassis
22 Storage Chassis
23 Rack Mount Chassis
24 Sealed-Case PC

Thus, the following Chassis Types are typical to:

  • laptops: 8 , 9, 10, 11, 12, 14, 18, 21
  • desktops: 3, 4, 5, 6, 7, 15, 16
  • servers: 17,23

The final version of a WMI filter looks like this:

select * from Win32_SystemEnclosure where ChassisTypes = "8" or ChassisTypes = "9" or ChassisTypes = "10" or ChassisTypes = "11" or ChassisTypes = "12" or ChassisTypes = "14" or ChassisTypes = "18" or ChassisTypes = "21"

This WMI filter can be easily transformed into an SCCM query, which allows to build a collection with all laptops in the network.

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 query to find laptops

Finally, to provide a comprehensive view about the quantitative ratio of desktops and laptops in the network, you can make an SCCM report:

SELECT
CASE ChassisTypes0
WHEN '8' THEN 'Notebooks'
WHEN '9' THEN 'Notebooks'
WHEN '10' THEN 'Notebooks'
WHEN '11' THEN 'Notebooks'
WHEN '12' THEN 'Notebooks'
WHEN '14' THEN 'Notebooks'
WHEN '18' THEN 'Notebooks'
ELSE 'Desktops'
END AS "Workstation Type", count(distinct sys.name0) as ClientCount from
v_GS_SYSTEM_ENCLOSURE ENC
INNER JOIN
v_R_System SYS ON ENC.ResourceID = SYS.ResourceID
WHERE
sys.client0=1 AND sys.obsolete0=0 AND active0=1
GROUP BY
CASE ChassisTypes0
WHEN '8' THEN 'Notebooks'
WHEN '9' THEN 'Notebooks'
WHEN '10' THEN 'Notebooks'
WHEN '11' THEN 'Notebooks'
WHEN '12' THEN 'Notebooks'
WHEN '14' THEN 'Notebooks'
WHEN '18' THEN 'Notebooks'
ELSE 'Desktops'
END
ORDER BY 2 desc

In our case, the proportion of desktop PCs and laptops is 2832 to 109.

sccm report with laptops / desktops countSo, we have considered how to create an SCCM collection or a GPO WMI filter that allows to select all laptops in the network using ChassisTypes attribute of SystemEnclosure class.

6 comments
0
Facebook Twitter Google + Pinterest
previous post
FAQ: Windows Server 2016 Licensing
next post
Schedule Task to Start When Another Task Finishes

Related Reading

Upgrading Windows 10 Build with Setup.exe Command-Line Switches

May 28, 2020

Converting SCCM WQL Query to SQL

April 1, 2019

How to Automatically Uninstall All Previous Office Versions...

June 28, 2018

Windows Update Error 0x80244022 and WsusPool Memory Limit

December 8, 2017

Configuring Remote Control in SCCM 2012

May 6, 2016

6 comments

Peter Huiskens December 11, 2019 - 8:55 am

If you have any surface devices in your organization, do not use the memory selection. only use chassis form factor.

Memory form factor of so-dim is incorrectly returned on surface devices, and therefor seen as desktop memory.

Reply
Ben February 28, 2020 - 3:30 am

gpresult using that wmi filter shows denied for a surface with chassis type 9, which is included. in your query. I saw another article that says you can’t use a chassis type array in WMI filter?

Reply
Ben February 28, 2020 - 3:31 am

I haven’t been able to get this to work. All the notebooks and tablets are getting denied by the WMI filter. Many thanks for any help.

Reply
Peter Huiskens February 28, 2020 - 8:40 am

in the end i haven’t set that one up,
i do use the wmi filter for a gpo , i’ll post that in a minute, that one filters out all mobile devices vs desktops.
we use it for filesync ( homedrive sync on or of…)
for now what i use to identify the surface models in sccm:
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.ResourceId = SMS_R_System.ResourceId WHERE Model LIKE “%Surface%”

Reply
Peter Huiskens February 28, 2020 - 8:46 am

the gpo wmi filter we use is:
root\CIMv2
Select PCSystemType from Win32_ComputerSystem WHERE (PCSystemType=2)

that seems to work quite well

Reply
Framelite December 8, 2020 - 8:33 pm

According to the SMBIOS System Reference Specifications version 3.4.0 dated 2020-07-17, there are some new ChassisType values. It now goes all the way from 1 to 36 (byte value 01h to 24h). It’s pretty easy to find the full specification in .pdf format online and what you’re looking for in it is Table 17 (System Enclosure or Chassis Types).

Reply

Leave a Comment Cancel Reply

Categories

  • Active Directory
  • Group Policies
  • Exchange
  • Windows 10
  • Windows 8
  • Windows 7
  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows Server 2008 R2
  • PowerShell
  • VMWare
  • MS Office

Recent Posts

  • How to Troubleshoot, Repair and Rebuild the WMI Repository?

    March 2, 2021
  • Accessing USB Flash Drive from VMWare ESXi

    February 26, 2021
  • How to Sign a PowerShell Script (PS1) with a Code Signing Certificate?

    February 25, 2021
  • Change the Default Port Number (TCP/1433) for a MS SQL Server Instance

    February 24, 2021
  • How to Shadow (Remote Control) a User’s RDP session on RDS Windows Server 2016/2019?

    February 22, 2021
  • Configuring PowerShell Script Execution Policy

    February 18, 2021
  • Configuring Proxy Settings on Windows Using Group Policy Preferences

    February 17, 2021
  • Updating Group Policy Settings on Windows Domain Computers

    February 16, 2021
  • Managing Administrative Shares (Admin$, IPC$, C$, D$) in Windows 10

    February 11, 2021
  • Packet Monitor (PktMon) – Built-in Packet Sniffer in Windows 10

    February 10, 2021

Follow us

woshub.com
  • Facebook
  • Twitter
  • RSS
Popular Posts
  • Windows Update Error 0x80244022 and WsusPool Memory Limit
  • Configuring Remote Control in SCCM 2012
Footer Logo

@2014 - 2018 - Windows OS Hub. All about operating systems for sysadmins


Back To Top