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	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
telephone	text	Telephone number of the user.
two_factor_authentication_enabled	boolean	True if two factor authentication is enabled for this 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