Users

Users in an organization.

View Specific Information

To query this view, Scope must include okta.users.read.

The driver 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 driver.

For example, the following query is processed server-side:

SELECT * FROM Users WHERE Id = '00uip08mzta1JvWRu5d7'


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