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 (80 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)

Download – Introducing Windows Server 2012 R2 eBook

Introducing Windows Server 2012 R2 - Preview ReleaseTitle: Introducing Windows Server 2012 R2 Preview Release
Author: Mitch Tulloch with the Windows Server Team
Publisher: Microsoft Press
Published: © 2013 by Microsoft Corporation
Pages: 108
ISBN: 978-0-7356-8293-1
File size: 5.1 MB
Price: FREE preview*
Download URL: Click here for download

Table of Contents

  • Chapter 1 – Cloud OS
  • Chapter 2 – Hyper-V
  • Chapter 3 – Storage
  • Chapter 4 – Failover Clustering
  • Chapter 5 – Networking
  • Chapter 6 – Other Enhancements

Description

Introducing Windows Server 2012 R2 Preview Release (ISBN 9780735682931), by Mitch Tulloch with the Windows Server Team, introduces new features and capabilities, with scenario-based advice on how the platform can meet the needs of your business. Get the high-level overview you need to begin preparing your deployment now. This book is based on the Preview release and will be updated to cover Windows Server 2012 R2 RTM.

Download the PDF version of this title here (108 pages, 5.1 MB). UPDATE: The EPUB format is here and the MOBI format is here.

Watch for the lengthier RTM edition of this ebook later this year!

If you prefer a hard copy of the book, you can order it here from the official distributor, O’Reilly Media, for $9.99.

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

Download – Windows Server 2012 R2 Test Lab Guide

Whitepaper - Windows Server 2012 R2 Preview Test Lab GuideTitle: Windows Server 2012 R2 Preview Test Lab Guide
Publisher: Microsoft Corporation
Published: 7/17/2013
Filename: Win2012_R2_Preview_TLG.docx
File size: 199 KB
Pages: 33
Price: FREE
Download URL: Click here to download

Description:

This Microsoft Test Lab Guide (TLG) provides you with step-by-step instructions to create the Windows Base Configuration test lab, using computers running Windows 8.1 or Windows Server 2012 R2 Preview.

With the resulting test lab environment, you can build test labs based on other Windows Server 2012 R2 Preview-based TLGs from Microsoft, TLG extensions in the TechNet Wiki, or a test lab of your own design that can include Microsoft or non-Microsoft products.

  • For a test lab based on physical computers, you can image the drives for future test labs.
  • For a test lab based on virtual machines, you can create snapshots of the base configuration virtual machines.

This enables you to easily return to the base configuration test lab, where most of the routine infrastructure and networking services have already been configured, so that you can focus on building a test lab for the product, technology, or solution of interest.

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

Download – Windows Server 2012 R2 Preview

Update: 2013-06-25

Public (non-TechNet/MSDN subscribers) links for the preview versions are now live for everyone. Here are the public download links:

This just in; the following betas are available for download for subscribers of TechNet and MSDN: http://www.ittsystems.com/best-free-tftp-servers-windows/

  • Windows Server 2012 R2 Datacenter Beta (3938 MB)
  • Windows Server 2012 R2 Essentials Beta (3736 MB)
  • Windows Hyper-V Server 2012 R2 Beta (1769 MB)

Here are the file sizes and SHA1 values.

Windows Server 2012 R2 Datacenter Preview:

TechNet download of Windows Server 2012 R2 Datacenter Beta

Windows Server 2012 R2 Essentials Preview:

MSDN download of Windows Server 2012 R2 Essentials Beta

Windows Hyper-V Server 2012 R2 Preview:

MSDN download of Windows Hyper-V Server 2012 R2 Beta

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