Exchange Server

Frederic ESNOUF (MVP-ISA) · Guest

Hi all,

I am not an expert on WebDav... but I work hard ;-)

I want to create a script or an EXE to extact all the meetings my collegues
have in their Calendar.

My first step was to undestand a little bit this code and I am proud. It
works. Here is my request :

rs.Source = "SELECT ""DAV:href"", " & _
" ""urn:schemas:httpmail:subject"", " & _
" ""urn:schemas:calendar:dtstart"", " & _
" ""urn:schemas:calendar:dtend"", " & _
" ""urn:schemas:httpmail:textdescription"", " & _
" ""urn:schemas:calendar:location"" " & _
"FROM scope('shallow traversal of """ & strURL & """') ORDER BY
""urn:schemas:calendar:dtstart"" ASC "

The first thing that I have discovered it that alle the "All Day events" are
not detected by this request.

So question 1, how can I modify this to get all the events, even the "All
days events".

Then, as you can see with this code, I am about to call this routine for
each 'calendar'.. which could be the worst way.

Question 2 : I wonder if there is a method with only 1 webdav request to
get all the events, of all the calendars I have read access ?

This is a pretty good start isn't it ;-)

Thanks for the advices.

Regards
--
Frédéric ESNOUF (MCSE - ISA MVP)
Email : frederic@esnouf.net
Visit ISAServerFR.org
You plan to implement Quarantine on ISA 2004 ?
Check this : http://www.esnouf.net/qss_main.htm

Tom Rizzo [MSFT] · Guest

There is a property for all day events that you can query on as well. As
for querying across multiple mailboxes, as long as they are in the same
store and you have permissions it should work. It won't work in public
folders.

Tom

--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp

"Frederic ESNOUF (MVP-ISA)" <frederic@esnouf.net> wrote in message
news:OhUr4jZrFHA.3080@TK2MSFTNGP15.phx.gbl...

Frederic ESNOUF (MVP-ISA) · Guest

Hi Tom,

Thanks for your feedback.

what is very strange, is the fact that I do not give any criteria in my
search (all the events ) and get only those which are not all day events
(like if the search was something like 'all the events except all day
events).

I will try to make a few tests today.

BTW... do you plan a new release for your book with SP2 ?

Thanks

--
Frédéric ESNOUF (MCSE - ISA MVP)
Email : frederic@esnouf.net
Visit ISAServerFR.org
You plan to implement Quarantine on ISA 2004 ?
Check this : http://www.esnouf.net/qss_main.htm

"Tom Rizzo [MSFT]" <thomriz@microsoft.com> wrote in message
news:OuyBGEerFHA.3392@TK2MSFTNGP11.phx.gbl...

Mihir Vaidya · Guest

Hi,

I am facing a similar problem... I included urn:schemas:calendar:alldayevent
in the SELECT statement and it did not show the "all day events".

Any solutions?

Mihir Vaidya

"Frederic ESNOUF (MVP-ISA)" wrote:

	Exchange Server Forum Index -> Development	All times are GMT
Page 1 of 1