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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
compartment_id	text	=	The OCID of the compartment in Tenant in which the resource is located.
domain	text	=	The fully qualified domain name where the record can be located.
is_protected	boolean		A Boolean flag indicating whether or not parts of the record are unable to be explicitly managed.
rdata	text		The record's data.
record_hash	text		A unique identifier for the record within its zone.
rrset_version	text		The latest version of the record's zone in which its RRSet differs from the preceding version.
rtype	text	=	The type of DNS record, such as A or CNAME.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tenant_id	text	=, !=, ~~, ~~, !~~, !~~	The OCID of the Tenant in which the resource is located.
tenant_name	text		The name of the Tenant in which the resource is located.
title	text		Title of the resource.
ttl	text		The 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