GuardianCallsQuality
Query call quality metrics from the previous 30 days via the Guardian API.
Select
The add-in uses the Talkdesk API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.
| Column | Supported Operators |
| CallId | =, IN, IS, IS_NOT |
| UserId | =, IN, IS, IS_NOT |
| InteractionId | =, IN, IS, IS_NOT |
| Timestamp | =, IS, IS_NOT |
| AffectedCall | =, IN, IS, IS_NOT |
| PacketsLossPercentage | all standard comparison operators |
For example, the following query is processed server-side:
SELECT * FROM GuardianCallsQuality WHERE CallId = 'value'
The add-in pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the add-in.
- Timestamp supports the following sort directions: ASC, DESC.
For example, the following query is sorted server-side:
SELECT * FROM GuardianCallsQuality ORDER BY Timestamp ASC
Columns
| Name | Type | References | Description |
| CallId [KEY] | String | The unique identifier of the call. | |
| UserId | String |
Users.Id | The identifier of the user. |
| InteractionId | String |
CallsReport.InteractionId | The unique identifier of the interaction. |
| Timestamp | Datetime | The timestamp of the call. | |
| AffectedCall | Boolean | Whether the call was affected by quality issues. | |
| PacketsLossPercentage | Double | The percentage of packets lost during the call. | |
| JitterAvg | Double | The average jitter during the call. | |
| JitterMax | Double | The maximum jitter during the call. | |
| MosAvg | Double | The average Mean Opinion Score (MOS) during the call. | |
| MosMax | Double | The maximum Mean Opinion Score (MOS) during the call. | |
| MosMin | Double | The minimum Mean Opinion Score (MOS) during the call. | |
| RttAvg | Double | The average round-trip time (RTT) in ms. | |
| RttMax | Double | The maximum round-trip time (RTT) in ms. | |
| RttMin | Double | The minimum round-trip time (RTT) in ms. |