Each record represents one media line. (One audio session usually contains one audio media line. One audio/video session usually contains one audio media line and one video media line, although the session might contains two video media lines if the Microsoft RoundTable conferencing device is used)
Column | Data Type | Key/Index | Details |
---|---|---|---|
ConferenceDateTime |
Datetime |
Primary |
Referenced from Session Table. |
SessionSeq |
Int |
Primary |
Referenced from Session Table. |
MediaLineLabel |
tinyint |
Primary |
0 is main audio, 1 is main video, and 2 is panoramic video. This label must be unique within a single session. |
ConnectivityIce |
tinyint |
|
Information about media path, such as direct or relayed. 1 is DIRECT 2 is RELAY 4 is HTTP 8 is FAILED |
CallerIceWarningFlags |
Int |
|
Information about ICE process described in bits flags. For more details, refer to the Quality of Experience Monitoring Server Protocol Specification, available for download. |
CalleeIceWarningFlags |
int |
|
Same as CallerIceWarningFlags, but on Callee side. For more details, refer to the Quality of Experience Monitoring Server Protocol Specification, available for download. |
Offerer |
bit |
|
Not used. |
Answerer |
bit |
|
Not used. |
Security |
Tinyint |
|
The security profile in use. 0 os NONE, 1 is SRTP, 2 is V1. |
Transport |
Tinyint |
|
0 is UDP, 1 is TCP. |
CallerIPAddr |
Int |
|
IP Address of the caller. |
CallerPort |
Int |
|
Port used by the caller. |
CallerSubnetMask |
int |
|
The subnet mask of the caller. |
CallerInside |
bit |
|
1 means caller is inside the enterprise network, 0 means the caller is outside the network. |
CallerRelayIPAddr |
int |
|
IP Address of the A/V Edge service used by the caller. |
CallerRelayPort |
Int |
|
Port used on the A/V Edge service by the caller. |
CallerRelaySubnetMask |
Int |
|
Subnet Mask of the A/V Edge service used by the caller. |
CallerRelayInside |
bit |
|
Not used. |
CallerCaptureDev |
int |
foreign |
Capture device used by the caller, referenced from the Device Table |
CallerRenderDev |
Int |
foreign |
Render device used by caller, referenced from Device table. |
CallerCaptureDevDriver |
varchar(256) |
|
Driver for the caller’s capture device. |
CallerRenderDevDriver |
varchar(256) |
|
Driver for the caller’s render device . |
CallerNetworkConnectionType |
tinyint |
|
The caller's network connection type; 0 is Wired, 1 is wireless. |
CallerVPN |
bit |
|
The Caller's link; 1 is virtual private network (VPN), 0 is non-VPN. |
CallerLinkSpeed |
decimal(18,0) |
|
The network link speed in bps for the caller's endpoint. |
CalleeIPAddr |
bit |
|
IP Address of the call receiver. |
CalleePort |
Bit |
|
Port used by the call receiver. |
CalleeSubnetMask |
bit |
|
Subnet Mask of the A/V Edge service used by the call receiver. |
CalleeInside |
Bit |
|
1 means call receiver is inside the enterprise network, 0 means the call receiver is outside the network. |
CalleeRelayIPAddr |
Int |
|
IP Address of the A/V Edge service used by the call receiver. |
CalleeRelayPort |
Int |
|
Port used on the A/V Edge Service by the call receiver. |
CalleeRelaySubnetMask |
Int |
|
Subnet mask of the A/V Edge service used by the call receiver. |
CalleeRelayInside |
Bit |
|
Not used, |
CalleeCaptureDev |
Int |
foreign |
Capture device used by the call receiver, referenced from the Device Table. |
CalleeRenderDev |
Int |
foreign |
Render device used by the call receiver, referenced from the Device Table. |
CalleeCaptureDevDriver |
varchar(256) |
|
Driver for the the call receiver’s capture device. |
CalleeRenderDevDriver |
varchar(256) |
|
Driver for the the call receiver’s render device. |
CalleeNetworkConnectionType |
tinyint |
|
The call receiver's network connection type; 0 is Wired, 1 is wireless. |
CalleeVPN |
bit |
|
The call receiver’s link; 1 is virtual private network (VPN), 0 is non-VPN. |
CalleeLinkSpeed |
decimal(18,0) |
|
The network link speed in bps for the call receiver’s endpoint. |
ConversationalMOS |
decimal(3,2) |
|
Narrowband Conversational MOS of the audio sessions (based on both audio streams). |
ConversationalMOSAlg |
varchar(256) |
|
Not used. |
Caller |
Bit |
|
Indicate whether metrics from the caller were received; 1 is yes, 0 is no. |
Callee |
bit |
|
Indicate whether metrics from the call receiver were received; 1 is yes, 0 is no. |