Querying Exchange for meetings via WebDAV

[csteinhilber]

Okay, my other WebDAV posting went over 'round here like a lead balloon, so maybe this isn't the proper forum.

But I'm simply trying to pull all the meetings scheduled for a particular week in a specific calendar in a given Exchange 2000 public folder. And I'm not having 100% success. I can get some meetings, but not others. And it appears to be related to how the meeting was entered into the calendar; an "appointment" item vs. a "meeting" item vs. a recurring "meeting" item.

My original query looked like:

<?xml version='1.0'?><d:searchrequest xmlns:d="DAV:" xmlns:cal="urn:schemas:calendar:" ><d:sql> SELECT "DAV:href",  "urn:schemas:calendar:dtstart",  "urn:schemas:httpmail:fromname",  "urn:schemas:httpmail:subject",  "urn:schemas:calendar:location",  "urn:schemas:calendar:dtend", "urn:schemas:httpmail:fromemail"  FROM Scope('SHALLOW TRAVERSAL OF "[URL unfurl="true"]http://exchange.server.com/public/meetingroom1"[/URL] ')WHERE "DAV:contentclass" = 'urn:content-classes:appointment' AND "urn:schemas:calendar:dtstart" &lt;=CAST("2007-09-15T23:59:00.000Z" AS "dateTime.tz") AND "urn:schemas:calendar:dtend" &gt;=CAST("2007-09-09T00:00:00.000Z" AS "dateTime.tz")  ORDER BY "urn:schemas:calendar:dtstart"</></>

This worked well to pull all the "appointment" items. But, for some reason, this calendar also has "meeting" items. So I revised the query to be:

<?xml version='1.0'?><d:searchrequest xmlns:d="DAV:" xmlns:cal="urn:schemas:calendar:" ><d:sql> SELECT "DAV:href",  "urn:schemas:calendar:dtstart",  "urn:schemas:httpmail:fromname",  "urn:schemas:httpmail:subject",  "urn:schemas:calendar:location",  "urn:schemas:calendar:dtend", "urn:schemas:httpmail:fromemail"  FROM Scope('SHALLOW TRAVERSAL OF "[URL unfurl="true"]http://exchange.server.com/public/meetingroom1"[/URL] ')WHERE ("DAV:contentclass" = 'urn:content-classes:appointment' AND "urn:schemas:calendar:dtstart" &lt;=CAST("2007-09-15T23:59:00.000Z" AS "dateTime.tz") AND "urn:schemas:calendar:dtend" &gt;=CAST("2007-09-09T00:00:00.000Z" AS "dateTime.tz") ) OR ("DAV:contentclass" = 'urn:content-classes:calendarmessage' AND "urn:schemas:calendar:dtstart" &lt;=CAST("2007-09-15T23:59:00.000Z" AS "dateTime.tz") AND "urn:schemas:calendar:dtend" &gt;=CAST("2007-09-09T00:00:00.000Z" AS "dateTime.tz") ) ORDER BY "urn:schemas:calendar:dtstart"</></>

And this works well to pull both the "appointments" and "meetings", EXCEPT FOR any recurring meetings. If I take out the WHERE filter for the dates and leave the "DAV:contentclass" = 'urn:content-classes:calendarmessage', I now get the recurring meetings, so I assume that dtstart and/or dtend are not valid attributes for a recurring meeting. But I've been unable to find any documentation as to exactly what the valid attributes are.

Can anybody help me out to determine what I need to do to get back ALL single meetings and single appointments that fall within the specified week, as well as any recurring meetings that have an instance that falls within the same week?


Any help would be appreciated. Or, if there's a more appropriate forum anyone can think of for this post, let me know.

Thanks in advance,
-Carl