OS Version Queries for WMI Filters

NOTE: Updated Feb 13, 2020 to include Windows Server 2019

More likely than not, if you’re using Group Policy to push out software installation or registry entries to client machines or servers on the domain, the particular policy settings may be different depending on the OS version or architecture.

Examples, Group Policy Objects may need to be filtered by:

  • Desktop OS / Server OS
  • Domain Controller / Non-Domain Controller
  • 32-bit / 64-bit

If you haven’t used Windows Management Instrumentation (WMI) filters before, they show up in Group Policy Management at the bottom, between Group Policy Objects and Starter GPOs.

Common OS WMI Filters

The WMI filters use a query to scope down the Group Policy Object applicability. Here’s what a typical WMI OS filter looks like:

WMI filter

select * from Win32_OperatingSystem WHERE Version like

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
  • 10.0 – Windows 10 & Windows Server 2016 & 2019

To create your own WMI filters, here is an updated list of WMI filter queries from Window XP – Windows 10 and from Server 2003 to Server 2019.

IMPORTANT DISCLAIMER:
Always test your Group Policies and WMI filters before deploying.

DESKTOP WMI QUERIES

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”

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%” AND ProductType=”1″ AND OSArchitecture = “64-bit”

SERVER WMI QUERIES

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     
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “5.2%” AND ProductType<>”1″
  • 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     
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “5.2.3%” AND ProductType<>”1″
  • 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 2008     
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.0%” AND ProductType<>”1″
  • 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     
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.1%” AND ProductType<>”1″
  • Windows Server 2008 R2 – DC
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.1%” AND ProductType=”2″
  • Windows Server 2008 R2 – non-DC
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.1%” AND ProductType=”3″

WINDOWS SERVER 2012

  • Windows Server 2012     
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.2%” AND ProductType<>”1″
  • Windows Server 2012 – DC
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.2%” AND ProductType=”2″
  • Windows Server 2012 – non-DC
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.2%” AND ProductType=”3″

WINDOWS SERVER 2012 R2

  • Windows Server 2012R2     
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.3%” AND ProductType<>”1″
  • Windows Server 2012 R2 – DC
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.3%” AND ProductType=”2″
  • Windows Server 2012 R2 – non-DC
    SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “6.3%” AND ProductType=”3″

WINDOWS SERVER 2016 *

  • Windows Server 2016     
    SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE “10.0.14393%”) OR (Version LIKE “10.0.16299%”) OR (Version LIKE “10.0.17134%”) AND ProductType<>”1″
  • Windows Server 2016 – DC
    SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE “10.0.14393%”) OR (Version LIKE “10.0.16299%”) OR (Version LIKE “10.0.17134%”) AND ProductType=”2″
  • Windows Server 2016 – non-DC
    SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE “10.0.14393%”) OR (Version LIKE “10.0.16299%”) OR (Version LIKE “10.0.17134%”) AND ProductType=”3″

WINDOWS SERVER 2019 *

  • Windows Server 2019     
    SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE “10.0.17763%”) OR (Version LIKE “10.0.18362%”) OR (Version LIKE “10.0.18363%”) AND ProductType<>”1″
  • Windows Server 2019 – DC
    SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE “10.0.17763%”) OR (Version LIKE “10.0.18362%”) OR (Version LIKE “10.0.18363%”) AND ProductType=”2″
  • Windows Server 2019 – non-DC
    SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE “10.0.17763%”) OR (Version LIKE “10.0.18362%”) OR (Version LIKE “10.0.18363%”) AND ProductType=”3″

* A few notes about the “OR” operator:

First – The reason for the “OR” statements in Server 2016 and Server 2019 WMI Query Filters is because there are multiple builds, as shown in the table below. These multiple builds are part of Microsoft’s Windows as a service (Waas) plan.

Second – “Or” combines two conditions. When more than one logical operator is used in a statement, the OR operators are evaluated after the AND operators. (Source)

Major Minor Version Build Info Released
10 0 1607 14393 2016 RTM LTSC 09/26/2016
10 0 1709 16299 2016 SAC 10/17/2017
10 0 1803 17134 2016 SAC 04/30/2018
10 0 1809 17763 2019 LTSC 11/13/2018
10 0 1903 18362 2019 SAC 5/21/2019
10 0 1909 18363 2019 SAC 11/12/2019

