MediaLine table

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 a conferencing device is used or if Gallery View 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, 3 is Application/Desktop Sharing. This label must be unique within a single session.
ConnectivityIce
tinyint

This column is present but not used in Microsoft Lync Server 2013. Information about the connectivity used for a media line is captured in the CallerConnectivityICE and CalleeConnectivityICE columns.
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
Foreign
IP Address of the caller. See the IPAddress table for more information.
CallerPort
int

Port used by the caller.
CallerSubnet
int
Foreign
The subnet of the caller. See the IPAddress table for more information.
CallerInside
bit

1 means caller is inside the enterprise network, 0 means the caller is outside the network.
CallerMacAddress
int
Foreign
Caller's mac address, referenced from MacAddress table.
CallerRelayIPAddr
int
Foreign
IP Address of the A/V Edge service used by the caller. See the IPAddress table for more information.
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
Foreign
Indicates how the caller connected to the network. Values are obtained from the NetworkConnectionDetail table. Typical values are 0 for a wired connection' 1 for a WiFi connection; and 3 for an Ethernet connection.
CallerBssid
int
Foreign
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
int
Foreign
IP Address of the call receiver. See the IPAddress table for more information.
CalleePort
bit
Port used by the call receiver.
CalleeSubnet
int
Foreign
Subnet of callee. See the IPAddress table for more information.
CalleeInside
bit

1 means call receiver is inside the enterprise network, 0 means the call receiver is outside the network.
CalleeMacAddress
int
Foreign
Callee Mac address. Referenced from the MacAddress table.
CalleeRelayIPAddr
int
Foreign
IP Address of the A/V Edge service used by the call receiver. See the IPAddress table for more information.
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
Foreign
Driver for the call receiver's capture device. Referenced from DeviceDriver table.
CalleeRenderDevDriver
varchar(256)
Foreign
Driver for the call receiver's render device. Referenced from DeviceDriver table.
CalleeNetworkConnectionType
tinyint
Foreign
Indicates how the callee connected to the network. Values are obtained from the NetworkConnectionDetail table. Typical values are 0 for a wired connection' 1 for a WiFi connection; and 3 for an Ethernet connection.
CalleeBssid
int
Foreign
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).
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, a null value is no.
Callee
bit

Indicates whether metrics from the call receiver were received; 1 is yes, a null value is no.
MidCallReport
bit
Indicates whether the report is for a portion of the session or for the complete session.
This column was introduced in Microsoft Lync Server 2013.
ClassifiedPoorCall
bit
Indicates whether a call was classified as a poor call (value of 1) or as a good call (0).
This column was introduced in Microsoft Lync Server 2013.
CallerConnectivityICE
tinyInt
Indicates whether the caller connected to the network using the ICE protocol (Internet Connectivity Establishment).
This column was introduced in Microsoft Lync Server 2013.
CalleeConnectivityICE
tinyint
Indicates whether the caller connected to the network using the ICE protocol (Internet Connectivity Establishment).
This column was introduced in Microsoft Lync Server 2013.
CallerReflexiveLocalIPAddr
int
Foreign
Reflexive IP address of the user who placed the call. In organizations that use NAT (network address translation), the reflexive IP address is the IP address of the proxy server.
This column was introduced in Microsoft Lync Server 2013.
CallerWiFiDriverDevicesDesc
int
Foreign
Device description for the WiFi driver employed by the user who placed the call.
This column was introduced in Microsoft Lync Server 2013.
CallerWiFiDriverVersion
int
Foreign
Version number for the WiFi driver employed by the user who placed the call.
This column was introduced in Microsoft Lync Server 2013.
CalleReflexiveLocalIPAddr
int
Foreign
Reflexive IP address of the user who received the call. In organizations that use NAT (network address translation), the reflexive IP address is the IP address of the proxy server.
This column was introduced in Microsoft Lync Server 2013.
CalleeWiFiDriverDevicesDesc
int
Foreign
Device description for the WiFi driver employed by the user who received the call.
This column was introduced in Microsoft Lync Server 2013.
CalleeWiFiDriverVersion
int
Foreign
Version number for the WiFi driver employed by the user who received the call.
This column was introduced in Microsoft Lync Server 2013.