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.

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.

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.

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.

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.