Users
Users in an organization.
View Specific Information
Required Scopes
To query this view, Scope must include okta.users.read.
Select
The add-in uses the Okta API to process WHERE clause conditions built with the following columns and operators.- Id supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
- Activated supports the '>', '>=', '=', '<=', and '<' operators
- Created supports the '>', '>=', '=', '<=', and '<' operators
- LastUpdated supports the '>', '>=', '=', '<=', and '<' operators
- ProfileEmail supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
- ProfileFirstName supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
- ProfileLastName supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
- ProfileLogin supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
- ProfileMobilePhone supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
- ProfileSecondEmail supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
- Status supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
- StatusChanged supports the '>', '>=', '=', '<=', and '<' operators
- TypeId supports the '>', '>=', '=', '<=', '<', and 'LIKE' operators
All other filters are processed client-side within the add-in.
For example, the following query is processed server-side:
SELECT * FROM Users WHERE Id = '00uip08mzta1JvWRu5d7'
Columns
Name | Type | Description |
Id [KEY] | String | Id of the user |
Activated | Datetime | When the user was activated |
Created | Datetime | When the user was created |
LastLogin | Datetime | When the user was last logged in |
LastUpdated | Datetime | When the user was last updated |
PasswordChanged | Datetime | When the user last changed their password |
ProfileEmail | String | Email of the profile |
ProfileFirstName | String | First name of the profile |
ProfileLastName | String | Last name of the profile |
ProfileLogin | String | Login of the profile |
ProfileMobilePhone | String | Mobile phone of the profile |
ProfileSecondEmail | String | Secondary email of the profile |
Status | String | Status of the user |
StatusChanged | Datetime | When the user's status was changed |
TypeId | String | Type id |