GuardianSessionLogs
Query session login and logout logs 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 |
| Id | =, IN, IS, IS_NOT, NOT_IN |
| UserId | =, IN, IS, IS_NOT, NOT_IN |
| LoginTimestamp | =, IS, IS_NOT |
| LogoutTimestamp | =, IS, IS_NOT |
| BrowserFull | =, IN, IS, IS_NOT, LIKE, CONTAINS |
| OsFull | =, IN, IS, IS_NOT, LIKE, CONTAINS |
| Country | =, IN, IS, IS_NOT, LIKE, CONTAINS |
| Sso | =, IN, IS, IS_NOT, LIKE, CONTAINS |
For example, the following query is processed server-side:
SELECT * FROM GuardianSessionLogs WHERE Id = '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.
- UserId supports the following sort directions: ASC, DESC.
- LoginTimestamp supports the following sort directions: ASC, DESC.
- LogoutTimestamp supports the following sort directions: ASC, DESC.
For example, the following query is sorted server-side:
SELECT * FROM GuardianSessionLogs ORDER BY UserId ASC
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the session log. | |
| UserId | String |
Users.Id | The unique identifier of the user. |
| LoginTimestamp | Datetime | The timestamp when the user logged in. | |
| LogoutTimestamp | Datetime | The timestamp when the user logged out. | |
| BrowserFull | String | The browser name and version. | |
| OsFull | String | The operating system name and version. | |
| Country | String | The country of the login session. | |
| IpAddress | String | The IP address of the login session. | |
| Latitude | Double | The geographic latitude of the login location. | |
| Longitude | Double | The geographic longitude of the login location. | |
| Sso | String | The SSO provider used for login (e.g. google). |