Monday, May 18, 2015

Updated List of OS Version Queries for WMI Filters

The WMI filters use a query to scope down the application of the Group Policy Object applicability. Here’s what a typical WMI OS filter looks like:
WMI filter
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" AND OSArchitecture = "64-bit"
WMI Win32_OperatingSystem ProductType Tips:
ProductType 1 = Desktop OS
ProductType 2 = Server OS – Domain Controller
ProductType 3 = Server OS – Not a Domain Controller
WMI Win32_OperatingSystem Version Number Tips:
5.1 – Windows XP
5.2 – Windows Server 2003
5.2.3 – Windows Server 2003 R2
6.0 – Windows Vista & Windows Server 2008
6.1 – Windows 7 & Windows Server 2008 R2
6.2 – Windows 8 & Windows Server 2012
6.3 – Windows 8.1 & Windows Server 2012 R2
To create your own WMI filters, here is an updated list of WMI filter queries from Window XP – Windows 8.1 and from Server 2003 to Server 2012 R2.
IMPORTANT DISCLAIMER:
Always test your Group Policies and WMI filters before deploying.

DESKTOPS

ANY WINDOWS DESKTOP OS

  • Any Windows Desktop OS – Version 1
    select * from Win32_OperatingSystem WHERE ProductType = "1"
  • Any Windows Desktop OS – Version 2 (better for Win7 sometimes)
    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 XP

  • Windows XP
    select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1"
  • Windows XP – 32-bit
    select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1" AND NOT OSArchitecture = "64-bit"
  • Windows XP – 64-bit
    select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1" AND OSArchitecture = "64-bit"

WINDOWS VISTA

  • Windows Vista
    select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="1"
  • Windows Vista – 32-bit
    select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="1" AND NOT OSArchitecture = "64-bit"
  • Windows Vista – 64-bit
    select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="1" AND OSArchitecture = "64-bit"

WINDOWS 7

  • 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 8

  • Windows 8 select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1"
  • 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 8.1

  • Windows 8.1
    select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1"
  • Windows 8.1 – 32-bit select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1" AND NOT OSArchitecture = "64-bit"
  • Windows 8.1 – 64-bit
    select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1" AND OSArchitecture = "64-bit"

SERVERS

ANY WINDOWS SERVER OS

  • 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 2003

  • Windows Server 2003 – DC
    select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2"
  • Windows Server 2003 – non-DC
    select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3"
  • Windows Server 2003 – 32-bit – DC
    select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2" AND NOT OSArchitecture = "64-bit"
  • Windows Server 2003 – 32-bit – non-DC
    select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3" AND NOT OSArchitecture = "64-bit"
  • Windows Server 2003 – 64-bit – DC
    select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2" AND OSArchitecture = "64-bit"
  • Windows Server 2003 – 64-bit – non-DC
    select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3" AND OSArchitecture = "64-bit"

WINDOWS SERVER 2003 R2

  • Windows Server 2003 R2 – DC
    select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2"
  • Windows Server 2003 R2 – non-DC
    select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3"
  • Windows Server 2003 R2 – 32-bit – DC
    select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2" AND NOT OSArchitecture = "64-bit"
  • Windows Server 2003 R2 – 32-bit – non-DC
    select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3" AND NOT OSArchitecture = "64-bit"
  • Windows Server 2003 R2 – 64-bit – DC
    select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2" AND OSArchitecture = "64-bit"
  • Windows Server 2003 R2 – 64-bit – non-DC
    select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3" AND OSArchitecture = "64-bit"

WINDOWS SERVER 2008

  • Windows Server 2008DC
    select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2"
  • Windows Server 2008 – non-DC
    select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3"
  • Windows Server 2008 – 32-bit – DC
    select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" AND NOT OSArchitecture = "64-bit"
  • Windows Server 2008 – 32-bit – non-DC
    select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" AND NOT OSArchitecture = "64-bit"
  • Windows Server 2008 – 64-bit – DC
    select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" AND OSArchitecture = "64-bit"
  • Windows Server 2008 – 64-bit – non-DC
    select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" AND OSArchitecture = "64-bit"

WINDOWS SERVER 2008 R2

  • 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

  • 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


  • 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" 

No comments:

Post a Comment