MediaLine view in Lync Server 2013

 

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 in Lync Server 2013.
SessionSeq	int	Referenced from the MediaLine table in Lync Server 2013.
MediaLineLabel	tinyint	Referenced from the MediaLine table in Lync Server 2013.
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 in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 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).