WMI filter for Windows 7 and Windows XP only all flavors

I wants to apply GPO only to all flavors of Windows 7 and Windows XP only (32 and 64 bit). Can some help me with the WMI filter query?
sirineniAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RaqueroCommented:
Check out this post:

http://www.computerperformance.co.uk/w2k3/gp/group_WMI_filters.htm

Windows 7 example:

select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1"
2CsCommented:
I believe you would have to do this by creating a security group and add the Windows XP and Windows 7 machine accounts. You can only apply WMI filters to one O/s at a time but this solution should work around that.
RaqueroCommented:
...should have mentioned it is simpler (and better...WMI on GPO slows processing down) to organize desktops/laptops into different OUs than servers. Then link the desired GPO to the OU where the workstations are and it will not affect servers and other systems you do not want it to apply to.

You can do this with OS specifc OUs if you desire, or by category such as Desktop, Laptop, etc. Don't get too granular with OUs, just use what you need to get to the desired configuration.
RaqueroCommented:
I agree with 2Cs's comment that using a security group is a good idea for restricting what machines a GPO applies to, but that can become an admistrative headache over time if folks forget to add new member computers to the group.

These should work if you really must use WMI:

This one will apply to W7 & XP only:

select * from Win32_OperatingSystem where (Version like "6.1%" or Version like "5%") and ProductType="1"

This one should apply to all client OS's from XP to Vista, to W7:

select * from Win32_OperatingSystem where ProductType="1"

See http://technet.microsoft.com/en-us/library/cc754488(v=WS.10).aspx for more information on versions and product types.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.