List of QoE tables
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. |