steampipe plugin install oci

Table: oci_dns_rrset - Query OCI DNS RRSet using SQL

A DNS Resource Record Set (RRSet) in Oracle Cloud Infrastructure (OCI) is a collection of DNS records with the same domain name, record type, and class. RRSet is used to group multiple DNS records together to provide redundancy and multiple routing paths, enhancing the performance and availability of your applications. With OCI's DNS service, you can manage RRSet to control the responses to DNS queries for your domain.

Table Usage Guide

The oci_dns_rrset table provides insights into DNS Resource Record Sets (RRSet) within Oracle Cloud Infrastructure (OCI) DNS service. As a network engineer, you can explore RRSet-specific details through this table, including record type, domain name, and associated metadata. Utilize it to uncover information about RRSet, such as those with multiple routing paths, the redundancy level of your DNS records, and the verification of DNS queries for your domain.

Examples

Basic info

Explore which domains within your DNS records are protected, along with their type, data, and time-to-live values. This can help you assess the security and configuration of your DNS records.

select
domain,
rtype,
r_data,
ttl,
is_protected
from
oci_dns_rrset;
select
domain,
rtype,
r_data,
ttl,
is_protected
from
oci_dns_rrset;

List DNS records which are not protected

Explore which DNS records are not protected to bolster your system's security by identifying potential vulnerabilities. This can aid in prioritizing and implementing necessary protective measures.

select
domain,
rtype,
is_protected
from
oci_dns_rrset
where
not is_protected;
select
domain,
rtype,
is_protected
from
oci_dns_rrset
where
not is_protected;

List name server DNS records

Discover the segments that use 'NS' (Name Server) DNS records within your domain. This allows you to gain insights into your DNS configuration and understand how your domain's DNS records are managed.

select
domain,
rtype
from
oci_dns_rrset
where
rtype = 'NS';
select
domain,
rtype
from
oci_dns_rrset
where
rtype = 'NS';

Schema for oci_dns_rrset

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
compartment_idtext=The OCID of the compartment in Tenant in which the resource is located.
domaintext=The fully qualified domain name where the record can be located.
is_protectedbooleanA Boolean flag indicating whether or not parts of the record are unable to be explicitly managed.
rdatatextThe record's data.
record_hashtextA unique identifier for the record within its zone.
rrset_versiontextThe latest version of the record's zone in which its RRSet differs from the preceding version.
rtypetext=The type of DNS record, such as A or CNAME.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The OCID of the Tenant in which the resource is located.
tenant_nametextThe name of the Tenant in which the resource is located.
titletextTitle of the resource.
ttltextThe Time To Live for the record, in seconds.

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

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

steampipe_export_oci --config '<your_config>' oci_dns_rrset