Topic Last Modified: 2012-10-02

The database schema consists of the following tables.

Supporting Tables

Table Description

AppSharingMetricsThreshold Table

Stores optimal and acceptable values for the Quality of Experience metrics used with application sharing.

CodecDescription Table

Maps unique codec identifiers to their corresponding codec.

IPAddress Table

Maps IP addresses to the unique IP address identifiers used elsewhere in the Quality of Experience database.

NetworkConnectionDetail Table

Maps network connection types to the network connection identifiers used elsewhere in the Quality of Experience database.

PurgeSettings Table (QoE)

Stores information that specifies if (and when) outdated Quality of Experience records will automatically be deleted from the QoE database.

TraceRoute Table

Stores routing information for calls.

UserAgentDef Table (QoE)

Maps user agent identifiers to the agent’s descriptive names.

VideoMetricsThreshold Table

Stores optimal and acceptable values for the Quality of Experience metrics used with video calls.

UserAgent Table

Stores Session Initiation Protocol (SIP) User Agent (UA) strings and UA types used in audio and video sessions.

User Table

Stores user, conference, and phone URIs used in audio and video sessions.

Endpoint Table

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

Pool Table

Stores the names of pools to which metrics data belongs.

Device Table

Stores capture devices and render devices which are used in an audio/video calls.

DeviceDriver Table

Stores driver for the capture device and the render device which are used in audio/video calls.

Conference Table

Stores Conference URIs for conference scenarios or DialogID for other scenarios.

SessionCorrelation Table

Stores CorrelationID for PSTN calls.

PayloadDescription Table

Stores the Codec used in audio/video calls.

AppliedBandwidthSource Table

Stores the bandwidth source used in audio/video calls.

MacAddress Table

Stores the MAC address of the endpoints participating in audio and video sessions.

Dialog Table

Stores the Dialog ID of audio and video sessions.

Region Table

Stores the network region defined in NCS setting.

UserSite Table

Stores the network site defined in NCS setting.

Subnet Table

Stores the subnet defined in NCS setting.

MonitoredRegionLink Table

Stores the region link defined in NCS setting.

MonitoredUserSiteLink Table

Stores the network site links defined in NCS setting.

EndpointSubnet Table

Stores the subnet of the endpoint participating in an audio and video session.

Server Table

Stores the FQDN or IP address of the server the media goes through.

Tables for metrics data

Table Description

AppSharingStream Table

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

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

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

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

AudioSignal Table

Stores audio media quality metrics in the media line. This includes acoustic echo cancellation (AEC) and automatic gain control (AGC) metrics.

VideoStream Table

Stores video media quality metrics for each audio stream in the media line.

AudioClientEvent Table

Stores audio media quality metrics collected from the client event.

VideoClientEvent Table

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.