Table: cloudflare_account - Query Cloudflare Accounts using SQL

Cloudflare is a web infrastructure and website security company that provides content delivery network services, DDoS mitigation, Internet security, and distributed domain name server services. Cloudflare's services sit between a website's visitor and the Cloudflare user's hosting provider, acting as a reverse proxy for websites. Its network protects, speeds up, and improves availability for a website or mobile application with a change in DNS.

Table Usage Guide

The cloudflare_account table provides insights into accounts within Cloudflare. As a DevOps engineer or a security analyst, explore account-specific details through this table, including account ID, name, email, and status. Utilize it to uncover information about accounts, such as those with specific status, the verification of email addresses, and the identification of account names.

Examples

Query all accounts the user has access to

Determine the range of accounts to which a user has access. This allows for a comprehensive overview of user permissions, aiding in account management and security audits.

select
  *
from
  cloudflare_account;

select
  *
from
  cloudflare_account;

Check if two factor authentication is enforced for accounts

Analyze the settings to understand whether two-factor authentication is being enforced for accounts, thereby enhancing security measures.

select
  name,
  settings -> 'enforce_twofactor' as enforce_mfa
from
  cloudflare_account;

select
  name,
  json_extract(settings, '$.enforce_twofactor') as enforce_mfa
from
  cloudflare_account;

Schema for cloudflare_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
id	text	=	ID of the account.
name	text		Name of the account.
settings	jsonb		Settings for the account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
type	text		Type of the account.
user_id	text	=, !=, ~~, ~~, !~~, !~~	ID of the current 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_account