WMI Filters for Windows 7, XP & Server 2008 R2 Terminal Server

[FN-GM]

Hi,

I am after some WMI Filters. for the following

Windows XP Machines (32 Bit)
Windows 7 Machines (32 Bit maybe 64)
Windows Server 2008 R2 Terminal Server Session

I have found the following for Windows XP Machines

Root\CimV2; Select * from Win32_OperatingSystem where Caption = "Microsoft Windows XP Professional"

I have found this for Windows 7 Machines

select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1"

For Server 2008 R2 i have come up with nothing. As Server 2008 is windows 6.1 will it apply the above WMI? Maybe we could have something like this for Server 2008 R2 and 7? Will the below ones work?

Root\CimV2; Select * from Win32_OperatingSystem where Caption = "Microsoft Windows 7"

Root\CimV2; Select * from Win32_OperatingSystem where Caption = "Microsoft Windows Server 2008 R2"

Thanks

[mounters]

Does this help at all Step 7: Creating WMI and Group Filters

[FN-GM]

Ok so for windows XP i will have:

select * from Win32_OperatingSystem where Version like "5.1%" and ProductType = "1"

For Windows 7 I will have

select * from Win32_OperatingSystem where Version like "6.1%" and ProductType = "1"

For Server 2008 R2 i will have

select * from Win32_OperatingSystem where Version like "6.1%" and ProductType = "3"

Thanks allot

[mounters]

Are you sure? Do you not just need to use the ProductType and then 1 = clients, 2 = servers that are DCs, 3 = member servers.

[mounters]

Beat me to it!

[FN-GM]

Beat me to it!

I deleted the last post as i cant read!

So do those filters sound ok to you?

I shall be doing some testing this weekend!

Thanks

[mounters]

Yep they look good to me.

[FN-GM]

I also assume you can apply these to user & computer policies?

Also i assume that the namespace is set to root\CIMv2

Thanks

[mounters]

Yes, they apply to both.

[Arthur]

Re: post #3, there are lots of different ways of doing the same thing...

Windows XP
SELECT Version, ProductType FROM Win32_OperatingSystem WHERE Version = '5.1%' AND ProductType = '1'
SELECT Version, ProductType from Win32_OperatingSystem WHERE Version = '5.1.2600' AND ProductType = '1'
SELECT Version, ProductType from Win32_OperatingSystem WHERE Version LIKE '5.1.%' AND ProductType = '1'

Windows 7
SELECT Version, ProductType FROM Win32_OperatingSystem WHERE Version = '6.1%' AND ProductType = '1'
SELECT Version, ProductType FROM Win32_OperatingSystem WHERE Version = '6.1.7600' AND ProductType = '1'
SELECT Version, ProductType FROM Win32_OperatingSystem WHERE Version LIKE '6.1.%' AND ProductType = '1'

Windows Server 2008 R2
SELECT Version, ProductType FROM Win32_OperatingSystem WHERE Version = '6.1%' AND ProductType <> '1'
SELECT Version, ProductType FROM Win32_OperatingSystem WHERE Version = '6.1.7600' AND ( ProductType = '2' OR ProductType = '3' )
SELECT Version, ProductType FROM Win32_OperatingSystem WHERE Version LIKE '6.1.%' AND ProductType <> '1'

Some other filters you may find useful...

32-bit OS
SELECT OSArchitecture FROM Win32_OperatingSystem WHERE OSArchitecture='32-bit'

64-bit OS
SELECT OSArchitecture FROM Win32_OperatingSystem WHERE OSArchitecture='64-bit'

NOT A Server OS
SELECT ProductType FROM Win32_OperatingSystem WHERE ProductType = '1'

NOT a laptop (assumes every laptop uses SO-DIMM RAM)
SELECT FormFactor FROM Win32_PhysicalMemory WHERE FormFactor != 12

[FN-GM]

Does anyone have a WMI that will only apply a computer that begins with ZY4 please?

We have some computers called ZY4-01, ZY4-02 etc..

Thanks

[Arthur]

SELECT * FROM Win32_ComputerSystem WHERE Name LIKE 'ZY4%'

or

SELECT Name FROM Win32_ComputerSystem WHERE Name LIKE 'ZY4%'

In fact, you can query the computer name from literally any WMI class. e.g.

SELECT SystemName FROM Win32_ParallelPort WHERE SystemName LIKE 'ZY4%'

If you should ever need to query more than one group of computers, you can do it like this...

SELECT * FROM Win32_ComputerSystem WHERE (Name LIKE 'ZY4%' OR Name LIKE 'ZY5%')

[FN-GM]

Thanks will give them a try.

[FN-GM]

Me again

I was wondering if you know of a WMI that will apply a user policy based on Client Name? I would like to apply a policy for users that use a thin client based on the thin client name. When you make a script in VBS instead of using computer name you use client name.

Do you have any ideas please?

Thanks

[Arthur]

Terminal Session Targeting (in 2008/2008 R2)?