Direkt zum Inhalt
Startseite It's only 1 step 2 your solution!

Windows WMI Filter Query Beispiele

Queries in WMI Filter sind eine nützliche Sache um beispielsweise Gruppenrichtlinien (GPO) filtern zu können. Allerdings auch an vielen anderen Stellen unter Windows kann man sich mit WMI Filtern gut behelfen. Wir haben eine Liste praktischer WMI Filter zusammen gestellt.

Ab Windows 10 bzw. Windows Server 2016, lauten die Versionsnummern „10.0.xxxxx“. Viele im Internet kursierende Queries verwenden diese Build- oder Versions-Nummern in Abfragen. Da sich aufgrund der Release-Updates die Versionssnummern bzw. BuildNummern im Vergleich zu früher weitaus öfters ändern, ist es aber ratsam, anstelle von Versions- oder Build-Nummern den Systemnamen (Caption) in Queries abzufragen. Dieser bleibt unabhängig von Versions-Nummern bestehen. Ein Beispiel für einen Caption ist "Microsoft Windows 10 Pro". Sie können den Caption Ihres Systems mit folgendem Befehl abfragen:
wmic os get caption /format:list

In den Query Beispielen sind bewusst an manchen Stellen Abfragen aus anderen WMI Aliasen oder Verneinungen verwendet worden um die flexibilität zu demonstrieren.

// WMI Query Beispiele

Beschreibung Query
Nur Notebooks/Mobiles

 
SELECT * FROM Win32_ComputerSystem WHERE PCSystemType="2"
Nur Desktops
SELECT * FROM Win32_ComputerSystem WHERE PCSystemType="1"
Computer in Gruppe XY
SELECT * FROM Win32_Group WHERE Domain = "dom.local" and Name="MyGroupName"
Ab Win7 mit 32 Bit
SELECT * FROM Win32_OperatingSystem WHERE (Version>="6.%" AND Producttype="1" AND OSArchitecture="32-bit")
32 Bit OS
SELECT AddressWidth FROM Win32_Processor WHERE AddressWidth="32"
64 Bit OS
SELECT AddressWidth FROM Win32_Processor WHERE AddressWidth="64"
Windows 7
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.%" AND ProductType="1"
Windows 7 32 bit
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" AND NOT OSArchitecture="64-bit"
Windows 7 64 bit
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" AND OSArchitecture="64-bit"
Windows 8 32 bit
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1" AND NOT OSArchitecture="64-bit"
Windows 8 64 bit
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1" AND OSArchitecture="64-bit"
Windows 10
SELECT * FROM Win32_OperatingSystem WHERE Version like "10.%" AND ProductType="1"
Windows 10 32 Bit
SELECT * FROM Win32_OperatingSystem WHERE Version like "10.%" AND ProductType="1" AND OSArchitecture="32-bit"
Windows 10 64 Bit
SELECT * FROM Win32_OperatingSystem WHERE Version like "10.%" AND ProductType="1" AND OSArchitecture="64-bit"
Windows 10 64 Bit (Caption)
SELECT * FROM Win32_OperatingSystem WHERE Caption like "%Windows 10%" AND OSArchitecture="64-bit"
Windows 10 32 Bit (Caption)
SELECT * FROM Win32_OperatingSystem WHERE Caption like "%Windows 10%" AND OSArchitecture="32-bit"
Windows 10 alle (Caption)
SELECT * FROM Win32_OperatingSystem WHERE Caption like "%Windows 10%"
Computername nicht gleich XY
SELECT * FROM Win32_ComputerSystem WHERE not Name like "%ComputerXY%" AND not Name like "%SomeOtherName%"
   
SERVER  
2008 Server
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.0%" AND (ProductType="2" OR Producttype="3")
2008R2 Server
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.1%" AND (ProductType="2" OR Producttype="3")
2008 – 2012R2 Server
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.%" AND (ProductType="2" OR ProductType="3")
2012 Server
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.2%" AND (ProductType="2" OR ProductType="3")
2012R2 Server
SELECT * FROM Win32_OperatingSystem WHERE Version like "6.3%" AND (ProductType="2" OR ProductType="3")
2016-2019 DCs
SELECT * FROM Win32_OperatingSystem WHERE Version like "10.%" AND ProductType="2"
2016-2019 Member Server
SELECT * FROM Win32_OperatingSystem WHERE Version like "10.%" AND ProductType="3"
2016-2019 Server
SELECT * FROM Win32_OperatingSystem WHERE Version like "10.%" AND (ProductType="2" OR Producttype="3")
2016 Server
SELECT * from Win32_OperatingSystem WHERE Caption like "%2016%" AND (ProductType="3" OR ProductType="2")
2016 Member Server
SELECT * from Win32_OperatingSystem WHERE Caption like "%2016%" AND ProductType="3"
2016 DCs
SELECT * from Win32_OperatingSystem WHERE Caption like "%2016%" AND ProductType="2"
2019 Server Built 17763 (ver 1809)
SELECT * from Win32_OperatingSystem WHERE BuildNumber=17763 AND (ProductType="3" OR ProductType="2")
2019 Server
SELECT * from Win32_OperatingSystem WHERE Caption like "%2019%" AND (ProductType="3" OR ProductType="2")
Member Server
SELECT * FROM Win32_OperatingSystem WHERE ProductType="3"
Domain Controller
SELECT * FROM Win32_OperatingSystem WHERE ProductType="2"
Server
SELECT * from Win32_OperatingSystem WHERE (ProductType="3" OR ProductType="2")

 

