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