The database schema consists of the following tables.

Supporting Tables

Table Description

UserAgent Table

Stores 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.

Conference Table

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

SessionCorrelation Table

Stores CorrelationID for PSTN calls.

Tables for metrics data

Table Description

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.

VideoStream Table

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

Tables for Internal Use by Monitoring Server

Table Description

DbConfigDateTime

For internal use only.

DbConfigInt

For internal use only.

DbErrorMessage

For internal use only.

MSFT_SIPQMSDBConfigSetting

For internal use only.

MSFT_SIPQMSDynamicSubnet

For internal use only.

MSFT_SIPQMSMonitoredAVMCU

For internal use only.

MSFT_SIPQMSMonitoredMediationServer

For internal use only.

MSFT_SIPQMSSingleMaskSubnet

For internal use only.

MSFT_SIPQMSStaticLocation

For internal use only.

MSFT_SIPQMSStaticSubnet

For internal use only.