creating reports out of the exchange datastore

[atropozzz]

hi all!

the problem i have to solve is the following:

my customer wants a .net application to pull reports out of an exchange 2000 server database. for example: number of all employees on vacancy on a certain day. (each employee has to compose an exchange calender message if he is on vacancy.)

i know that i can access the exchange data via collaboration data objects (CDO). what i need is good documentation of the cdo library with lots of code samples - msdn does not satisfy my needs.

a few questions to the vb-code below:

-------------------------------------
Dim CalendarURL As String
Dim ItemURL As String
Dim Rs As New ADODB.Recordset
Dim Rec As New ADODB.Record
Dim Conn As New ADODB.Connection
Dim iAppt As New Appointment
Dim dateStartDate As Date
Dim Subject As String

CalendarURL = "file://./backofficestorage/exchange.microsoft.com/MBX/user12/calendar/"

'Open a recordset for the items in the calendar folder
Rec.Open CalendarURL
Set Rs.ActiveConnection = Rec.ActiveConnection
Rs.Source = "SELECT ""DAV:href"", " & _
" ""urn:schemas:httpmail:subject"", " & _
" ""urn:schemas:calendar:dtstart"", " & _
" ""urn:schemas:calendar:dtend"" " & _
"FROM scope('shallow traversal of """ & CalendarURL & """') " & _
"WHERE (""urn:schemas:calendar:dtstart"" >= CAST(""1999-08-01T08:00:00Z"" as 'dateTime')) " & _
&quot;AND (&quot;&quot;urn:schemas:calendar:dtend&quot;&quot; <= CAST(&quot;&quot;1999-09-01T08:00:00Z&quot;&quot; as 'dateTime'))&quot;
Rs.Open
---------------------------------

.) first of all: is it the right way to access exchange data?

.) supposed i want to get reports concerning calender items of all users of the exchange server, do i have to open the calender-file(s) of every single user?

.) does someone understand the sql-statement? where can i find more information about querying exchange-data?

i would be very grateful for any help / any link supporting me solving this problem.

atro