MediaLine Table
Topic Last Modified: 2011-07-17
Each record represents one media line. (One audio session usually contains one audio media line. One audio and video (A/V) session usually contains one audio media line and one video media line, although the session might contain two video media lines if the Microsoft RoundTable conferencing device is used.)
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
ConferenceDateTime |
Datetime |
Primary |
Referenced from the Session Table. |
SessionSeq |
Int |
Primary |
Referenced from the 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 Interactive Connectivity Establishment (ICE) process described in bits flags. For details, refer to the Quality of Experience Monitoring Server Protocol Specification, available for download. |
CalleeIceWarningFlags |
int |
|
Same as CallerIceWarningFlags, but on the callee side. For details, refer to the Quality of Experience Monitoring Server Protocol Specification, available for download. |
Security |
Tinyint |
|
The security profile in use. 0 is 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. |
CallerSubnet |
int |
|
The subnet of the caller. |
CallerInside |
bit |
|
1 means caller is inside the enterprise network, 0 means the caller is outside the network. |
CallerMacAddress |
Caller’s mac address, referenced from MacAddress Table. |
||
CallerRelayIPAddr |
int |
|
IP Address of the Lync Server A/V Edge service used by the caller. |
CallerRelayPort |
Int |
|
Port used on the A/V Edge service by the caller. |
CallerCaptureDev |
int |
foreign |
Capture device used by the caller. Referenced from the Device Table. |
CallerRenderDev |
int |
foreign |
Render device used by caller. Referenced from the Device Table. |
CallerCaptureDevDriver |
int |
foreign |
Driver for the caller’s capture device, referenced from the DeviceDriver Table. |
CallerRenderDevDriver |
int |
foreign |
Driver for the caller’s render device, referenced from the DeviceDriver Table. |
CallerNetworkConnectionType |
tinyint |
The caller's network connection type. 0 is wired, 1 is wireless. |
|
CallerBssid |
int |
Caller’s BSSID if wireless is used. Referenced from MacAddress Table. |
|
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. |
|
CalleeSubnet |
bit |
|
Subnet of callee. |
CalleeInside |
Bit |
|
1 means call receiver is inside the enterprise network, 0 means the call receiver is outside the network. |
CalleeMacAddress |
Callee Mac address. Referenced from the MacAddress Table. |
||
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. |
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 |
Int |
|
Driver for the call receiver’s capture device. Referenced from DeviceDriver Table. |
CalleeRenderDevDriver |
varchar(256) |
|
Driver for the call receiver’s render device. Referenced from DeviceDriver Table. |
CalleeNetworkConnectionType |
tinyint |
|
The call receiver's network connection type. 0 is wired, 1 is wireless. |
CalleeBssid |
int |
Callee’s BSSID if wireless is used. Referenced from MacAddress Table. |
|
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. |
AppliedBandwidthLimit |
int |
This is the actual bandwidth applied to the given send side stream given various policy settings (TURN, API, SDP, Policy Server, and so on). This is not to be confused with the effective bandwidth because there can be a lower effective bandwidth based on the bandwidth estimate. This is basically the maximum bandwidth the send stream can take barring limits imposed by the bandwidth estimate. |
|
AppliedBandwidthSourceKey |
smallint |
This is the source of the bandwidth cap being imposed. It describes where the bandwidth limit is coming from (“Policy Server”, “TURN Server”, “Modality”, and so on). Referenced from the AppliedBandwidthSource Table. |
|
Caller |
Bit |
|
Indicates whether metrics from the caller were received; 1 is yes, 0 is no. |
Callee |
bit |
|
Indicates whether metrics from the call receiver were received; 1 is yes, 0 is no. |