Win7 & Win8 32bit and 64bit WMI Filter

[jahilton2002]

Hi Guys/Gals

i need to make a WMI filter so only windows 7 and windows 8 32bit and 64bit are effected Not any windows xp or server based OSs. also i need to make sure the 64bit Architecture relates to the OS not the CPU.

here is the filter i've made..... can anybody shine any light on this please?

select * from Win32_OperatingSystem WHERE (Version like "6.1%" or Version like "6.2%") AND ProductType="1" AND (OSArchitecture = "64-bit" or OSArchitecture = "32-bit")

[sted]

wouldnt

select * from Win32_OperatingSystem WHERE (Version like "6.1%" AND ProductType="1" ) or (Version like "6.2%" AND ProductType="1" ) work if u=you dont care if x64/x86 why even ask?

not saying this will work but looks simpler logic if nothing else or even come to think of it

select * from Win32_OperatingSystem WHERE (Version => "6.1%" AND ProductType="1" )

[jahilton2002]

select * from Win32_OperatingSystem WHERE (Version => "6.1%" AND ProductType="1" ) this works does it? i like your logic

[ChrisMiles]

SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE '6.1.%') AND (ProductType = 1)

[jahilton2002]

SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE '6.1.%') AND (ProductType = 1)

thats just windows 7 tho?

[jahilton2002]

Hi guys whats the best way for me to include all 32bits OSs including and above vista (i need to exclude XP)

i get an error when i use the following;

SELECT OSArchitecture FROM Win32_OperatingSystem WHERE (version =>"6.0%" AND ProductType="1") AND (OSArchitecture='32-bit')

[VeryPC_Tom_M]

SELECT OSArchitecture FROM Win32_OperatingSystem WHERE (version =>"6.0%" AND ProductType="1") AND (OSArchitecture='32-bit')

Try:

SELECT OSArchitecture FROM Win32_OperatingSystem WHERE (version =>"6.%" AND ProductType="1") AND (OSArchitecture='32-bit')

This should work for Vista and 7 (and possibly 8): Step 7: Creating WMI and Group Filters

[jahilton2002]

thx for the speedy reply i get the same error below;

"A Syntax error occurred trying to evaluate a query string"

[VeryPC_Tom_M]

I think I've spotted it..

Replace the first OSAechitecture with "*"

[jahilton2002]

I get the same error im afraid.... after i get this wmi filter sorted im having a break... i feel like i making silly mistakes now!

here's screenie

Capture.PNG

[VeryPC_Tom_M]

select * from Win32_OperatingSystem Where (Version>='6.%' AND Producttype="1" AND OSArchitecture='32-bit')

[jahilton2002]

YAY Thx buddy works a treat