Topic Last Modified: 2013-11-12

Each record represents audio signal metrics for one endpoint. Usually, each call has two records, one is for caller, and one is for callee.

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.

FromCaller

bit

Primary

0: Callee’s data

1: Caller’s data

SendSignalLevel

int

 

Represents the Post-Analog Gain Control audio signal level. The unit for this metric is dBmo. For acceptable quality, it should be at least 30 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.

RecvSignalLevel

int

 

See SendSignalLevel.

SendNoiseLevel

int

 

Represents the Post-Analog Gain Control audio noise level. The unit for this metric is dBmo. For acceptable quality, it should be less than 35 dBmo. This metric is not reported by the A/V Conferencing Server or IP phones.

RecvNoiseLevel

int

 

See SendNoiseLevel.

EchoReturn

int

 

Echo Return Loss Enhancement metric. The unit for this metric is dB. Lower values represent less echo. This metric is not reported by the A/V Conferencing Server or IP phones.

AudioSpeakerGlitchRate

int

 

Average glitches per five minutes for the loudspeaker rendering. For good quality, this should be less than one per five minutes. Not reported by A/V Conferencing Servers, Mediation Servers, or IP phones.

AudioMicGlitchRate

int

 

Average glitches per five minutes for the microphone capture. For good quality this should be less than one per five minutes. Not reported by A/V Conferencing Servers, Mediation Servers, or IP phones.

AudioTimestampDriftRateMic

decimal(9,2)

 

Microphone device clock drift rate, relative to CPU clock.

AudioTimestampDriftRateSpk

decimal(9,2)

 

Speaker device clock drift rate, relative to CPU clock.

AudioTimestampErrorMicMs

decimal(9,2)

 

Speaker device clock drift rate, relative to CPU clock.

Average microphone capture stream time stamp error, in milliseconds, in the last 20 seconds of the call.

AudioTimestampErrorSpkMs

decimal(9,2)

 

Average speaker render stream time stamp error, in milliseconds, in the last 20 seconds of the call.

VsEntryCauses

smallint

 

Voice switch is a half-duplex mode with reduced interruption ability. Causes of voice switch entry:

ENTER_VS_BADTS 0x01

ENTER_VS_ECHO 0x02

ENTER_VS_FORCEORCONVERGENCE 0x04

ENTER_VS_DNLP 0x08

The cause can be a combination of those individual causes. ENTER_VS_FORCEORCONVERGENCE can only be enabled by regkey for test purpose.

The data type for this column was changed in Microsoft Lync Server 2013.

EchoEventCauses

tinyint

 

Causes of an echo event:

ECHO_EVENT_BAD_TIMESTAMP 0x01

ECHO_EVENT_POSTAEC_ECHO 0x02

ECHO_EVENT_ANLP 0x04

ECHO_EVENT_DNLP 0x08

ECHO_EVENT_MIC_CLIPPING 0x10

ECHO_EVENT_BAD_STATE 0x20

The cause can be a combination of those individual causes.

EchoPercentMicIn

decimal(5,2)

 

Percentage of time when echo was detected in the microphone capture stream. Typically, values are low for headsets or handsets, and higher for speaker phones or stand-alone speakers. For devices that support on-board acoustic echo cancellation, high values indicate echo leak. For other devices, this metric should not be used to evaluate device quality.

EchoPercentSend

decimal(5,2)

Percentage of time when echo is detected in sent stream. High echo percentage in send streams an indication of echo leak.

RxAGCSignalLevel

int

 

Received signal level on the Mediation Server from the Gateway; this applies only to the Mediation Server. The unit of this metric is dBoV. For good quality, the acceptable range should be [-30 to -18] dBoV.

RxAGCNoiseLevel

int

 

Received signal level on the Mediation Server from the Gateway. This applies only to the Mediation Server. The unit of this metric is dBoV. For good quality, the acceptable range should be less than -50 dBoV.

RxAvgAGCGain

int

 

Automatic gain control (AGC) on the Mediation Server side.

InitialSignalLevelRMS

float

 

The root mean square (RMS) of the incoming signal of up to the first 30 seconds of the call.

RecvSignalLevelCh1

int

Signal level as received on channel 1.

This column was introduced in Microsoft Lync Server 2013.

RecvSignalLevelCh2

int

Signal level as received on channel 2.

This column was introduced in Microsoft Lync Server 2013.

RecvNoiseLevelCh1

int

Noise level as received on channel 1.

This column was introduced in Microsoft Lync Server 2013.

RecvNoiseLevelCh2

int

Noise level as received on channel 2.

This column was introduced in Microsoft Lync Server 2013.

SendSignalLevelCh1

int

Signal level as sent on channel 1.

This column was introduced in Microsoft Lync Server 2013.

SendSignalLevelCh2

int

Signal level as sent on channel 2.

This column was introduced in Microsoft Lync Server 2013.

SendNoiseLevelCh1

int

Noise level as sent on channel 1.

This column was introduced in Microsoft Lync Server 2013.

SendNoiseLevelCh2

int

Noise level as sent on channel 2.

This column was introduced in Microsoft Lync Server 2013.