WMI Abfragen richtig einsetzen Teil 2

image_pdfimage_print

WMI Filter für Gruppenrichtlinien, richtig definiert und eingesetzt, sind wahre Helfer bei der Zielbestimmung Teil 2.

WMI Filter für Betriebssysteme
SELECT Version,ProductType FROM Win32_OperatingSystem WHERE Version LIKE “<Version>” AND ProductType = “1”

WMI Filter für Windows 10 inkl. Build Nummer
SELECT Version,BuildNumber,ProductType FROM Win32_OperatingSystem WHERE Version LIKE “<Version>” AND BuildNumber = “<Build>” AND ProductType = “1”

WMI Filter für Serversysteme
SELECT Version,ProductType FROM Win32_OperatingSystem WHERE Version LIKE “<Version>” AND ( ProductType = “2” or ProductType = “3” )

WMI Filter für Windows Server 2016 inkl. Build Nummer
SELECT Version,BuildNumber,ProductType FROM Win32_OperatingSystem WHERE Version LIKE “<Version>” AND BuildNumber = “<Build>” AND ( ProductType = “2” or ProductType = “3” )

Versionsnummer für Windows 10:
Windows 10:   10.0%
Windows 10 Version 1809:      10.0.17763
Windows 10 Version 1803:      10.0.17134
Windows 10 Version 1709:      10.0.16299
Windows 10 Version 1703:      10.0.15063
Windows 10 Version 1607:      10.0.14393
Windows 10 Version 1511:      10.0.10586
Windows 10 Version 1507:      10.0.10240

Build Nummern für Windows 10:
Windows 10 Version 1803: 17763
Windows 10 Version 1803: 17134
Windows 10 Version 1709: 16299
Windows 10 Version 1703: 15063
Windows 10 Version 1607: 14393
Windows 10 Version 1511: 10586
Windows 10 Version 1507: 10240

Versionsnummer für Windows Server 2016
Windows Server 2016:       10.0%
Windows Server 2016 Version 1809: 10.0.17763
Windows Server 2016 Version 1803: 10.0.17134
Windows Server 2016 Version 1709: 10.0.16299
Windows Server 2016 Version 1607: 10.0.14393

Produkt Typ Nummern:
Client:                          ProductType=”1″
Server:                         ProductType=”3″
Domain Controller:   ProductType=”2″

WMI Filter für Office Produkte
SELECT path,filename,extension,version FROM CIM_DataFile WHERE (path=’\\Program Files\\Microsoft Office\\<Folder>\\’ OR path=’\\Program Files (x86)\\Microsoft Office\\<Folder>\\’) AND filename=’winword’ AND extension=’exe’ AND version > ‘<Version>’

SELECT path,filename,extension,version FROM CIM_DataFile WHERE (path=’\\Program Files\\Microsoft Office\\Office16\\’ OR path=’\\Program Files (x86)\\Microsoft Office\\Office16\\’) AND filename=’winword’ AND extension=’exe’ AND version > ’16’

Folder Angaben
Microsoft Office 2016:  Office16 / 16.0
Microsoft Office 2013:  Office15 / 15.0
Microsoft Office 2010:  Office14 / 14.0
Microsoft Office 2007:  Office13 / 13.0
Microsoft Office 2003:  Office12 / 13.0

WMI Filter für Windows und Office

WMI Abfragen richtig einsetzen