[This is pre-release documentation and subject to change in future releases. This topic's current status is: Milestone-Ready]

Topic Last Modified: 2010-03-26

Each record represents one media line. (One audio session usually contains one audio media line. One audio/video session usually contains one audio media line and one video media line, although the session might contains two video media lines if the Microsoft RoundTable conferencing device is used)

Column Data Type Key/Index Details

ConferenceDateTime

Datetime

Primary

Referenced from Session Table.

SessionSeq

Int

Primary

Referenced from 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 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 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 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 Device table.

CallerCaptureDevDriver

int

foreign

Driver for the caller’s capture device, referenced from DeviceDriver Table

CallerRenderDevDriver

int

foreign

Driver for the caller’s render device, referenced from 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 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, etc…). This is not to be confused with the effective bandwidth since 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”, etc…). Referenced from AppliedBandwidthSource Table.

Caller

Bit

 

Indicate whether metrics from the caller were received; 1 is yes, 0 is no.

Callee

bit

 

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