Table: okta_factor - Query Okta Factors using SQL

Okta Factors are the different methods of authentication used by Okta users. These can range from password-based authentication to more advanced methods like biometric authentication. Understanding these factors is crucial for maintaining the security and integrity of an Okta environment.

Table Usage Guide

The okta_factor table provides insights into the authentication methods used within Okta. As a security engineer, explore factor-specific details through this table, including the type of factor, status, and associated metadata. Utilize it to uncover information about factors, such as those that are less secure, the distribution of factor types among users, and potential vulnerabilities in authentication methods.

Examples

Basic info

Explore which security factors have been created for each user and their current status. This can be useful to understand the security measures in place for each user and if they are active or not.

select
  id,
  user_id,
  factor_type,
  created,
  status
from
  okta_factor;

select
  id,
  user_id,
  factor_type,
  created,
  status
from
  okta_factor;

List factors pending activation

Explore which security factors are awaiting activation, enabling you to take necessary actions to ensure user accounts are secure and fully functional. This helps in maintaining the security standards and smooth operation of your system.

select
  id,
  user_id,
  factor_type,
  created,
  status
from
  okta_factor
where
  status = 'PENDING_ACTIVATION';

select
  id,
  user_id,
  factor_type,
  created,
  status
from
  okta_factor
where
  status = 'PENDING_ACTIVATION';

List factors provided by Okta

Explore which factors are provided by Okta to gain insights into the status and creation dates of these factors. This can be useful in managing user security settings and assessing the elements within your Okta environment.

select
  id,
  user_id,
  factor_type,
  created,
  provider,
  status
from
  okta_factor
where
  provider = 'OKTA';

select
  id,
  user_id,
  factor_type,
  created,
  provider,
  status
from
  okta_factor
where
  provider = 'OKTA';

Get factor by factor ID and user ID

Determine the security factor settings associated with a specific user, which can be useful in understanding the user's security setup and status. This can be particularly helpful in troubleshooting or auditing security compliance.

select
  id,
  user_id,
  factor_type,
  created,
  status
from
  okta_factor
where
  id = 'ost1l5cklwIRvLzUY5d7'
  and user_id = '00u1kcigdvWtR96HY5d7';

select
  id,
  user_id,
  factor_type,
  created,
  status
from
  okta_factor
where
  id = 'ost1l5cklwIRvLzUY5d7'
  and user_id = '00u1kcigdvWtR96HY5d7';

Schema for okta_factor

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created	timestamp with time zone		Timestamp when Group was created.
domain	text	=, !=, ~~, ~~, !~~, !~~	The okta domain name.
embedded	jsonb		The Group's Profile properties.
factor_type	text		Description of the Group.
id	text	=	Unique key for Group.
last_updated	timestamp with time zone		The timestamp when the factor was last updated.
profile	jsonb		Specific attributes related to the Factor.
provider	text		The provider for the factor.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The current status of the factor.
title	text		The title of the resource.
user_id	text	=	Unique key for Group.
user_name	text		Unique identifier for the user (username).
verify	jsonb		List of all users that are a member of this Group.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- okta

You can pass the configuration to the command with the --config argument:

steampipe_export_okta --config '<your_config>' okta_factor