UserSessions
The sessions of the user.
View-Specific Information
SELECT
Reading data from this entity requires Read Sessions/authn:read:sessions permission.We recommend using the built-in Identity Data Admin role.
To execute SELECT statements on this entity, the UserId column must be specified in the criteria as shown in the examples below:
SELECT * FROM Administrators.UserSessions WHERE UserId = 'f45bb04b-d7ee-4f84-ab83-7fe3919405ae';
SELECT * FROM Administrators.UserSessions WHERE UserId IN ('f45bb04b-d7ee-4f84-ab83-7fe3919405ae', '4cbf5435-6c39-49f9-8c8f-cee7c1cd8a6b');
The 本製品 uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.
- UserId supports the following operators: =, IN.
All other filters are processed client-side within the 本製品.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The session identifier (UUID). | |
| UserAgent | String | The raw user agent string from the user agent header of the request that initiated the session. | |
| DeviceType | String | The type of remote device. | |
| Browser | String | The name of the browser. | |
| BrowserVersion | String | The version of the browser. | |
| OperatingSystem | String | The name of the operating system. | |
| OperatingSystemVersion | String | The operating system version. | |
| UserId | String | Users.Id | The identifier (UUID) of the user associated with the session. |
| CreatedAt | Datetime | The time at which the session was created. | |
| ActiveAt | Datetime | The time of last user activity for this session (such as, completing a flow, or an application activity like validating a token). | |
| IdleTimeout | Integer | The maximum idle time in minutes after which the session will become invalid. This is used to evaluate 'ExpiresAt', based on the 'ActiveAt' value. Sessions are automatically removed after the idle timeout. | |
| ExpiresAt | Datetime | The date and time the session will expire, based on the values for 'IdleTimeout' and 'ActiveAt'. | |
| LastSignOnAt | Datetime | The last time the user signed on using one or more authenticators. | |
| LastSignOnIP | String | The IP address of the device used during the last sign-on. | |
| LastSignOnAuthenticators | String | The authenticators used during the last sign-on. | |
| LastSignOnPolicyId | String | The identifier (UUID) of the sign-on policy associated with the last completed sign-on by the 'LastSignOnAuthenticators'. | |
| LastSignOnPolicyType | String | The type of the sign-on policy associated with the last completed sign-on by the 'LastSignOnAuthenticators'. Possible values are: 'DAVINCI' and 'PINGONE'. | |
| Locations | String | Contains the information identifying the location of the user session. Only the last 5 locations are maintained. This information is represented in JSON format (aggregate). |