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. This label must be unique within a single session.

ConnectivityIce

tinyint

Information about media path, such as direct or relayed.

1 is DIRECT.

2 is RELAY.

4 is HTTP.

8 is FAILED.

CallerIceWarningFlags

Int

Information about Interactive Connectivity Establishment (ICE) process described in bits flags. For more 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 more 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

IP Address of the caller.

CallerPort

Int

Port used by the caller.

CallerSubnet

int

The subnet of the caller.

CallerInside

bit

1 means caller is inside the enterprise network, 0 means the caller is outside the network.

CallerMacAddress

Caller’s mac address, referenced from MacAddress Table.

CallerRelayIPAddr

int

IP Address of the Lync Server A/V Edge service used by the caller.

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

The caller's network connection type. 0 is wired, 1 is wireless.

CallerBssid

int

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

bit

IP Address of the call receiver.

CalleePort

bit

Port used by the call receiver.

CalleeSubnet

bit

Subnet of callee.

CalleeInside

Bit

1 means call receiver is inside the enterprise network, 0 means the call receiver is outside the network.

CalleeMacAddress

Callee Mac address. Referenced from the MacAddress Table.

CalleeRelayIPAddr

Int

IP Address of the A/V Edge service used by the call receiver.

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

Driver for the call receiver’s capture device. Referenced from DeviceDriver Table.

CalleeRenderDevDriver

varchar(256)

Driver for the call receiver’s render device. Referenced from DeviceDriver Table.

CalleeNetworkConnectionType

tinyint

The call receiver's network connection type. 0 is wired, 1 is wireless.

CalleeBssid

int

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).

ConversationalMOSAlg

varchar(256)

Not used.

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, 0 is no.

Callee

bit

Indicates whether metrics from the call receiver were received; 1 is yes, 0 is no.