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
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. |