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 entered 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 isn't 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 isn't 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 are 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 poor, either 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. |