Sessions
Returns active user sessions, including session authentication and last activity details.
Table-Specific Information
Select
The provider uses the Zendesk API to process WHERE clause conditions built with the following columns and operators:- Id supports the = operator.
- UserId supports the = operator.
For example, the following queries are processed server-side while other filters are processed client-side within the provider.
SELECT * FROM Sessions WHERE UserId = '123'
SELECT * FROM Sessions WHERE UserId = '19326991711516' AND Id = '6184815149518'
Delete
You must specify the UserId and Id of the session to delete it.
DELETE FROM Sessions WHERE UserId = '123' AND Id = '456'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
Automatically assigned when the session is created. | |
| UserId | Long | True |
Users.Id |
The Id of the user associated with the session. |
| AuthenticatedAt | Datetime | True |
The date and time when the session was authenticated. | |
| LastSeenAt | Datetime | True |
The approximate date and time when the session was last active. This value does not update on every request. | |
| Url | String | True |
The API URL of this session. |