Vista - Win32_Directory.Name - Problem with Spaces / Blanks!

Hi,


I used the following lines to detect changes within a folder. - I get an
email if a file is placed or deleted in a specific folder.

It works pretty fine if the path contains no spaces / blanks. - But it
doesn't work if there is a space in the path.

Here is the code:


Set colEvents = objWMIService.ExecNotificationQuery _
("SELECT * FROM __InstanceOperationEvent WITHIN 10 WHERE " _
& "Targetinstance ISA 'CIM_DirectoryContainsFile' and " _
& "TargetInstance.GroupComponent= " _
&
"'Win32_Directory.Name=""c:\\\\Myfolder\\\\ImportantContent""'")

Do While True
strEmailBody = Now & VbCrLf
Set objEvent = colEvents.NextEvent()
Select Case objEvent.Path_.Class
Case "__InstanceCreationEvent"
strEmailBody = strEmailBody & "A new file was just created: " & _
objEvent.TargetInstance.PartComponent & VbCrLf
Case "__InstanceDeletionEvent"
strEmailBody = strEmailBody & "A file was just deleted: " & _
objEvent.TargetInstance.PartComponent
End Select
SbSendMailWithBlat()
Loop


I have to check a folder in the Program Files directory. I tried %20, double
and single quotes, Chr(32) but no success ...


Many thanks in advance



Juan

"Juan" <Juan@xxxxxx> wrote in message
news:49F846A6-0E92-4127-86BA-C6DE3A50C2E3@xxxxxxYour single quotes are in the wrong place. No need for double quotes. The
single quotes should surround the name of the folder. I believe it should
be:

& "Win32_Directory.Name='c:\\Myfolder\\Program Files'")

And the backslashes only need to be doubled, unless I'm mistaken.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

Dear Richard,

I still get "unparsable query", I changed the \\ to \\\\ - also "unparsable
query"

Do you have another idea?


thanks


Juan

"Richard Mueller [MVP]" wrote:

I'm not familiar with WMI monitoring scripts but I found this link using the
identical query:

http://www.microsoft.com/technet/scr...5/hey0404.mspx

This shows your syntax is essentially correct, but does not explain why a
space in the path would cause a problem. In fact, since that path is already
in quotes, I would not expect an error. Instead, I wonder if this a
permission issue. See if the scripts works with another folder created by
you with spaces in the name. On newer OS's like Vista, users lack
permissions in special folders like "C:\Program Files".

Note the query is the concatenation of several strings. Within any string a
quote character is represented by two quote characters. For example the
string:

strValue = "This is an ""Example""."

Resolves into:

This is an "Example".

You can check this by echoing the string to the command prompt with
Wscript.Echo. In your case the last string in the query is:

"'Win32_Directory.Name=""c:\\\\Myfolder\\\\ImportantContent""'"

and this resolves into the following (again check by echoing the value at a
command prompt):

'Win32_Directory.Name="c:\\\\Myfolder\\\\ImportantContent"'

The quadrupled slashes are another issue. In WMI queries, doubled slashes
resolve to single slashes. In any case, the path is definitely enclosed in
quotes, so spaces should not be a problem (as far as I know).

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--
"Juan" <Juan@xxxxxx> wrote in message
news:E6190053-4182-4893-8444-1DC6A8E70FF3@xxxxxx

Hi,


it wasn't a permission issue. And it wasn't a problem of WQL.
The problem was in BLAT.EXE! I opened filemon and I saw that Blat.exe failed
with communicating to some DLLs.

I changed the sending method from Blat.exe to VBScript (CDO) and now it is
working.


Anyway - thanks for your fast replies.



Juan

"Richard Mueller [MVP]" wrote: