List of QoE tables in Lync Server 2013
Topic Last Modified: 2012-10-02
The database schema consists of the following tables.
Supporting Tables
| Table | Description |
|---|---|
Stores optimal and acceptable values for the Quality of Experience metrics used with application sharing. |
|
Maps unique codec identifiers to their corresponding codec. |
|
Maps IP addresses to the unique IP address identifiers used elsewhere in the Quality of Experience database. |
|
Maps network connection types to the network connection identifiers used elsewhere in the Quality of Experience database. |
|
Stores information that specifies if (and when) outdated Quality of Experience records will automatically be deleted from the QoE database. |
|
Stores routing information for calls. |
|
Maps user agent identifiers to the agent’s descriptive names. |
|
Stores optimal and acceptable values for the Quality of Experience metrics used with video calls. |
|
Stores Session Initiation Protocol (SIP) User Agent (UA) strings and UA types used in audio and video sessions. |
|
Stores user, conference, and phone URIs used in audio and video sessions. |
|
Stores FQDN computer names of endpoints participating in audio and video sessions. |
|
Stores the names of pools to which metrics data belongs. |
|
Stores capture devices and render devices which are used in an audio/video calls. |
|
Stores driver for the capture device and the render device which are used in audio/video calls. |
|
Stores Conference URIs for conference scenarios or DialogID for other scenarios. |
|
Stores CorrelationID for PSTN calls. |
|
Stores the Codec used in audio/video calls. |
|
Stores the bandwidth source used in audio/video calls. |
|
Stores the MAC address of the endpoints participating in audio and video sessions. |
|
Stores the Dialog ID of audio and video sessions. |
|
Stores the network region defined in NCS setting. |
|
Stores the network site defined in NCS setting. |
|
Stores the subnet defined in NCS setting. |
|
Stores the region link defined in NCS setting. |
|
Stores the network site links defined in NCS setting. |
|
Stores the subnet of the endpoint participating in an audio and video session. |
|
Stores the FQDN or IP address of the server the media goes through. |
Tables for metrics data
| Table | Description |
|---|---|
Stores Quality of Experience metrics for the network streams used for application sharing. Quality of Experience metrics for the network streams used for application sharing. |
|
Stores overall information about an audio or audio/video session. A session is defined as an audio or video SIP dialog between two endpoints. |
|
Stores 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. |
|
Stores audio media quality metrics for each audio stream in the media line. |
|
Stores audio media quality metrics in the media line. This includes acoustic echo cancellation (AEC) and automatic gain control (AGC) metrics. |
|
Stores video media quality metrics for each audio stream in the media line. |
|
Stores audio media quality metrics collected from the client event. |
|
Stores video media quality metrics collected from the client event. |
|
DiagnosticData Table |
Stores diagnostic data which is for internal use only. |
Tables for summary data
| Table | Description |
|---|---|
ServerSummary Table |
Stores summary data for the servers, these data is used for Quality of Experience (QoE) reporting only. |
UserSummary Table |
Stores summary data for users, these data is used for QoE reporting only. |
CallTypeSummary Table |
Store summary data for call types, these data is used for QoE reporting only. |
Tables for Internal Use by Monitoring Server
| Table | Description |
|---|---|
DbConfigDateTime |
For internal use only. |
DbConfigInt |
For internal use only. |
FrontEnd Table |
For internal use only. |
Task Table |
For internal use only. |
SummaryTableConfiguration |
For internal use only. |
DbErrorMessage |
For internal use only. |
MetricsThreshold |
For internal use only. |
DaylightSavingYears |
For internal use only. |
TimeZoneConfiguration |
For internal use only. |
TimeZones |
For internal use only. |
CallSummary Table |
For internal use only. |
DeviceCallSumary Table |
For internal use only. |
Tenant Table |
For internal use only. |
VideoCallSummaryTable |
For internal use only. |
ASCallSummaryTable |
For internal use only. |