Active Directory - Bsp WMI Abfragen für GPO Richtlinien - DRAFT
Beschreibung
Liste:
Desktops
Any Windows Desktop OS select * from Win32_OperatingSystem WHERE (ProductType <> "2") AND (ProductType <> "3")
Any Windows Desktop OS - 32-bit select * from Win32_OperatingSystem WHERE ProductType = "1" AND NOT OSArchitecture = "64-bit"
Any Windows Desktop OS - 64-bit select * from Win32_OperatingSystem WHERE ProductType = "1" AND OSArchitecture = "64-bit"
Windows 7 select * from Win32_OperatingSystem WHERE Version like "6.1%" 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 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 NOT OSArchitecture = "64-bit"
Windows 10 - 64-bit select * from Win32_OperatingSystem WHERE Version like "10.%" AND ProductType="1" AND OSArchitecture = "64-Bit"
Servers
Any Windows Server OS select * from Win32_OperatingSystem where (ProductType = "2") OR (ProductType = "3")
Any Windows Server OS - 32-bit select * from Win32_OperatingSystem where (ProductType = "2") OR (ProductType = "3") AND NOT OSArchitecture = "64-bit"
Any Windows Server OS - 64-bit select * from Win32_OperatingSystem where (ProductType = "2") OR (ProductType = "3") AND OSArchitecture = "64-bit"
Any Windows Server - Domain Controller select * from Win32_OperatingSystem where (ProductType = "2")
Any Windows Server - Domain Controller - 32-bit select * from Win32_OperatingSystem where (ProductType = "2") AND NOT OSArchitecture = "64-bit"
Any Windows Server - Domain Controller - 64-bit select * from Win32_OperatingSystem where (ProductType = "2") AND OSArchitecture = "64-bit"
Any Windows Server - Non-Domain Controller select * from Win32_OperatingSystem where (ProductType = "3")
Any Windows Server - Non- Domain Controller - 32-bit select * from Win32_OperatingSystem where (ProductType = "3") AND NOT OSArchitecture = "64-bit"
Any Windows Server - Non-Domain Controller - 64-bit select * from Win32_OperatingSystem where (ProductType = "3") AND OSArchitecture = "64-bit"
Windows Server 2008 R2 - 64-bit - DC select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="2"
Windows Server 2008 R2 - 64-bit - non-DC select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="3"
Windows Server 2012 - 64-bit - DC select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="2"
Windows Server 2012 - 64-bit - non-DC select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="3"
Windows Server 2012 R2 - 64-bit - DC select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="2"
Windows Server 2012 R2 - 64-bit - non-DC select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="3"
Windows Server 2016 - 64-bit - DC select * from Win32_OperatingSystem WHERE Version like "10.%" AND ProductType="2"
Windows Server 2016 - 64-bit - non-DC select * from Win32_OperatingSystem WHERE Version like "10.%" AND ProductType="3"
Product Type Eingränzungen
Client ProductType=“1″
Server ProductType=“3″
Domain Controller ProductType=“2″
Filter auf Zeiträume eingrenzen
Montag Select DayOfWeek from Win32_LocalTime where DayOfWeek = 1
Dienstag Select DayOfWeek from Win32_LocalTime where DayOfWeek = 2
Mittwoch Select DayOfWeek from Win32_LocalTime where DayOfWeek = 3
| 
