AudioStream table

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

*Column* *Data Type* *Key/Index* *Details*
ConferenceDateTime
datetime
Primary
Referenced from the MediaLine table.
SessionSeq
int
Primary
Referenced from the MediaLine table.
MediaLineLabel
tinyint
Primary
Referenced from the MediaLine table.
StreamID
int
Primary
Unique ID within a media line.
JitterInterArrival
int

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

Maximum network jitter during the call.
PacketLossRate
decimal(5,4)

Average packet loss rate during the call.
PacketLossRateMax
decimal(5,4)

Maximum packet loss observed during the call.
BurstDensity
decimal(9,4)

Average density of packet Loss during bursts of losses during the call.
BurstDuration
int

Average duration of packet loss during bursts of losses during the call.
BurstGapDensity
decimal(9,4)

Average density of packet loss during gaps between bursts of packet loss.
BurstGapDuration
int

Average duration of gaps between bursts of packet loss.
PacketUtilization
Int

Packet count for the audio stream.
BandwidthEst
Int

Bandwidth estimates for the audio stream.
DegradationAvg
decimal(3,2)

Network MOS Degradation for the whole call. Range is 0.0 to 5.0. This metric shows the amount the Network MOS was reduced because of jitter and packet loss. For acceptable quality it should less than 0.5.
DegradationMax
decimal(3,2)

Maximum Network MOS degradation during the call.
DegradationJitterAvg
decimal(3,2)

Network MOS degradation caused by jitter.
DegradationPacketLossAvg
decimal(3,2)

Network MOS degradation caused by packet loss.
AudioPayloadDescription
int
Foreign
The audio Codec used for the call, referenced from PayloadDescription Table.
AudioSampleRate
int

Sampling rate for the audio stream.
RoundTrip
int

Round trip time from RTCP statistics. For acceptable quality this should be less than 100ms.
RoundTripMax
int

Maximum round trip time for the audio stream.
OverallAvgNetworkMOS
decimal(3,2)

Average wideband Network MOS for the call. This metric depends on the packet loss, jitter, and codec used. Range is [1.0 to 5.0].
OverallMinNetworkMOS
decimal(3,2)

The minimum wideband Network MOS for the call.
SendListenMOS
decimal(3,2)

The average predicted wideband Listening MOS score for audio sent, including speech level, noise level and capture device characteristics.
SendListenMOSMin
decimal(3,2)

The minimum SendListenMOS for the call.
RecvListenMOS
decimal(3,2)

The average predicted wideband Listening MOS score for audio received from the network including speech level, noise level, codec, network conditions and capture device characteristics.
RecvListenMOSMin
decimal(3,2)

The minimum RecvListenMOS for the call.
AudioFECUsed
bit
Flag indicating if audio FEC was used for the call.
RatioConcealedSamplesAvg
decimal(5,2)
Average ratio of concealed samples generated by audio healing to typical samples.
RatioStretchedSamplesAvg
decimal(5,2)
Average ratio of stretched samples generated by audio healing to typical samples.
RatioCompressedSamplesAvg
decimal(5,2)
Average ratio of compressed samples generated by audio healing to typical samples.
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 the callee.
0 means the stream direction is from the callee to the caller.
JitterInterArrivalSD
float
Standard deviation for jitter arrival times.
This column was introduced in Microsoft Lync Server 2013.
ConcealRatioMax
float
Maximum ratio of packets concealed by the healer.
This column was introduced in Microsoft Lync Server 2013.
ConcealRatioSD
float
Standard deviation for the ratio of packets concealed by the healer.
This column was introduced in Microsoft Lync Server 2013.
HealerPacketDropRatio
float
Ratio of packets dropped by the healer compared to the total number of packets received.
This column was introduced in Microsoft Lync Server 2013.
HealerFECPacketUsedRatio
float
Ratio of used forward error correction packets compared to the total number of packets received.
This column was introduced in Microsoft Lync Server 2013.
MaxCompressedSamples
float
Maximum number of audio packets that were compressed by the healer.
This column was introduced in Microsoft Lync Server 2013.
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.
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
float
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.
DecodeStereoPercent
float
Percentage of the call decoded as stereo.
This column was introduced in Microsoft Lync Server 2013.
AecRenderStereoPercent
float
Percentage of the call rendered as stereo by the acoustic echo canceller.
This column was introduced in Microsoft Lync Server 2013.
AudioPostFECPLR
float
Packet loss rate after forward error correction has been applied.
This column was introduced in Microsoft Lync Server 2013.
EncodeStereoPercent
float
Percentage of the call encoded as stereo.
This column was introduced in Microsoft Lync Server 2013.
AecCaptureStereoPercent
float
Percentage of the call captured as stereo by the acoustic echo canceller.
This column was introduced in Microsoft Lync Server 2013.