AudioSignal table

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.
RenderLoopbackSignalLevel
int
Level in dBFS of the signal sent to the loudspeaker for playback. Accounts for any gain adjustments made to the received signal.
This column was introduced in Microsoft Lync Server 2013.
RenderNoiseLevel
int
Level in dBFS of the noise content in the signal sent to the loudspeaker for playback