steampipe plugin install ibm

Table: ibm_cis_domain - Query IBM Cloud Internet Services Domains using SQL

IBM Cloud Internet Services is a set of edge network services for applications hosted on IBM Cloud. It combines the power of IBM's global network with Cloudflare's edge computing solutions, providing a suite of robust network services including domains. These domains are part of the Cloud Internet Services offering and are used to manage and secure your applications.

Table Usage Guide

The ibm_cis_domain table provides insights into domains within IBM Cloud Internet Services. As a Network Administrator, explore domain-specific details through this table, including domain name, status, and associated metadata. Utilize it to uncover information about domains, such as their current status, the time they were created, and the time they were last modified.

Examples

Basic info

Explore which domains are active and their respective security levels by assessing their status and minimum TLS version. This is particularly useful for maintaining security standards and ensuring all domains are operating as expected.

select
name,
id,
status,
minimum_tls_version
from
ibm_cis_domain;
select
name,
id,
status,
minimum_tls_version
from
ibm_cis_domain;

List pending domains

Identify domains that are currently in a pending status to monitor and manage their progress effectively.

select
name,
id,
status,
minimum_tls_version
from
ibm_cis_domain
where
status = 'pending';
select
name,
id,
status,
minimum_tls_version
from
ibm_cis_domain
where
status = 'pending';

List domains where web_application_firewall not enabled

Identify domains where the web application firewall is not enabled. This is useful for enhancing security by pinpointing potential vulnerabilities in your network infrastructure.

select
name,
id,
status,
minimum_tls_version
from
ibm_cis_domain
where
web_application_firewall = 'off';
select
name,
id,
status,
minimum_tls_version
from
ibm_cis_domain
where
web_application_firewall = 'off';

Schema for ibm_cis_domain

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextAn unique ID of the account.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
created_ontimestamp with time zoneThe date and time that the zone was created.
dns_recordsjsonbDNS records for the domain.
global_load_balancerjsonbThe global load balancer of the zone.
idtext=The zone id.
minimum_tls_versiontextThe tls version of the zone.
modified_ontimestamp with time zoneThe date and time that the zone was updated.
nametextThe zone name.
name_serversjsonbThe name servers of the zone.
original_dnshosttextThe original DNS host of the zone.
original_name_serversjsonbThe original name servers of the zone.
original_registrartextThe original registrar of the zone.
pausedbooleanWhether the zone is in paused state.
statustextThe zone status.
titletextTitle of the resource.
web_application_firewalltextThe web application firewall state.

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

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

steampipe_export_ibm --config '<your_config>' ibm_cis_domain