GuardianSessionLogs
Query session login and logout logs via the Guardian API.
Select
The connector 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 connector.
| 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 connector pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the connector.
- 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). |