JDBC Driver for Okta

Build 24.0.9062

UserFactors

Enrolled MFA factors for a user.

View Specific Information

Required Scopes

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

Select

The 本製品 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 本製品.

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.
Email String Email address of the user. Only in Email factors.
UserId String User Id

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062