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
AppSharingMetricsThreshold table in Lync Server 2013	Stores optimal and acceptable values for the Quality of Experience metrics used with application sharing.
CodecDescription table in Lync Server 2013	Maps unique codec identifiers to their corresponding codec.
IPAddress table in Lync Server 2013	Maps IP addresses to the unique IP address identifiers used elsewhere in the Quality of Experience database.
NetworkConnectionDetail table in Lync Server 2013	Maps network connection types to the network connection identifiers used elsewhere in the Quality of Experience database.
PurgeSettings table (QoE) in Lync Server 2013	Stores information that specifies if (and when) outdated Quality of Experience records will automatically be deleted from the QoE database.
TraceRoute table in Lync Server 2013	Stores routing information for calls.
UserAgentDef table (QoE) in Lync Server 2013	Maps user agent identifiers to the agent’s descriptive names.
VideoMetricsThreshold table in Lync Server 2013	Stores optimal and acceptable values for the Quality of Experience metrics used with video calls.
UserAgent table in Lync Server 2013	Stores Session Initiation Protocol (SIP) User Agent (UA) strings and UA types used in audio and video sessions.
User table in Lync Server 2013	Stores user, conference, and phone URIs used in audio and video sessions.
Endpoint table in Lync Server 2013	Stores FQDN computer names of endpoints participating in audio and video sessions.
Pool table in Lync Server 2013	Stores the names of pools to which metrics data belongs.
Device table in Lync Server 2013	Stores capture devices and render devices which are used in an audio/video calls.
DeviceDriver table in Lync Server 2013	Stores driver for the capture device and the render device which are used in audio/video calls.
Conference table in Lync Server 2013	Stores Conference URIs for conference scenarios or DialogID for other scenarios.
SessionCorrelation table in Lync Server 2013	Stores CorrelationID for PSTN calls.
PayloadDescription table in Lync Server 2013	Stores the Codec used in audio/video calls.
AppliedBandwidthSource table in Lync Server 2013	Stores the bandwidth source used in audio/video calls.
MacAddress table in Lync Server 2013	Stores the MAC address of the endpoints participating in audio and video sessions.
Dialog table in Lync Server 2013	Stores the Dialog ID of audio and video sessions.
Region table in Lync Server 2013	Stores the network region defined in NCS setting.
UserSite table in Lync Server 2013	Stores the network site defined in NCS setting.
Subnet table in Lync Server 2013	Stores the subnet defined in NCS setting.
MonitoredRegionLink table in Lync Server 2013	Stores the region link defined in NCS setting.
MonitoredUserSiteLink table	Stores the network site links defined in NCS setting.
EndpointSubnet table in Lync Server 2013	Stores the subnet of the endpoint participating in an audio and video session.
Server table in Lync Server 2013	Stores the FQDN or IP address of the server the media goes through.

Tables for metrics data

Table	Description
AppSharingStream table in Lync Server 2013	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.
Session table in Lync Server 2013	Stores overall information about an audio or audio/video session. A session is defined as an audio or video SIP dialog between two endpoints.
MediaLine table in Lync Server 2013	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.
AudioStream table in Lync Server 2013	Stores audio media quality metrics for each audio stream in the media line.
AudioSignal table in Lync Server 2013	Stores audio media quality metrics in the media line. This includes acoustic echo cancellation (AEC) and automatic gain control (AGC) metrics.
VideoStream table in Lync Server 2013	Stores video media quality metrics for each audio stream in the media line.
AudioClientEvent table in Lync Server 2013	Stores audio media quality metrics collected from the client event.
VideoClientEvent table in Lync Server 2013	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.