Table: cloudflare_user - Query Cloudflare Users using SQL

Cloudflare is a global cloud network platform that offers various services to secure and enhance the performance of websites, applications, and other internet properties. It provides a range of services from content delivery network (CDN), website security, DDoS protection, to DNS services. A User in Cloudflare represents an individual with access to the Cloudflare dashboard and API.

Table Usage Guide

The cloudflare_user table provides insights into User data within Cloudflare. As a Security Analyst, explore user-specific details through this table, including account details, email, status, and two-factor authentication details. Utilize it to uncover information about users, such as those with two-factor authentication enabled or disabled, and the verification of user status.

Examples

Query information about the user

Discover the details of your user profile on Cloudflare to better understand account status and settings. This can be useful for auditing purposes or for troubleshooting account-related issues.

select
  *
from
  cloudflare_user;

select
  *
from
  cloudflare_user;

Check if two factor authentication is enabled for the user

Explore whether two-factor authentication is activated for users, enhancing account security and reducing the risk of unauthorized access.

select
  id,
  email,
  two_factor_authentication_enabled
from
  cloudflare_user;

select
  id,
  email,
  two_factor_authentication_enabled
from
  cloudflare_user;

Schema for cloudflare_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
api_key	text		API Key for the user.
betas	jsonb		Beta feature flags associated with the user.
country	text		Country of the user.
created_on	timestamp with time zone		When the user was created.
email	text		Email of the user.
first_name	text		First name of the user.
id	text		ID of the user.
last_name	text		Last name of the user.
modified_on	timestamp with time zone		When the user was last modified.
organizations	jsonb		Organizations the user is a member of.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
telephone	text		Telephone number of the user.
two_factor_authentication_enabled	boolean		True if two factor authentication is enabled for this user.
user_id	text	=, !=, ~~, ~~, !~~, !~~	ID of the current user.
username	text		Username (actually often in ID style) of the user.
zipcode	text		Zipcode of the user.

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)" -- cloudflare

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

steampipe_export_cloudflare --config '<your_config>' cloudflare_user