GPO WMI Filter for only Windows Server 2008 R2 or Server 2008 x86

Posted on 2012-08-14
Last Modified: 2012-08-14
Hi, I want to have a WMI filter running on a GPO so that the GPO only runs when the logged on machine is either of these three OSes:

Windows Server 2008 R2 SP1  (Running 'ver' says [Version 6.1.7601])
Windows Server 2008 Standard without Hyper-V SP2 32-bit  (Running 'ver' says [Version 6.0.6002])

I don't want Server 2003 involved.

I also want it to only run on a server, not a domain controller, or a workstation.

Initially, I had an WMI filter only for the R2 server, i.e.

SELECT Version, ProductType FROM Win32_OperatingSystem WHERE Version = '6.1.7601' AND ProductType = '3'

This has been working well for me, but I want to incorporate the 2008 32-bit server into it and I'm not quite sure how to sort out the boolean AND/OR business.

Question by:meirionwyllt
    LVL 39

    Accepted Solution

    Have you tried a little bit different way ? :)

    SELECT Version, ProductType FROM Win32_OperatingSystem WHERE Caption LIKE '%2008%' AND ProductType = '3'

    Open in new window


    Author Comment

    Perfect - that works fine!

    LVL 39

    Expert Comment

    by:Krzysztof Pytko
    You're welcome :)


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
    This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
    This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now