+ Post New Thread
Results 1 to 12 of 12
Windows 7 Thread, Win7 & Win8 32bit and 64bit WMI Filter in Technical; Hi Guys/Gals i need to make a WMI filter so only windows 7 and windows 8 32bit and 64bit are ...
  1. #1

    Join Date
    Jun 2011
    Location
    Atherton
    Posts
    112
    Thank Post
    13
    Thanked 6 Times in 1 Post
    Rep Power
    8

    Win7 & Win8 32bit and 64bit WMI Filter

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

  2. #2


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,818
    Thank Post
    231
    Thanked 890 Times in 765 Posts
    Rep Power
    302
    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" )

  3. Thanks to sted from:

    jahilton2002 (9th November 2012)

  4. #3

    Join Date
    Jun 2011
    Location
    Atherton
    Posts
    112
    Thank Post
    13
    Thanked 6 Times in 1 Post
    Rep Power
    8
    select * from Win32_OperatingSystem WHERE (Version => "6.1%" AND ProductType="1" ) this works does it? i like your logic

  5. #4

    Join Date
    Mar 2011
    Location
    Bournemouth
    Posts
    280
    Thank Post
    16
    Thanked 74 Times in 64 Posts
    Rep Power
    22
    SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE '6.1.%') AND (ProductType = 1)

  6. #5

    Join Date
    Jun 2011
    Location
    Atherton
    Posts
    112
    Thank Post
    13
    Thanked 6 Times in 1 Post
    Rep Power
    8
    Quote Originally Posted by ChrisMiles View Post
    SELECT * FROM Win32_OperatingSystem WHERE (Version LIKE '6.1.%') AND (ProductType = 1)
    thats just windows 7 tho?

  7. #6

    Join Date
    Jun 2011
    Location
    Atherton
    Posts
    112
    Thank Post
    13
    Thanked 6 Times in 1 Post
    Rep Power
    8
    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')
    Last edited by jahilton2002; 27th November 2012 at 12:08 PM.

  8. #7
    VeryPC_Tom_M's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    388
    Thank Post
    14
    Thanked 82 Times in 79 Posts
    Rep Power
    45
    Quote Originally Posted by jahilton2002 View Post
    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

  9. #8

    Join Date
    Jun 2011
    Location
    Atherton
    Posts
    112
    Thank Post
    13
    Thanked 6 Times in 1 Post
    Rep Power
    8
    thx for the speedy reply i get the same error below;

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

  10. #9
    VeryPC_Tom_M's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    388
    Thank Post
    14
    Thanked 82 Times in 79 Posts
    Rep Power
    45
    I think I've spotted it..

    Replace the first OSAechitecture with "*"

  11. #10

    Join Date
    Jun 2011
    Location
    Atherton
    Posts
    112
    Thank Post
    13
    Thanked 6 Times in 1 Post
    Rep Power
    8
    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

  12. #11
    VeryPC_Tom_M's Avatar
    Join Date
    Aug 2012
    Location
    Sheffield
    Posts
    388
    Thank Post
    14
    Thanked 82 Times in 79 Posts
    Rep Power
    45
    select * from Win32_OperatingSystem Where (Version>='6.%' AND Producttype="1" AND OSArchitecture='32-bit')

  13. 2 Thanks to VeryPC_Tom_M:

    jahilton2002 (27th November 2012)

  14. #12

    Join Date
    Jun 2011
    Location
    Atherton
    Posts
    112
    Thank Post
    13
    Thanked 6 Times in 1 Post
    Rep Power
    8
    YAY Thx buddy works a treat



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 2nd November 2012, 01:38 PM
  2. [SIMS] SIMS, 32bit windows and 64bit windows
    By mrbios in forum MIS Systems
    Replies: 15
    Last Post: 26th March 2012, 02:54 PM
  3. 32bit and 64bit Printer Drivers
    By fil_b in forum Hardware
    Replies: 6
    Last Post: 22nd June 2010, 05:18 PM
  4. WMI filter to target SMARTboard software install
    By ajbritton in forum Windows
    Replies: 8
    Last Post: 15th August 2006, 09:30 PM
  5. GPO WMI Filters
    By Norphy in forum Windows
    Replies: 2
    Last Post: 9th March 2006, 10:28 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •