Part VI: Database Schema

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.

This section provides an overview of the QoE Monitoring Server database schema. Any direct access to the database by using the active QoE Monitoring Server may cause severe performance degradation of the QoE Monitoring Server.

The following diagram shows the QoE Monitoring Server database relationships, as well as the primary and unique keys.

Figure 7. QoE Monitoring Server Database Relationships, Primary, and Foreign Keys

340ea8ec-206f-425b-aa50-eea2290d5330

The following table explains each attribute and what data it stores.

Table 15. Audio and Video Metrics

Table Name Table Contents

Audio Stream

Audio media quality metrics for each audio stream in the media line.

Conference

Conference URI and start time of conferences.

Endpoint

FQDN computer names of endpoints participating in audio and video sessions.

MediaLine

Information about each media line in a session. A media line is a collection of one or more audio and video streams. Typically, a single media line will have two streams, either audio or video.

Pool

FQDN pool name used in audio and video sessions.

Session

Overall information about an audio or video session. A session is defined as an audio or video SIP dialog between two UC endpoints.

User

User, conference, and phone URIs used in audio and video sessions.

User Agent

SIP User Agent (UA) strings and UA types used in audio and video Sessions.

Video Stream

Video media quality metrics for each audio stream in the media line.