WMI Filtering

[Jason]

I'm trying to apply a group policy to computers that aren't named like using a wmi filter. However it tells me the syntax isn't correct. This guy even used the same one so has it changed or something? http://www.waynezim.com/2009/07/how-to-use-wmi-filtering-to-improve-group-policy-administration/

[Jason]

found this: https://social.technet.microsoft.com/Forums/systemcenter/en-US/5d549159-554b-4e64-bba6-aefebe475494/osd-skip-a-task-sequence-step-by-query?forum=configmgrgeneral

Yeah, the NOT is wrong, WQL doesn't contain a "not like" operator but you can move the not to the beginning of the condition to negate its       value. Thus, this will work
select * from Win32_computersystem where not (Name like "%W" or Name like "%W0[1-8]")

[Dashrender]

can you post your setting?

[Jason]

@Jason said in WMI Filtering:

found this: https://social.technet.microsoft.com/Forums/systemcenter/en-US/5d549159-554b-4e64-bba6-aefebe475494/osd-skip-a-task-sequence-step-by-query?forum=configmgrgeneral

Yeah, the NOT is wrong, WQL doesn't contain a "not like" operator but you can move the not to the beginning of the condition to negate its       value. Thus, this will work
select * from Win32_computersystem where not (Name like "%W" or Name like "%W0[1-8]")

Worked like a charm