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, 16 is Video based Screen Sharing (VbSS). 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. |