The database schema consists of the following tables.
Supporting Tables
Table | Description |
---|---|
Stores SIP User Agent (UA) strings and UA types used in audio and video sessions. |
|
Stores user, conference, and phone URIs used in audio and video sessions. |
|
Stores FQDN computer names of endpoints participating in audio and video sessions. |
|
Stores the names of pools to which metrics data belongs. |
|
Stores capture devices and render devices which are used in an audio/video calls. |
|
Stores Conference URIs for conference scenarios, or DialogID for other scenarios. |
|
Stores CorrelationID for PSTN calls. |
Tables for metrics data
Table | Description |
---|---|
Stores overall information about an audio or audio/video session. A session is defined as an audio or video SIP dialog between two endpoints. |
|
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. |
|
Stores audio media quality metrics for each audio stream in the media line. |
|
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. |