Archiving and CDR
Microsoft Office Communications Server 2007 and Microsoft Office Communications Server 2007 R2 will reach end of support on January 9, 2018. To stay supported, you will need to upgrade. For more information, see Resources to help you upgrade your Office 2007 servers and clients.
The Microsoft® Office Communications Server 2007 Archiving and CDR Server provides a solution for archiving instant messaging (IM) conversations and group conferences, and for capturing usage information related to file transfers, audio/video (A/V) conversations, application sharing, remote assistance, meetings, and conferencing servers in call detail records. The Archiving and CDR Server can archive all instant messaging (IM) conversations for all users or for individual users that you specify. The Archiving and CDR Server can also archive call detail records for all users.
Messages from each Office Communications Server configured for archiving are sent through the Windows Server® Message Queuing service to the Archiving and CDR Server, which uses a Microsoft SQL Server® database to store archived information.
Although the archiving and CDR agent is automatically installed as part of the core Office Communications Server process, in order to archive IM traffic and call data, you must configure the archiving and CDR agent, as well as install the Archiving and CDR Server to which the archiving and CDR agent connects. Archiving and CDR enable Office Communications Server to archive all instant messaging (IM) conversations for all users or for individual users that you specify, as well as archive call detail records for all users.
The Archiving and CDR Server consists of three components:
Destination queue, which is managed by Microsoft Message Queuing
Archiving and CDR Service component
Archiving back-end database
The Archiving and CDR Service component can reside on the same computer as the archiving database or it can connect to a database on a different computer. Figure 9 shows the archiving architecture in Office Communications Server 2007.
Figure 9. Archiving and CDR logical components
Database Schema
This section describes the Archiving and CDR Server database schema for Office Communications Server 2007. The schema is subject to change in future releases.
Tables 2 and 3 show the static and supporting tables for the Archiving and CDR Server.
Table 2 Static tables
Table Name | Table Contents |
---|---|
MediaList |
Stores the list of different media types. |
Roles |
Stores the type of roles to which conference participants can be assigned. |
The following supporting tables are referred to by the static tables for archiving and CDR.
Table 3 Supporting tables
Table Name | Table Contents |
---|---|
ClientVersions |
Stores information about client versions. |
Computers |
Stores the Front End Server host name. |
ContentTypes |
Stores the available content types for instant messages. |
Dialogs |
Stores information about the DialogId (CallId, FromTag, and ToTag) for each peer-to-peer session. This table is referred to by the SessionDetails table. |
Gateways |
Stores the list of gateways used for VoIP calls. |
Mcus |
Stores information about the different conferencing servers (MCUs) and their URIs. |
Users |
Stores all user URIs. |
Phones |
Stores all phone numbers/URIs used in VoIP calls. |
The following tables are specific to conference CDRs.
Table 4 Conference CDR tables
Table Name | Table Contents |
---|---|
Conferences |
Stores information about all the conferences (ConferenceURI and Start and End Times). This table is referred to by the IM Conference archiving tables. |
FocusJoinsAndLeaves |
Stores information about when each user joins and leaves the conference Focus. Information includes the user's role and client version. |
McuJoinsAndLeaves |
Stores information about all the conferencing servers (MCUs) involved in a conference and information about when each user joins and leaves each conferencing server. |
The following tables are specific to IM conference archiving.
Table 5 IM Conference archiving tables
Table Name | Table Contents |
---|---|
ConferenceMessageCount |
Stores the message count per user, per conference. |
ConferenceMessageRecipientList |
Stores the list of recipients of each message sent in a conference. |
ConferenceMessages |
Archives all the messages sent in a conference. |
The following tables are specific to peer-to-peer CDRs.
Table 6 Peer-to-peer (P2P) CDR tables
Table Name | Table Contents |
---|---|
SessionDetails |
Stores information about every peer-to-peer session, including start time, end time, from and to user IDs, response code, and message count for each user. |
FileTransfers |
Stores information about file transfer sessions (file name and if it was accepted, rejected, or cancelled). |
Media |
Stores information about media types used in peer-to-peer sessions. |
The following table contains all messages archived during peer-to-peer sessions.
Table 7 Peer-to-peer (P2P) archiving table
Table Name | Table Contents |
---|---|
Messages |
Stores messages archived during peer-to-peer (one-to-one) instant messaging sessions. |
The following table is specific to VoIP CDRs.
Table 8 VoIP CDR table
Table Name | Table Contents |
---|---|
VoipDetails |
Stores information about VoIP calls (number of caller, number of called party, who disconnected the call, and what gateway was used). This table refers to the SessionDetails table. |