SCCM – WMI Query for task Sequences

Dell

Manufacturer is Dell:
SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE “%Dell%”

Models from Dell:
SELECT * FROM Win32_ComputerSystem WHERE Model LIKE “%Latitude E7440%”
SELECT * FROM Win32_ComputerSystem WHERE Model LIKE “%Optiplex 990%”
SELECT * FROM Win32_ComputerSystem WHERE Model LIKE “%Precision M6800%”
SELECT * FROM Win32_ComputerSystem WHERE Model LIKE “%Venue 11 Pro 7130%”

Hewlett-Packard

Manufacturer is Hewlett-Packard:
SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE “%Hewlett-Packard%”

Models from Hewlett-Packard:
SELECT * FROM Win32_ComputerSystem WHERE Model LIKE “%HP EliteBook 8540p%”
SELECT * FROM Win32_ComputerSystem WHERE Model LIKE “%HP EliteBook 8560w%”
SELECT * FROM Win32_ComputerSystem WHERE Model LIKE “%ElitePad 1000%”

Microsoft Hyper-V

SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE “%Microsoft Corporation%” AND Model LIKE “%Virtual Machine%”

VMWare

SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE “%VMware%” AND Model LIKE “%VMware Virtual Platform%”

Operating System (Windows)

Determine 32 or 64-bit Operating System:
SELECT * FROM Win32_ComputerSystem WHERE SystemType LIKE “%x64-based PC%”
SELECT * FROM Win32_ComputerSystem WHERE SystemType LIKE “%x86-based PC%”

Determine Operating System version:
SELECT * FROM WIN32_OperatingSystem WHERE Version LIKE “6.1%”
SELECT * FROM WIN32_OperatingSystem WHERE Version LIKE “6.3%”

Usefull Commands

wmic baseboard get product
wmic csproduct get name

thanks to; http://www.ronnipedersen.com/wmi-query/

 

Comments are closed.