Close Menu
    Trending

    WMI Query

    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