VideoStream table in Lync Server 2013
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 in Lync Server 2013. |
SessionSeq |
int |
Primary |
R Referenced from the MediaLine table in Lync Server 2013. |
MediaLineLabel |
tinyint |
Primary |
Referenced from the MediaLine table in Lync Server 2013. |
StreamID |
int |
Primary |
Unique ID within a media line. |
VideoPayloadDescription |
smallint |
Foreign, Primary |
Payload description. See the PayloadDescription table in Lync Server 2013 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 in Lync Server 2013 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 in Lync Server 2013 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. |