VideoStream table

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.