Table: net_dns_reverse - Query DNS Reverse Zones using SQL

DNS service is a scalable, reliable, and managed Domain Name System (DNS) solution. It enables developers and businesses to route end users to internet applications by translating human-readable domain names (like www.example.com) into numeric IP addresses (like 192.0.2.1) that computers use to connect to each other. A Reverse DNS (rDNS) is the determination of a domain name associated with an IP address via querying DNS.

Table Usage Guide

The net_dns_reverse table provides insights into Reverse DNS Zones within Oracle Cloud Infrastructure's DNS service. As a network administrator, explore reverse DNS lookup details through this table, including IP address mapping and associated metadata. Utilize it to uncover information about IP addresses, such as their associated domain names, aiding in network troubleshooting and security investigations.

Important Notes

You must specify the ip_address column in the where clause to query this table.

Examples

Find host names for an IP address

Discover the host names associated with a specific IP address to better understand network connections and potential security risks.

select
  *
from
  net_dns_reverse
where
  ip_address = '1.1.1.1';

select
  *
from
  net_dns_reverse
where
  ip_address = '1.1.1.1';

Schema for net_dns_reverse

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
domains	jsonb		Domain names associated with the IP address.
ip_address	inet	=	IP address to lookup.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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

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

steampipe_export_net --config '<your_config>' net_dns_reverse