Well, Select * from Win32_OperatingSystem WHERE CSName LIKE 'WXP[0123456789]%' matches a group I need the policy applied to, where as there is a series of computers called WXPi... that shouldnt get this policy.
The validator holds it true for the first and false for the last, yet GPO Modeling shows it True and Applied? Thanks! jlc From: Michael B. Smith [mailto:[email protected]] Sent: Friday, December 19, 2008 2:39 PM To: NT System Admin Issues Subject: RE: WMI Filter Syntax Please give me a specific example, so I can test it... Regards, Michael B. Smith, MCITP:SA,EMA/MCSE/Exchange MVP My blog: http://TheEssentialExchange.com/blogs/michael I'll be at TEC'2009! http://www.tec2009.com/vegas/index.php From: Joseph L. Casale [mailto:[email protected]] Sent: Friday, December 19, 2008 4:17 PM To: NT System Admin Issues Subject: RE: WMI Filter Syntax Michael, I came up with a string that works, I used WMIFTest.exe to validate it against machines it should and should not include and it works. Even though the GPO has this filter set, when I model any user on the computer which Validates to a Fail, the results show a True and the GPO is applied? Seen this before? Thanks! jlc From: Michael B. Smith [mailto:[email protected]] Sent: Friday, December 19, 2008 1:59 PM To: NT System Admin Issues Subject: RE: WMI Filter Syntax Where name like "Wkst%" Regards, Michael B. Smith, MCITP:SA,EMA/MCSE/Exchange MVP My blog: http://TheEssentialExchange.com/blogs/michael I'll be at TEC'2009! http://www.tec2009.com/vegas/index.php From: Joseph L. Casale [mailto:[email protected]] Sent: Friday, December 19, 2008 2:06 PM To: NT System Admin Issues Subject: WMI Filter Syntax I was hoping for a simple one liner that expands to however many new machines get created: Select * from Win32_OperatingSystem where Name <> "Wkst000" but have a wildcard in the name, so how how do you <> a LIKE statement of "Wkst"? Thanks! jlc ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
