AudioClientEvent table

Each record contains a client event for one endpoint in an audio call. Usually, one call has two records, one for caller and one 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
NetworkSendQualityEventRatio
decimal(5,2)

Percentage of session the NetworkSendQuality event was fired for 'Bad' state.
Network quality in terms of jitter or packet loss is severe and impacting the quality of audio being sent.
NetworkReceiveQualityEventRatio
decimal(5,2)

Percentage of session the ReceiveSendQuality event was fired for 'Bad' state.
Network quality in terms of jitter or packet loss is severe and impacting the quality of audio being received.
NetworkDelayEventRatio
decimal(5,2)

Percentage of session the Delay event was fired for 'Bad' state. Network latency is severe and impacting the experience by preventing interactive communication
NetworkBandwidthLowEventRatio
decimal(5,2)

Percentage of session the LowBandwidth event was fired for 'Bad' state. The available bandwidth is insufficient for an acceptable voice experience.
CPUInsufficientEventRatio
decimal(5,2)

Percentage of session the insufficient CPU event was fired for 'Bad' state. There are insufficient CPU cycles for processing with the current modalities and applications in use. This causes distortions with the audio channel.
DeviceHalfDuplexAECEventRatio
decimal(5,2)

Percentage of session the DeviceHalfDuplexAEC event was fired for 'Bad' state. In order to prevent echo, the system has enter half duplex.
DeviceRenderNotFunctioningEventRatio
decimal(5,2)

Percentage of session the DeviceRenderNotFunctioning event was fired for 'Bad' state. The render device currently being used for the session is not functioning correctly. This can cause one-way audio issues.
DeviceCaptureNotFunctioningEventRatio
decimal(5,2)

Percentage of session the DeviceCaptureNotFunctioning event was fired for 'Bad' state. The capture device currently being used for the session is not functioning correctly. This can cause one-way audio issues.
DeviceGlitchesEventRatio
decimal(5,2)

Percentage of session the DeviceGlitches event was fired for 'Bad' state. There are severe glitches in the rendering of audio which is causing distortions. These glitches can be caused by driver issues, deferred procedure calls (DPC) storm (drivers), and high CPU usage.
DeviceLowSNREventRatio
decimal(5,2)

Percentage of session the DeviceLowSNR event was fired for 'Bad' state. The capture quality is very poor, either very noisy or user is talking too far away from the microphone. This will cause distortions.
DeviceLowSpeechLevelEventRatio
decimal(5,2)

Percentage of session the DeviceLowSpeechLevel event was fired for 'Bad' state. User's speech level is too low and the system cannot increase it any further. This can either cause distortions or perceived as one-way audio.
DeviceClippingEventRatio
Decimal(5,2)

Percentage of session the DeviceClipping event was fired for 'Bad' state.
When near-end speech clips the microphone, far-end hears distortion due to clipping. It is important to avoid near-end microphone clipping.
DeviceEchoEventRatio
decimal(5,2)

Percentage of session the DeviceEchoEvent event was fired for 'Bad' state. Device or setup is causing echo beyond the ability of the system to compensate.
DeviceNearEndToEchoRatioEventRatio
decimal(5,2)

Percentage of session the DeviceNearEndToEchoRatio event was fired for 'Bad' state. The user's speech is too low compared to the echo being captured which impacts the users experience because it limits how easy it is to interrupt a user. Reduce speaker volume, move the microphone closer to the talker.
DeviceMultipleEndpointsEventCount
int
Number of times during session the DeviceMultipleEndpoints event was fired for 'Bad' state. Multiple audio endpoints in the same session detected and the system has compensated by reducing render volume.
DeviceHowlingEventCount
int

Number of times during session the DeviceHowlingEvent event was fired for 'Bad' state. Audio feedback loop detected (caused by multiple endpoints sharing audio path).
DeviceRenderZeroVolumeEventRatio
decimal(5,2)
Percentage of session the DeviceRenderZeroVolume event was fired for being in the "Bad' state. The render device was set to zero volume.
This column was introduced in Microsoft Lync Server 2013.
DeviceRenderMuteEventRatio
decimal(5,2)
Percentage of session the DeviceRenderMute event was fired for being in the "Bad' state. The render device was muted.
This column was introduced in Microsoft Lync Server 2013.