Topic Last Modified: 2012-10-03
The MediaLine View stores information about each media line in the database. One audio session typically contains one audio media line. One audio and video (A/V) session typically contains one audio media line and one video media line; however, the session might contain two video media lines if a conferencing device is used or if Gallery View is used. This view was introduced in Microsoft Lync Server 2013.
Column | Data Type | details |
---|---|---|
ConferenceDateTime |
datetime |
Referenced from the MediaLine Table. |
SessionSeq |
int |
Referenced from the MediaLine Table. |
MediaLineLabel |
tinyint |
Referenced from the MediaLine Table. |
CallerIceWarningFlags |
int |
Information about Interactive Connectivity Establishment (ICE) process described in bits flags for the caller. For details, refer to the Quality of Experience Monitoring Server Protocol Specification. |
CalleeIceWarningFlags |
int |
Information about Interactive Connectivity Establishment (ICE) process described in bits flags for the callee. For details, refer to the Quality of Experience Monitoring Server Protocol Specification. |
Security |
tinyint |
Security profile in use. 0 is NONE, 1 is SRTP, 2 is V1. |
Transport |
tinyint |
Transport type. 0 is UDP, 1 is TCP. |
CallerIPAddr |
var(50) |
IP address of the caller. This can be either an IPv4 or IPv6 address. |
CallerPort |
int |
Port used by the caller. |
CallerInside |
bit |
Indicates whether or not the caller is inside the organization network. 1 means that the caller is inside the enterprise network. 0 means that the caller is outside the network. |
CallerMacAddress |
varchar(256) |
MAC address of network interface used by caller. |
CallerRelayIPAddr |
var(50) |
IP Address of the A/V Edge service used by the caller. See the IPAddress Table for more information. |
CalleeRelayPort |
int |
Port used on the A/V Edge service used by the caller. |
CallerReflexiveIPAddr |
var(50) |
Caller’s IP address as reported by the A/V Edge service. This address may be different that the CallerIPAddr if the client is located behind a NAT for example. |
CallerCaptureDev |
varchar(256) |
Caller’s capture device name. |
CallerRenderDev |
varchar(256) |
Caller’s render device name. |
CallerCaptureDevDriver |
varchar(256) |
Caller’s capture device driver name. |
CallerRenderDevDriver |
varchar(256) |
Caller’s render device driver name. |
CallerWifiDriverDeviceDesc |
varchar(256 |
Caller’s Wifi driver description. |
CallerWifiDriverVersion |
varchar(256) |
Caller’s Wifi driver version. |
CalleeNetworkConnectionDetail |
varchar(256) |
Details of caller’s network connection. See the NetworkConnectionDetail Table for more information. |
CallerBssid |
varchar(256) |
Basic Service Set Identifier used by callers WiFi connection. |
CallerVPN |
bit |
Indicates whether the caller connected over a virtual private network. 1 is virtual private network (VPN), 0 is non-VPN. |
CalleeIPAddr |
var(50) |
IP address of the callee. This can be either an IPv4 or IPv6 address. |
CalleePort |
int |
Port used by the callee. |
CalleeInside |
bit |
Indicates whether the callee is inside the enterprise network. 1 means callee is inside the enterprise network, 0 means the callee is outside the network. |
CalleeMacAddress |
varchar(256) |
MAC address of network interface used by callee. |
CalleeRelayIPAddr |
var(50) |
IP Address of the A/V Edge service used by the callee. See the IPAddress Table for more information. |
CalleeRelayPort |
int |
Port used on the A/V Edge service used by the callee. |
CalleeReflexiveIPAddr |
var(50) |
Callee’s IP address as reported by the A/V Edge service. This address may be different that the CalleeIPAddr if the client is located behind a NAT for example. |
CalleeCaptureDev |
var(50) |
Callee’s capture device name. |
CalleeRenderDev |
varchar(256) |
Callee’s render device name. |
CalleeCaptureDevDriver |
varchar(256) |
Callee’s capture device driver name. |
CalleeRenderDevDriver |
varchar(256) |
Callee’s render device driver name. |
CalleeWifiDriverDeviceDesc |
varchar(256) |
Callee’s Wifi driver description. |
CalleeWifiDriverVersion |
varchar(256 |
Callee’s Wifi driver version. |
CalleeNetworkConnectionDetail |
varchar(256) |
Details of callee’s network connection. See the NetworkConnectionDetail Table for more information. |
CalleeBssid |
varchar(256) |
Basic Service Set Identifier used by callee’s WiFi connection. |
CalleeVPN |
bit |
Indicates whether the callee connected over a virtual private network. 1 is virtual private network (VPN), 0 is non-VPN. |
ConversationalMOS |
decimal(3,2) |
Narrowband Conversational MOS of the audio sessions (based on both audio streams). |
AppliedBandwidthLimit |
int |
This is the actual bandwidth applied to the given send side stream given various policy settings (TURN, API, SDP, Policy Server, etc.). This should 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. |
AppliedBandwidthSource |
varchar(256) |
Source of the bandwidth cap being imposed. It describes where the bandwidth limit is coming from (for example, “Policy Server”, “TURN Server”, or “Modality”). |
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. |
MidCallReport |
bit |
Indicates whether the report is for a portion of the call or for the complete call. |
ClassifiedPoorCall |
bit |
Indicates whether a call was classified as a poor call (1) or as a good call (0). |
CallerConnectivityICE |
tinyint |
Indicates whether the caller connected to the network using the ICE protocol (Internet Connectivity Establishment). |
CalleeConnectivityICE |
tinyint |
Indicates whether the user called connected to the network using the ICE protocol (Internet Connectivity Establishment). |