List of QoE tables in Lync Server 2013

  • Article

 

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.