turbot/cloudflare

steampipe plugin install cloudflaresteampipe plugin install cloudflare

Table: cloudflare_zone

Zone is the basic resource for working with Cloudflare and is roughly equivalent to a domain name that the user purchases.

Examples

Query all zones for the user

select
*
from
cloudflare_zone

List all settings for the zone

select
name,
setting.key,
setting.value
from
cloudflare_zone,
jsonb_each_text(settings) as setting

Get details of the TLS 1.3 setting

select
name,
settings ->> 'tls_1_3'
from
cloudflare_zone

List all permissions available to the user for this zone

select
name,
perm
from
cloudflare_zone,
jsonb_array_elements_text(permissions) as perm

Check DNSSEC status for zones

select
name,
dnssec ->> 'status'
from
cloudflare_zone

.inspect cloudflare_zone

A Zone is a domain name along with its subdomains and other identities.

NameTypeDescription
betasjsonbBeta feature flags associated with the zone.
created_ontimestamp without time zoneWhen the zone was created.
deactivation_reasontextTODO
development_modebigintThe interval (in seconds) from when development mode expires (positive integer) or last expired (negative integer) for the domain. If development mode has never been enabled, this value is 0.
hostjsonbTODO
idtextZone identifier tag.
metajsonbMetadata associated witht the zone.
modified_ontimestamp without time zoneWhen the zone was last modified.
nametextThe domain name.
name_serversjsonbCloudflare-assigned name servers. This is only populated for zones that use Cloudflare DNS.
original_dnshosttextDNS host at the time of switching to Cloudflare.
original_name_serversjsonbOriginal name servers before moving to Cloudflare.
original_registrartextRegistrar for the domain at the time of switching to Cloudflare.
ownerjsonbInformation about the user or organization that owns the zone.
pausedbooleanIndicates if the zone is only using Cloudflare DNS services. A true value means the zone will not receive security or performance benefits.
permissionsjsonbAvailable permissions on the zone for the current user requesting the item.
planjsonbCurrent plan associated with the zone.
plan_pendingjsonbPending plan change associated with the zone.
statustextStatus of the zone.
typetextA full zone implies that DNS is hosted with Cloudflare. A partial zone is typically a partner-hosted zone or a CNAME setup.
vanity_name_serversjsonbCustom name servers for the zone.