The following WMI queries can be used as inspiration when working with driveres and other OS Deployment stuff…
IMPORTANT: If you copy/paste these queries, you might need to replace the quotes, as they often change format when you copy them from a website.
Dell | Hewlett-Packard | Lenovo | Microsoft | VMWare | Operating System
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%”
Lenovo
Manufacturer is Lenovo:
SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE “%Lenovo%”
Models from Lenovo:
SELECT * FROM Win32_ComputerSystemProduct WHERE Version LIKE “%ThinkPad T420%”
SELECT * FROM Win32_ComputerSystemProduct WHERE Version LIKE “%ThinkPad W520%”
SELECT * FROM Win32_ComputerSystemProduct WHERE Version LIKE “%ThinkPad Edge E330%”
SELECT * FROM Win32_ComputerSystemProduct WHERE Version LIKE “%ThinkPad Tablet 2%”
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
wmic csproduct get vendor, version
wmic computersystem get model,name,manufacturer,systemtype
