UserFactors
Enrolled MFA factors for a user.
View Specific Information
Required Scopes
To query this view, Scope must include okta.users.read.
Select
The driver uses the Okta API to process WHERE clause conditions built with the following columns and operators.- Id supports the '=' operator
- UserId supports the '=' operator
All other filters are processed client-side within the driver.
For example, the following query is processed server-side:
SELECT * FROM UserFactors WHERE UserId='00ub0oNGTSWTBKOLGLNR'
Columns
Name | Type | Description |
Id [KEY] | String | Id of the factor |
FactorType | String | Type of factor |
Provider | String | Factor provider |
VendorName | String | Factor vendor name |
Status | String | Status of the factor |
Created | Datetime | When the item was created |
LastUpdated | Datetime | When the item was last updated |
Answer | String | Answer to the question. Only in Question factors. |
Question | String | Unique key for the question. Only in Question factors. |
QuestionText | String | Display text for the question. Only in Question factors. |
PhoneNumber | String | Phone number for the device. Only in Call and SMS factors. |
PhoneExtension | String | Extension of the device. Only in Call factors. |
CredentialId | String | Credential Id. Only in Web and Token factors. |
String | Email address of the user. Only in Email factors. | |
UserId | String | User Id |