// Zusätzliche Informationen

Derzeitige Windows Versions- bzw. Build-Nummern

Operating System Version / Build Date
SERVER    
Windows Server 2003 (Beta?) 5.2.3763  
Windows Server 2003 5.2.3790 24.04.2003
Windows Server 2003, Service Pack 1 5.2.3790.1180  
Windows Server 2003 5.2.3790.1218  
Windows Home Server 5.2.3790 16.06.2007
Windows Server 2008 6.0.6001 27.02.2008
Windows Server 2008 R2, RTM (Release to Manufacturing) 6.1.7600.16385 22.10.2009
Windows Server 2008 R2, SP1 6.1.7601  
Windows Home Server 2011 6.1.8400 05.04.2011
Windows Server 2012 6.2.9200 04.09.2012
Windows Server 2012 R2 6.3.9200 18.10.2013
Windows Server 2016 (1607) 10.0.14393 26.09.2016
Windows Server 2016 (1709) 10.0.16299 17 October 2017
Windows Server 2016 (1803) 10.0.17134 30 April 2018
Windows Server 2019 10.0.17677 2018
     
CLIENTS    
Windows 2000 (Beta 3) 5.00.2031  
Windows 2000 (Beta 3 RC2) 5.00.2128  
Windows 2000 (Beta 3) 5.00.2183  
Windows 2000 5.00.2195 17.02.2000
Windows XP (RC 1) 5.1.2505  
Windows XP 5.1.2600 25.10.2001
Windows XP, Service Pack 1 5.1.2600.1105-1106  
Windows XP, Service Pack 2 5.1.2600.2180  
Windows XP, Service Pack 3 5.1.2600 21.04.2008
Windows Vista, Beta 1 6.0.5112 20.07.2005
Windows Vista, Community Technology Preview (CTP) 6.0.5219 30.08.2005
Windows Vista, TAP Preview 6.0.5259 17.11.2005
Windows Vista, CTP (Dezember) 6.0.5270 14.12.2005
Windows Vista, CTP (Februar) 6.0.5308 17.02.2006
Windows Vista, CTP (Refresh) 6.0.5342 21.03.2006
Windows Vista, April EWD 6.0.5365 19.04.2006
Windows Vista, Beta 2 Previw 6.0.5381 01.05.2006
Windows Vista, Beta 2 6.0.5384 18.05.2006
Windows Vista, Pre-RC1 6.0.5456 20.06.2006
Windows Vista, Pre-RC1, Build 5472 6.0.5472 13.07.2006
Windows Vista, Pre-RC1, Build 5536 6.0.5536 21.08.2006
Windows Vista, RC1 6.0.5600.16384 29.08.2006
Windows Vista, Pre-RC2 6.0.5700 10.08.2006
Windows Vista, Pre-RC2, Build 5728 6.0.5728 17.09.2006
Windows Vista, RC2 6.0.5744.16384 03.10.2006
Windows Vista, Pre-RTM, Build 5808 6.0.5808 12.10.2006
Windows Vista, Pre-RTM, Build 5824 6.0.5824 17.10.2006
Windows Vista, Pre-RTM, Build 5840 6.0.5840 18.10.2006
Windows Vista, RTM (Release to Manufacturing) 6.0.6000.16386 01.11.2006
Windows Vista 6.0.6000 08.11.2006
Windows Vista, Service Pack 2 6.0.6002 04.02.2008
Windows 7, RTM (Release to Manufacturing) 6.1.7600.16385 22.10.2009
Windows 7 6.1.7600 22.10.2009
Windows 7, Service Pack 1 6.1.7601  
Windows 8 6.2.9200 26.10.2012
Windows Phone 8 6.2.10211 29.10.2012
Windows 8.1 6.3.9200 17.10.2013
Windows 8.1, Update 1 6.3.9600 08.04.2014
Windows 10 (1507) 10.0.10240 29.07.2015
Windows 10 (1511) 10.0.10586 10.11.2015
Windows 10 (1607) 10.0.14393 02.08.2016
Windows 10 (1703) 10.0.15063 05.04.2017
Windows 10 (1709) 10.0.16299 17.10.2017
Windows 10 (1803) 10.0.17134 30.04.2018
Windows 10 (1809) 10.0.17763 02.10.2018
Windows 10 (1903) 10.0.18362 19.05.2019

ProductType Werte (Alias win32_operatingsystem)

Value Version
1 Client versions of Windows
2 Server versions of Windows that are operating as a domain controller
3 Server versions of Windows that are not operating as a domain controller (typically referred to as member servers)

PCSystemType Werte (Alias win32_computersystem)

Value System Type
0 Unspecified
1 Desktop
2 Mobile
3 Workstation
4 Enterprise Server
5 Small Office and Home Office (SOHO) Server
6 Appliance PC
7 Performance Server
8 Maximum

 

Benötigen Sie weitere Informationen oder Hilfestellung? Treten Sie mit uns in Kontakt.