CallPriorities Table

Stores the list of possible call priorities, such as emergency, urgent, normal, non-urgent, etc

DeRegisterType Table

Stores the list of possible user de-register reasons, such as “client initiated”, “registration expired”, “client crash”, etc.

MediaList Table

Stores the list of media types that can generate entries in the database (for example, IM, audio, video, and file transfer).

Roles Table

Stores the list of possible conference roles (for example, attendee and presenter).

ClientVersions Table

Stores the clients (both client type and version number) of each client involved in a call with information captured in this database.

ConferenceUris Table

Stores a list of ConferenceUris that used in conference related calls.

Devices Table

Stores a list of devices, including their manufacturer, hardware version, and MAC address.

Dialogs Table

Stores information about the DialogID for each session in the database.

EdgeServers Table

Stores a list of Edge Servers that are used for external calls.

Gateways Table

Stores a list of Gateways that are used for VoIP calls.

HardwareVersions Table

Stores a list of hardware versions of devices (desk phone).

Manufacturers Table

Stores a list of Manufacturers of devices (desk phone).

Mcus Table

Stores information about the various conferencing servers and their URIs.

MediationServers Table

Stores a list of Mediation Servers that are used for VoIP calls

Phones Table

Stores all the phone numbers used in VoIP calls that were archived or whose call details were recorded.

Pools Table

Stores the names of pool on which IM messages are captured.

Servers Table

Stores the name of servers involved in calls.

Tenants Table

Stores the Tenants supported by current deployment. There some build-in tenants for Enterprise user, Federated User, PIC user and Anonymous users.

Users Table

Stores the user URIs of users who have participated in sessions recorded or archived in this database.

Conferences Table

Stores information about all conferences that were archived or whose details were recorded, including ConferenceURI, and start and end time.

ConferenceSessionDetails Table

Stores information about every SIP based conference session, including start and end time, user ID, response code, and diagnostic id for each session.

FocusJoinsAndLeaves Table

Stores information about conference joins and leaves, including users’ role and client version.

McuJoinsAndLeaves Table

Stores information about conferencing servers that are involved in a conference, and the user join and leave times.

ConferenceMessageCount Table

For each IM conference, stores the number of messages that were sent by each user.

SessionDetails Table

Stores information about every peer-to-peer session, including start and end time, user ID, response code, and message count for each user.

FileTransfers Table

Stores information about file transfer sessions, including file name and result (accepted, rejected, or cancelled).

Media Table

Stores information about the different media types involved in peer-to-peer sessions.

VoipDetails Table

For each two-party VoIP/PSTN call, stores information about the call, such as the phone ID of VoIP phone, gateway used, and which party disconnected. Refers to the SessionDetails Table for call start/end times and response code.

Note:
If one party on a call is a VoIP user or if a Mediation Server was involved in the call, a record will be created in this table. Information about VoIP/VoIP calls not involving a PSTN phone is captured in the SessionDetails Table.

Locations Table

For each emergency call, such as an Enhanced 9-1-1 (E9-1-1) call, stores location information about the call. Refers to the SessionDetails Table for call start/end times and response code.

Note:
This table only contains the location blob for the E9-1-1 call. Refers to SessionDetails table for other detailed information about the call.

Application Table

Stores information about various processes within Microsoft Communications Server that are involved in routing and connections.

CallType Table

Stores information about types of the call, such as, “audio”, “Instant Messaging”, “audio and video” and “application sharing”.

ErrorDef Table

Stores information about types of errors and their definitions.

ErrorReport Table

Stores information about errors that have occurred.

ProgressReport Table

Stores information about the progress reports of various steps involved in Microsoft Communication Server processes.

DbConfigDateTime

For internal use only.

DbConfigInt

For internal use only.

DbErrorMessage

For internal use only.

UserStatistics

For internal use only.

SummaryTableConfiguration

For internal use only.

UsageSummary_UQ

For internal use only.

UsageSummary

For internal use only.

FailureSummary_UQ

For internal use only.

FailureSummary

For internal use only.

ServerSummary

For internal use only.

MsDiagMetaData

For internal use only.