Topic Last Modified: 2013-12-13

Each record represents one video stream. One video media line usually contains two video streams.

Column Data Type Key/Index Details

ConferenceDateTime

datetime

Primary

Referenced from the MediaLine Table.

SessionSeq

int

Primary

R Referenced from the MediaLine Table.

MediaLineLabel

tinyint

Primary

Referenced from the MediaLine Table.

StreamID

int

Primary

Unique ID within a media line.

VideoPayloadDescription

smallint

Foreign, Primary

Payload description. See the PayloadDescription Table for more information.

JitterInterArrival

int

 

Average network jitter from Real Time Control Protocol (RTCP) statistics.

JitterInterArrivalMax

int

 

Maximum network jitter during the video session.

RoundTrip

int

 

Round trip time from RTCP statistics.

RoundTripMax

int

 

Maximum round trip time for the video stream.

PacketLossRate

decimal(5,4)

 

Average packet loss rate during the call.

PacketLossRateMax

decimal(5,4)

 

Maximum packet loss observed during the call.

PacketUtilization

int

 

Packet count for the video stream (Real Time Transport Protocol, RTP).

BandwidthEst

int

 

Bandwidth estimates for the video stream.

VideoResolution

char(9)

 

Resolution of the video in pixels width multiplied by pixels height. Reported as a string.

VideoBitRateAvg

int

 

Average bit rate of the video stream.

InboundVideoFrameRateAvg

decimal(9,4)

 

The video frame rate received.

OutboundVideoFrameRateAvg

decimal(9,4)

 

The video frame rate sent.

VideoBitRateMax

int

 

The maximum video bit rate during the video session.

VideoFrameLossRate

decimal(9,4)

 

The percentage of total video frames that are lost.

VideoFEC

bit

 

Not available.

VideoLocalFrameLossPercentageAvg

decimal(9,4)

The percentage of total video frames that are lost.

CIFQualityRatio

tinyint

The percentage of the call that was at the Common Interchange Format (CIF) resolution.

VGAQualityRatio

tinyint

The percentage of the call that was at VGA resolution.

HD720QualityRatio

tinyint

The percentage of the call that was at HD720 resolution.

NoneDropRatio

tinyint

Percentage of call duration with no frame drop.

BDropRatio

tinyint

Percentage of call duration with B frame drop.

BPDropRatio

tinyint

Percentage of call duration with BP frame drop.

BPSPDropRatio

tinyint

Percentage of call duration with BPSP frame drop.

BPSPIDropRatio

tinyint

Percentage of call duration with BPSPI frame drop.

Inbound

bit

 

Stream data on receiver side is received.

Outbound

bit

 

Stream data on sender side is received.

SenderIsCallerPAI

bit

 

1 means the stream direction is from the caller to callee.

0 means the stream direction is from the callee to the caller.

LossCongestionPercent

float

Indicates the percentage of the time when the call was in a loss congestion state.

This column was introduced in Microsoft Lync Server 2013.

DelayCongestionPercent

float

Indicates the percentage of the call during which congestion was caused by the delayed arrival of network packets.

This column was introduced in Microsoft Lync Server 2013.

ContentionDetectedPercent

float

Indicates the percentage of the time when the call was competing for network resources.

This column was introduced in Microsoft Lync Server 2013.

BandwidthEstMin

int

Minimum amount of bandwidth estimation measured during the call.

This column was introduced in Microsoft Lync Server 2013.

BandwidthEstMax

int

Maximum amount of bandwidth estimation measured during the call.

This column was introduced in Microsoft Lync Server 2013.

BandwidthEstStdDev

int

Standard deviation of the bandwidth estimation measured during the call.

This column was introduced in Microsoft Lync Server 2013.

BandwidthEstAvge

int

Average amount of bandwidth estimation measured during the call.

This column was introduced in Microsoft Lync Server 2013.

LowBandwidthForMultiview

float

Percentage of the call where the endpoint determined that the network connection could not support multiview video.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayTotal

float

Total amount of one-way latency. Relative one-way latency measures the delay between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayAverage

float

Average amount of one-way latency. Relative one-way latency measures the delay between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayMax

float

Maximum amount of one-way latency. Relative one-way latency measures the delay between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayBurstOccurrences

