UserStatusReport
Query the User Status Report via the Explore API. Provides a raw log of agent status changes. Up to a month of data per request.
Select
The UserStatusReport is a report view. The driver processes the following pseudo-columns server-side; any other WHERE clause conditions are evaluated client-side.
- TimespanFrom supports the following operator: >=
- TimespanTo supports the following operator: <
- Timezone supports the following operator: =
If TimespanFrom and TimespanTo are omitted, the driver defaults the time range to the last 31 days.
For example, the following query is processed server-side:
SELECT * FROM UserStatusReport WHERE TimespanFrom >= '2025-01-01' AND TimespanTo < '2025-02-01'
Columns
| Name | Type | References | Description |
| UserId [KEY] | String |
Users.Id | The unique identifier of the user who underwent the status change. |
| StatusStartAt [KEY] | Datetime | The start date and time of the status session. | |
| UserName | String | The full name of the user. | |
| UserEmail | String | The email of the user. | |
| StatusLabel | String | The label assigned to the status. Example values: Away, On A Call, Available, Offline. | |
| StatusEndAt | Datetime | The end date and time of the status session. | |
| StatusTime | Int | The total duration in seconds spent in this status. | |
| IsUserActive | String | Whether the user is active in Talkdesk. | |
| TeamId | String |
Teams.Id | The team the agent was on when the status change occurred. Null if not on a team. |
| TeamName | String | The team name the agent was on when the status change occurred. Null if not on a team. | |
| RingGroups | String | The ring groups the agent belongs to. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TimespanFrom | Datetime | The start date for the report timespan. | |
| TimespanTo | Datetime | The end date for the report timespan. | |
| Timezone | String | The IANA timezone for the report timespan. |