SCCM Task Sequence WMI logic for Models Based Drivers Deployment

SCCM Task Sequence OS Drivers apply based on Models with help of WMI Query

For Models check we can write as NAMESPACE Root\CIMV2

Select *From Win32_ComputerSystem Where Model LIKE "%X260%"

The above is if WMI matches however if we want a query for not equals then ?

WMI query for if Model is not equals

Select * From Win32_ComputerSystem Where NOT Model LIKE "%M800%"

WMI Query for If Manufacture like

SELECT*From Win32_ComputerSystem WHERE Manufacturer LIKE “%Dell%”
SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE “%Hewlett-Packard%”

SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE “%Microsoft Corporation%” 

SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE “%VMware%”

WMI Query for If Manufacture NOT like

SELECT*From Win32_ComputerSystem WHERE NOT Manufacturer LIKE “%Dell%”
SELECT * FROM Win32_ComputerSystem WHERE NOT Manufacturer LIKE “%Hewlett-Packard%”

SELECT * FROM Win32_ComputerSystem WHERE NOT Manufacturer LIKE “%Microsoft Corporation%” 

SELECT * FROM Win32_ComputerSystem WHERE NOT Manufacturer LIKE “%VMware%”

Find  32 or 64-bit Operating System in task Sequence WMI logic
SELECT * FROM Win32_ComputerSystem WHERE SystemType LIKE “%x64-based PC%”
SELECT * FROM Win32_ComputerSystem WHERE SystemType LIKE “%x86-based PC%”

For BitLocker:

TO CHECK TPM model status active / this will be used for Pre-requisites for Bitlocker

NAMESPACE: Root\CIMV2\Security\MicrosoftTPM

Select * From Win32_TPM Where IsActivated_InitialValue = False

Select * From Win32_TPM Where IsActivated_InitialValue = True