Topic Last Modified: 2014-02-21

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 Lync Server 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.