int

Total one-way burst occurrences. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayBurstDensity

int

Total one-way burst density. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayBurstDuration

float

Total one-way burst duration. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayGapOccurrences

int

Total one-way gap occurrences. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream; gaps indicate delays between these bursts. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayGapDensity

float

Total one-way gap density. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream; gaps indicate delays between these bursts. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

RelativeOneWayGapDuration

float

Total one-way gap duration. A “bursty” transmission is a transmission where data flows in unpredictable bursts as opposed to a steady stream; gaps indicate delays between these bursts. This metric measures data flow between the client and the server.

This column was introduced in Microsoft Lync Server 2013.

VideoPacketLossRate

decimal(9,4)

Rate at which video packets were lost.

This column was introduced in Microsoft Lync Server 2013.

VideoAllocateBWAvg

int

Average amount of bandwidth allocated for video.

This column was introduced in Microsoft Lync Server 2013.

SendCodecTypes

smallint

Foreign

Type of video codecs used by the sender. See the CodecDescription Table for more information.

This column was introduced in Microsoft Lync Server 2013.

SendResolutionWidth

int

Resolution width used by the sender.

This column was introduced in Microsoft Lync Server 2013.

SendResolutionHeight

int

Resolution height used by the sender.

This column was introduced in Microsoft Lync Server 2013.

SendFrameRateAverage

float

Average video frame rate transmission used by the sender.

This column was introduced in Microsoft Lync Server 2013.

SendBitRateMaximum

int

Maximum bit rate for the sender.

This column was introduced in Microsoft Lync Server 2013.

SendBitRateAverage

int

Average bit rate for the sender.

SendVideoStreamsMax

int

Maximum number of video streams used by the sender.

This column was introduced in Microsoft Lync Server 2013.

RecvCodecTypes

smallint

Foreign

Video codes used by the receiver. See the CodecDescription Table for more information.

This column was introduced in Microsoft Lync Server 2013.

RecvResolutionWidth

int

Resolution width used by the receiver.

This column was introduced in Microsoft Lync Server 2013.

RecvResolutionHeight

int

Resolution height used by the receiver.

This column was introduced in Microsoft Lync Server 2013.

RecvFrameRateAverage

float

Average video frame rate used by the receiver.

This column was introduced in Microsoft Lync Server 2013.

RecvBitRateMaximum

int

Maximum bit rate for the receiver.

This column was introduced in Microsoft Lync Server 2013.

RecvBitRateAverage

int

Average bit rate for the receiver.

This column was introduced in Microsoft Lync Server 2013.

RecvVideoStreamsMax

int

Maximum video streams for the receiver.

This column was introduced in Microsoft Lync Server 2013.

RecvVideoStreamsMin

int

Minimum video streams for the receiver.

This column was introduced in Microsoft Lync Server 2013.

RecvVideoStreamsMode

int

Video mode (for example, gallery or single stream) for the receiver.

This column was introduced in Microsoft Lync Server 2013.

VideoPostFECPLR

float

Packet loss rate after forward error correction has been applied.

This column was introduced in Microsoft Lync Server 2013.

DynamicCapabilityPercent

float

Percentage of time that the dynamic capability flag was active.

This column was introduced in Microsoft Lync Server 2013.

ResolutionMin

char(9)

Minimum resolution measured during the call.

This column was introduced in Microsoft Lync Server 2013.

LowBitRateCallPercent

float

Percentage of the call below the low bit rate threshold (70 kilobits per second).

This column was introduced in Microsoft Lync Server 2013.

LowFrameRateCallPercent

float

Percentage of the call below the low frame rate threshold (7.5 frames per second, inbound).

This column was introduced in Microsoft Lync Server 2013.

LowResolutionCallPercent

float

Percentage of the call that occurred at the lowest resolution.

This column was introduced in Microsoft Lync Server 2013.

This column was introduced in Microsoft Lync Server 2013.

DurationSeconds

float

Length of the call in seconds.

This column was introduced in Microsoft Lync Server 2013.

IsAggregatedData

bit

Indicates whether the data has been aggregated from multiple calls.

This column was introduced in Microsoft Lync Server 2013.