Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |