WMI Filters for OS version

DESKTOPS

ANY WINDOWS DESKTOP OS

• 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

• 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.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”

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”

WINDOWS 10

• Windows 10
  select * from Win32_OperatingSystem WHERE ‘Version like ‘10.0.%’ AND ProductType=”1″
• Windows 10 – 32-bit
  select * from Win32_OperatingSystem WHERE Version like “10.0.% AND ProductType=”1” AND NOT OSArchitecture = “64-bit”
• Windows 10 – 64-bit
  select * from Win32_OperatingSystem WHERE Version like “10.0.%””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 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 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″

WINDOWS SERVER 2016

• Windows Server 2016 – 64-bit – DC
  select * from Win32_OperatingSystem WHERE Version like “10.0%” AND ProductType=”2″
• Windows Server 2016 – 64-bit – non-DC
  select * from Win32_OperatingSystem WHERE Version like “10.0%” AND ProductType=”3″
• Source: http://www.nogeekleftbehind.com/2016/01/19/os-version-queries-for-wmi-filters/