• Article

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

019eb330-2453-4daf-b73e-32a7fb65c17e

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.