Helpful OS Term Abbreviations



    VN:F [1.9.20_1166]
    Rating: 9.9/10 (45 votes cast)

    Remote Desktop Connection Tips

    OK, so I’m probably the last person on the planet to learn of this feature, but on the left side of Remote Desktop Connection (MSTSC.exe) there’s a drop-down that exposes features for Windows 8, 8.1, Server 2012 and Server 2012 R2.

    Drop-down for Windows 8 in latest RDP client

    This is helpful when you’re on a Win8.x or 2012/R2 machine, RDPed into another machine and you’re not sure if (when you mouse up to the top-right or bottom-right) if you’re popping up the charms menu for your machine or the remote machine.

    Also, speaking of Remote Desktop, there are 2 pieces to the puzzle:

    • Remote Desktop Protocol (RDP) – server
    • Remote Desktop Connection (RDC) – client

    Below are the current versions and key features.

    RDP 8.0 update (10/23/2012)
    Windows 7 and Server 2008 R2
    http://support.microsoft.com/kb/2592687 

    • RemoteFX for WAN
    • RemoteFX Network Auto Detect
    • RemoteFX Adaptive Graphics
    • RemoteFX Media Streaming
    • RemoteFX USB Redirection for non-RemoteFX vGPU virtual desktops
    • Support for nested sessions
    • Performance counters for monitoring user experience

    RDC 8.1 update (2/10/2014)
    Windows 7 and Server 2008 R2
    http://support.microsoft.com/KB/2830477

    • Full support of transparent windows
    • Moves and resizes of RemoteApp windows
    • Thumbnails, aero peek, and live taskbar
    • Dynamic monitor and resolution changes
    • Support for session shadowing
    VN:F [1.9.20_1166]
    Rating: 9.5/10 (2 votes cast)

    Free eBook: Introducing Windows 8.1 for IT Professionals

    Free eBook: Introducing Windows 8.1 for IT ProfessionalsTitle: Introducing Windows 8.1 for IT Professionals
    Author: Ed Bott
    Publisher: Microsoft Press
    Published: 10/14/2013
    Pages: 136
    ISBN: 978-0-7356-8427-0
    PDF: Microsoft Press ebook Introducing Windows ITPro PDF.pdf
    Size: 9.3 MB
    Price: FREE
    Download URL: Click here for download

    OTHER FORMATS

    • ePUB – coming soon (same URL above).
    • Mobi (Kindle) – coming soon (same URL above).
    • Hard copy – available from Amazon.com on 11/04/2013 for $8.99 US.

    TABLE OF CONTENTS

    1. An overview of Windows 8.1
    2. The Windows 8.1 user experience
    3. Deploying Windows 8.1
    4. Security in Windows 8.1
    5. Internet Explorer 11
    6. Delivering Windows Store apps
    7. Recovery options in Windows 8.1
    8. Windows 8.1 and networks
    9. Virtualization in Windows 8.1
    10. Windows RT 8.1
    11. Managing mobile devices

    DESCRIPTION

    The goal in this book is to help you on the upgrade path by presenting the
    facts and features about Windows 8.1 as clearly as possible. If you’ve been living in an environment built around a previous version of Windows, you have a lot to absorb in the transition to Windows 8.1. This book tries to lay out those facts in as neutral a fashion as possible, starting with an overview of the operating system, explaining the many changes to the user experience, and diving deep into deployment and management tools where it’s necessary.

    By design, this book focuses on things that are new, with a special emphasis on
    topics of interest to IT pros. So you might find fewer tips and tricks about the new user experience than your users want but more about management, deployment, and security—which ultimately is what matters to the long-term well-being of the company you work for.

    VN:F [1.9.20_1166]
    Rating: 0.0/10 (0 votes cast)

    Windows 8.1 Pricing and Packaging Announced

    The General Availability (GA) date for the public to purchase Windows 8.1 is just around the corner: Friday October 18, 2013.

    Microsoft has released more detailed information about the pricing and packaging of Windows 8.1:

    PRICING

    • Windows 8.1 $119.99 ERP (US)
    • Windows 8.1 Pro $199.99 ERP (US)
    • Windows 8.1 Pro Pack $99.99 ERP (US)
    • Windows Media Center add-on for 8.1 Pro $9.99 (US)
    • Upgrade from 8.0 to 8.1 Free (via Windows Store download)

    PACKAGING

    Windows 8.1 box shots

    UPGRADE OPTIONS

    • Windows 8.0 to 8.1 in-place-upgrade – Yes
    • Windows 8.1 to 8.1 Pro – Yes with Windows 8.1 Pro Pack
    • Windows 7 to 8.1 upgrade – documents will be saved, applications will have to be reinstalled
    • Windows Vista to 8.1 upgrade – No, clean install required
    • Windows XP to 8.1 upgrade – No, clean install required

    WHAT’S NEW IN WINDOWS 8.1

    TechNet talks about what’s new in Windows 8.1 and the Windows blog has listed more than 20 new and improved Microsoft apps and services.

    LEARN MORE ABOUT WINDOWS 8.1

    VN:F [1.9.20_1166]
    Rating: 0.0/10 (0 votes cast)

    Updated List of OS Version Queries for WMI Filters

    Group PolicyMore likely than not, if you’re using Group Policy to push out software installation or registry entries to client machines or servers on the domain, the policy may be different depending on the OS version or architecture.

    Examples, Group Policy Objects may need to be filtered by:

    • Desktop / Server
    • Domain Controller / Non-Domain Controller
    • 32-bit / 64-bit

    If you haven’t used WMI filters before, they show up in Group Policy Management at the bottom, between Group Policy Objects and Starter GPOs.

    Common OS 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"
    VN:F [1.9.20_1166]
    Rating: 9.8/10 (81 votes cast)

    Windows Server 2012 R2 and 8.1 RTM on MSDN/TechNet

    Per this blog announcement, the final bits of the next wave of Windows products are available on MSDN & TechNet.

    Windows Server 2012 R2 - RTM

    Note: General Availability (GA) to the public for Windows 8.1 and Windows Server 2012 R2 is Friday, October 18, 2013.

    MSDN

    Windows Server 2012 R2 and 8.1 RTM on MSDN

    TechNet

    Windows Server 2012 R2 and 8.1 RTM on TechNet

    Windows 8.1

    • Windows 8.1 (multiple editions) (x86) – DVD (English)
      File size: 2,780 MB
      File name: en_windows_8_1_x86_dvd_2707392.iso
      SHA1: 802CFCD3A411D99C097EA7E747F0B6697F9BDAC4
       
    • Windows 8.1 (multiple editions) (x64) – DVD (English)
      File size: 3,719 MB
      File name: en_windows_8_1_x64_dvd_2707217.iso
      SHA1: BC2F7FF5C91C9F0F8676E39E703085C65072139B

    Windows Server 2012 R2

    • Windows Server 2012 R2 (x64) – DVD (English)
      File size: 4,071 MB
      File name: en_windows_server_2012_r2_x64_dvd_2707946.iso
      SHA1: B6F063436056510357CB19CB77DB781ED9C11DF3
       
    • Microsoft Hyper-V Server 2012 R2 (x64) – DVD (English)
      File size: 1,917 MB
      File name: en_microsoft_hyper-v_server_2012_r2
      _x64_dvd_2708236.iso
      SHA1: 1EEC2EE8DD77E8EB970B210C9B0E01986D7210DD
       
    • Windows Storage Server 2012 R2 and Windows Server 2012 R2 Foundation (x64) – DVD (English)
      File size: 3,860 MB
      File name: en_windows_storage_server_2012_r2_and_windows
      _server_2012_r2_foundation_x64_dvd_2708426.iso
      SHA1: E3F320EACACFC7F2B000D3E6B02872133BCA547C
       
    • Windows Server 2012 R2 Essentials (x64) – DVD (English)
      File size: 3,861 MB
      File name: en_windows_server_2012_r2_essentials_x64
      _dvd_2707177.iso
      SHA1: 8A4CB96563DDA4F1BF637E57A992F3255D56B6F8
    VN:F [1.9.20_1166]
    Rating: 8.0/10 (5 votes cast)

    Windows 8.1 RT Preview Available

    You can now download and install the Windows 8.1 RT Preview on your Microsoft Surface device. The download is 2.19 GB. Screenshot below:

    Windows 8.1 RT Preview

    VN:F [1.9.20_1166]
    Rating: 6.0/10 (1 vote cast)