Win7 & Win8 32bit and 64bit WMI Filter

[Jaan]

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" )

[Jaan]

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)

[Jaan]

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

 

thats just windows 7 tho?

[Jaan]

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')

Edited November 27, 2012 by Jaan

[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

[Jaan]

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 "*"

[Jaan]

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

 

[VeryPC_Tom_M]

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

[Jaan]

YAY Thx buddy works a treat