Posted on

Download – Group Policy Settings for Win 10 Server 2016

Title: Group Policy Settings Reference for Windows and Windows Server
Published: 04/17/2017
Publisher: Microsoft Corporation 
Version: October 2016
File size: 698 KB
File name: Windows10andWindowsServer2016PolicySettings.xlsx
Download URL: Click here to download

DESCRIPTION

This spreadsheet lists the policy settings for computer and user configurations that are included in the Administrative template files (.admx and .adml) delivered with Windows 10, version 1703.

These files are used to expose policy settings when you use the Group Policy Management Console (GPMC) to edit Group Policy Objects (GPOs).

The policy settings included in this spreadsheet also cover:

  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows Server 2012
  • Windows Server 2008 R2
  • Windows Server 2008
  • Windows Server 2003 with SP2
  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • Windows Vista with SP1
  • Windows XP Professional with SP2 or earlier service packs
  • Microsoft Windows 2000 with SP5 or earlier service packs
VN:F [1.9.20_1166]
Rating: 7.0/10 (3 votes cast)
Posted on

Download – ADMX Templates for Win 10 and Server 2016

Title: Administrative Templates (.admx) for Windows 10 and Windows Server 2016
Published: 01/08/2017
Publisher: Microsoft Corporation 
Version: 2.0
File name: Windows 10 and Windows Server 2016 ADMX.msi
File size: 8.1 MB
Download URL: Click here for download

DESCRIPTION

Group Policy tools use Administrative template files to populate policy settings in the user interface. This allows administrators to manage registry-based policy settings. This download includes the Administrative templates released for Windows 10 and Windows Server 2016, in the following languages:

  • cs-CZ – Czech
  • da-DK – Danish
  • de-DE – German
  • el-GR – Greek
  • en-US- English
  • es-ES – Spanish
  • fi-FI – Finnish
  • fr-FR – French
  • hu-HU – Hungarian
  • it-IT – Italian
  • ja-JP – Japanese
  • ko-KR – Korean
  • nb-NO – Norwegian
VN:F [1.9.20_1166]
Rating: 8.3/10 (3 votes cast)
Posted on

Download – Group Policy Settings Reference

gpo1Title: Group Policy Settings Reference for Windows and Windows Server
Published: 01/03/2017
Publisher: Microsoft Corporation 
Version: October 2016
File name: Windows10andWindowsServer2016PolicySettings.xlsx
File size: 0.7 MB
Download URL: Click here for download

DESCRIPTION

These spreadsheets list the policy settings for computer and user configurations that are included in the Administrative template files delivered with the Windows operating systems specified. You can configure these policy settings when you edit Group Policy Objects.

VN:F [1.9.20_1166]
Rating: 10.0/10 (1 vote cast)
Posted on

Download – Advanced Group Policy Management 4.0

Title: Advanced Group Policy Management 4.0 Documents
Published: 04/22/2016
Publisher: Microsoft Corporation 
Version: 1.0
Files: 6
Download URL: Click here for download

DESCRIPTION

These guides provide an overview of Advanced Group Policy Management (AGPM) 4.0 and step-by-step guidance for installing AGPM 4.0, managing Group Policy objects (GPOs) by using AGPM 4.0, and planning and deploying AGPM 4.0.

FILES

  • Overview of Microsoft Advanced Group Policy Management: Overview of AGPM and describes its benefits, how it works, and the next steps for evaluating it. This document is designed for people evaluating AGPM.
    AGPM40_Overview.docx (1.2 MB)
  • Step-by-Step Guide for Microsoft Advanced Group Policy Management 4.0: This guide describes a sample scenario for installing AGPM and performing Group Policy management by using the Group Policy Management Console and AGPM. Designed for people are evaluating AGPM 4.0 and for Group Policy administrators who are installing AGPM 4.0 or are using AGPM 4.0 for the first time.
    AGPM40_Step-by-Step_Guide.docx (115 KB)
    AGPM40_Step-by-Step_Guide.pdf (3007 KB)
  • Operations Guide for Advanced Group Policy Management 4.0: This guide provides step-by-step instructions for performing tasks by using AGPM 4.0. It includes all of the information in the Help for AGPM. This guide is designed for Group Policy administrators of all levels who are using AGPM 4.0.
    AGPM40_OperationsGuide.docx (177 KB)
    AGPM40_OperationsGuide.pdf (999 KB)
  • Planning Guide for Advanced Group Policy Management 4.0: This guide provides an in-depth description of the processes, procedures, and decisions for planning the deployment of AGPM in a production environment.
    AGPM40_PlanningGuide.docx (173 KB)
VN:F [1.9.20_1166]
Rating: 2.4/10 (9 votes cast)
Posted on

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 2008 – DC
    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)
    Posted on

    Download – Group Policy Settings for Server 2016 TP4

    Title: Group Policy Settings Reference for Windows and Windows Server
    Version: July 2015 (Updated for Server 2016 TP4)
    Published: 11/23/2015
    Download: http://www.microsoft.com/en-us/download/details.aspx?id=25250
    File names:

    • TP4 Policy Settings Spreadsheet.xlsx (654 KB)
    • Windows 10 ADMX spreadsheet.xlsx (654 KB)
    • Windows 8.1 Update and Windows Server 2012 R2 Update 1.xlsx (788 KB)
    • WindowsServer2003SP2GroupPolicySettings.xls (3.9 MB)
    • WindowsServer2008andWindowsVistaSP1GroupPolicySettings.xlsx (512 KB)
    • WindowsServer2008R2andWindows7GroupPolicySettings.xlsx (612 KB)
    • WindowsServer2012andWindows8GroupPolicySettings.xlsx (690 KB)
    • WindowsServer2012R2andWindows8.1GroupPolicySettings.xlsx (628 KB)
    • WindowsServer2012R2UpdateGroupPolicySettings.xlsx (634 KB)
    • WindowsVistaGroupPolicySettings.xls (1.9 MB)

    Description

    These spreadsheets list the policy settings for computer and user configurations that are included in the Administrative template files delivered with the Windows operating systems specified. You can configure these policy settings when you edit Group Policy Objects.

     

    VN:F [1.9.20_1166]
    Rating: 10.0/10 (1 vote cast)
    Posted on

    Download – ADMX Templates for 8.1 and 2012 R2

    Yesterday Microsoft published the Administrative Templates (.ADMX) for Windows 8.1 and Windows Server 2012 R2. Now is a good time to download them and place them in your administrative templates central store.

    Speaking of central store, here’s a good Ask Premier Field Engineering (PFE) article called “How to Implement the Central Store for Group Policy Admin Templates, Completely”

    Also, see the Resources link below.

    Title: Administrative Templates (.admx) for Windows 8.1 and Windows Server 2012 R2
    Publisher: Microsoft Corporation
    Published: 12/4/2013
    Version: 1.0
    File Name: Windows8.1-Server2012R2ADMX-RTM.msi
    Size: 17.4 MB
    Price: FREE
    Download URL: Click here for download

    DESCRIPTION

    Group Policy tools use Administrative template files to populate policy settings in the user interface. This allows administrators to manage registry-based policy settings. This download includes the Administrative templates released for Windows Server 2012 R2, in the multiple languages.

    RESOURCES

    VN:F [1.9.20_1166]
    Rating: 7.0/10 (1 vote cast)
    Posted on

    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 2008 – DC
      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)