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.

Offerer

bit

 

Not used.

Answerer

bit

 

Not used.

Security

Tinyint

 

The security profile in use. 0 os 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.

CallerSubnetMask

int

 

The subnet mask of the caller.

CallerInside

bit

 

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

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.

CallerRelaySubnetMask

Int

 

Subnet Mask of the A/V Edge service used by the caller.

CallerRelayInside

bit

 

Not used.

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

varchar(256)

 

Driver for the caller’s capture device.

CallerRenderDevDriver

varchar(256)

 

Driver for the caller’s render device .

CallerNetworkConnectionType

tinyint

 

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

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.

CalleeSubnetMask

bit

 

Subnet Mask of the A/V Edge service used by the call receiver.

CalleeInside

Bit

 

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

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.

CalleeRelaySubnetMask

Int

 

Subnet mask of the A/V Edge service used by the call receiver.

CalleeRelayInside

Bit

 

Not used,

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

varchar(256)

 

Driver for the the call receiver’s capture device.

CalleeRenderDevDriver

varchar(256)

 

Driver for the the call receiver’s render device.

CalleeNetworkConnectionType

tinyint

 

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

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.

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.