WMI CIM Like statement will not work on Server 2000

I have built a small VBScript to move a few files around our network as they come in via FTP. On my workstation (XP SP2) I can run and return results back for the following WMI CMI query to collect all files that have FILE in the name (the files all have this trait)::

Set objFileList = objWMIService.ExecQuery _
         ("Select * from CIM_Datafile Where Path = '\\ftpinbound\\' And FileName Like '%FILE%'")

When I moved this script to my file server for production I get no results for this query. However, if I change the script to:

Set objFileList = objWMIService.ExecQuery _
         ("Select * from CIM_Datafile Where Path = '\\ftpinbound\\' And FileName = 'FILE'")

I get results for the files named (for example file.001) and not the ones named (for example file1022.001).

Any ideas? All the stuff I have read says that this query will work on Server 2000 but I cant seem to figure out what the deal is with the Like statement.
dna404Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

grayeCommented:
Yep, that's correct... the LIKE operator was added with WinXP
0
dna404Author Commented:
Will it work on 2003 Server?
0
grayeCommented:
Yep, XP and beyond
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dna404Author Commented:
Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.