====== Utiliser les requêtes WMI sous Powershell ======

Voici comment on peut interroger à distance une information contenu dans les Windows Management Instrumentation (WMI) d'un poste.

<sxh Powershell>
$remoteuserlist = Get-WmiObject -query "SELECT * FROM Win32_UserAccount WHERE LocalAccount = 'True' and Name != 'Guest'" –computername $PC -verbose
</sxh>

Pour tester les requêtes, on peut utiliser l'application WMI Explorer disponible sur ce [[https://github.com/vinaypamnani/wmie2/releases|site]]\\

{{:script:powershell:wmi_explorer.png?nolink&600}}\\

Exemple de requête:
^Nom^Description^Espace de noms^Requête^
|Client Windows 10|Afficher la Version,le ProductType et l'architecture quand les postes sont sous Windows 10|root\CIMv2|select Version,ProductType,OSArchitecture from Win32_OperatingSystem where (Version like "10.%") and ProductType = "1"|
|Client Windows 10 x86|Afficher la Version,le ProductType et l'architecture quand les postes sont sous Windows 10 32 bit|root\CIMv2|select Version,ProductType,OSArchitecture from Win32_OperatingSystem where (Version like "10.%") and ProductType = "1" and OSArchitecture="32 bits"|
|Client Windows 10 x64|Afficher la Version,le ProductType et l'architecture quand les postes sont sous Windows 10 64 bit|root\CIMv2|select Version,ProductType,OSArchitecture from Win32_OperatingSystem where (Version like "10.%") and ProductType = "1" and OSArchitecture="64 bits"|
|Windows 10 Enterprise|Afficher la Version,le ProductType et l'architecture quand les postes sont sous Windows 10 Entreprise|root\CIMv2|SELECT Version, ProductType, Caption FROM Win32_OperatingSystem WHERE Version LIKE '10.%' AND ProductType='1' AND Caption LIKE '%Ent%'|
|Windows Server 2012|-|root\CIMv2|select * from Win32_OperatingSystem where Version like "6.2%" and ProductType = "3"|
|Windows 8|-|root\CIMv2|select * from Win32_OperatingSystem where Version like "6.2%" and ProductType = "1"|
|Windows Server 2008 R2|-|root\CIMv2|select * from Win32_OperatingSystem where Version like "6.1%" and ProductType = "3"|
|Windows 7|-|root\CIMv2|select * from Win32_OperatingSystem where Version like "6.1%" and ProductType = "1"|
|Windows 7 Enterprise|WMI Filter : Only Windows 7 Enterprise Editions|root\CIMv2|SELECT Version, ProductType, Caption FROM Win32_OperatingSystem WHERE Version LIKE '6.1.%' AND ProductType='1' AND Caption LIKE '%Ent%'|
|Windows Server 2008|-|root\CIMv2|select * from Win32_OperatingSystem where Version like "6.0%" and ProductType = "3"|
|Windows Vista|-|root\CIMv2|select * from Win32_OperatingSystem where Version like "6.0%" and ProductType = "1"|
|Windows Server 2003|-|root\CIMv2|select * from Win32_OperatingSystem where Version like "5.2%" and ProductType = "3"|
|Windows XP|-|root\CIMv2|select * from Win32_OperatingSystem where (Version like "5.1%" or Version like "5.2%") and ProductType = "1"|
|Résolution 16:9|Sortir la résolution de l'écran d'un poste dans la résolution à un ratio 16:9|root\CIMv2|SELECT ScreenWidth, ScreenHeight FROM Win32_DesktopMonitor WHERE ScreenWidth='1280' AND ScreenHeight='800' OR ScreenWidth='1440' AND ScreenHeight='900' OR ScreenWidth='1680' AND ScreenHeight='1050' OR ScreenWidth='1920' AND ScreenHeight='1080' OR ScreenWidth='1280' AND ScreenHeight='768'|
|Résolution 4:3|Sortir la résolution de l'écran d'un poste dans la résolution à un ratio 4:3|root\CIMv2|SELECT ScreenWidth, ScreenHeight FROM Win32_DesktopMonitor WHERE ScreenWidth='1024' AND ScreenHeight='768'|
|Résolution 5:4|Sortir la résolution de l'écran d'un poste dans la résolution à un ratio 5:4|root\CIMv2|SELECT ScreenWidth, ScreenHeight FROM Win32_DesktopMonitor WHERE ScreenWidth='1280' AND ScreenHeight='1024'|
|Serveur|Sortir uniquement les serveurs|root\CIMv2|Select * from Win32_ComputerSystem where DomainRole <> 0 and DomainRole <>1|
|OS x86|Filtre les systèmes d'exploitation en x86|root\CIMv2|SELECT AddressWidth FROM Win32_Processor WHERE AddressWidth='32'|
|OS x64|Filtre les systèmes d'exploitation en x64|root\CIMv2|SELECT AddressWidth FROM Win32_Processor WHERE AddressWidth='64'|
|Laptops|Filtre les postes Laptops qui possèdent un [[script:powershell:query_wmi:battery|status de batterie]]|root\CIMv2|Select * from Win32_Battery WHERE (BatteryStatus <> 0)|

Retrouver le driver matériel utilisé par le Wifi:
<sxh Powershell>
Get-Ciminstance -classname Win32_PnPSignedDriver | Select-Object DeviceName, DriverVersion, Manufacturer, DeviceClass | Where-Object {($_.DeviceName -like ((Get-CimInstance -ClassName Win32_NetworkAdapter | Where-Object netconnectionid -eq 'Wi-Fi').name))} | Out-GridView
</sxh>

Dell
Manufacturer is Dell:
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE "%Dell%"</sxh>

Models from Dell:
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%Latitude E7440%"</sxh>
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%Optiplex 990%"</sxh>
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%Precision M6800%"</sxh>
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%Venue 11 Pro 7130%"</sxh>

Hewlett-Packard
Manufacturer is Hewlett-Packard:
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE "%Hewlett-Packard%"</sxh>

Models from Hewlett-Packard:
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%HP EliteBook 8540p%“</sxh>
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%HP EliteBook 8560w%"</sxh>
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%ElitePad 1000%"</sxh>

Lenovo
Manufacturer is Lenovo:
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE "%Lenovo%"</sxh>

Models from Lenovo:
<sxh>SELECT * FROM Win32_ComputerSystemProduct WHERE Version LIKE "%ThinkPad T420%"</sxh>
<sxh>SELECT * FROM Win32_ComputerSystemProduct WHERE Version LIKE "%ThinkPad W520%"</sxh>
<sxh>SELECT * FROM Win32_ComputerSystemProduct WHERE Version LIKE "%ThinkPad Edge E330%"</sxh>
<sxh>SELECT * FROM Win32_ComputerSystemProduct WHERE Version LIKE "%ThinkPad Tablet 2%"</sxh>

Microsoft Hyper-V
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE "%Microsoft Corporation%" AND Model LIKE "%Virtual Machine%"</sxh>

VMWare
<sxh>SELECT * FROM Win32_ComputerSystem WHERE Manufacturer LIKE "%VMware%" AND Model LIKE "%VMware Virtual Platform%"</sxh>