Table: linode_domain_record - Query Linode Domain Records using SQL

A Linode Domain Record represents a DNS record associated with a domain. These records define how internet traffic is directed for a domain. They can be created, updated, or deleted through the Linode API.

Table Usage Guide

The linode_domain_record table provides insights into Domain Records within Linode. As a Network Administrator, explore record-specific details through this table, including record type, name, and associated data. Utilize it to uncover information about records, such as those associated with a specific domain, the record's target, and the priority of MX records.

Important Notes

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

Examples

List all records for all domains

Explore the relationships between different domains and their associated records. This can help you understand the various connections and dependencies within your network infrastructure, providing valuable insights for management and troubleshooting purposes.

select
  d.domain,
  dr.record_type,
  dr.name,
  dr.target
from
  linode_domain as d,
  linode_domain_record as dr
where
  dr.domain_id = d.id;

select
  d.domain,
  dr.record_type,
  dr.name,
  dr.target
from
  linode_domain as d,
  linode_domain_record as dr
where
  dr.domain_id = d.id;

List all domain records for a domain

Explore all the domain records associated with a specific domain ID to understand its configuration and settings. This can be useful in managing and troubleshooting domain-related issues.

select
  *
from
  linode_domain_record
where
  domain_id = 1234;

select
  *
from
  linode_domain_record
where
  domain_id = 1234;

Schema for linode_domain_record

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
domain_id	bigint	=	The ID of the Domain for the record.
filter	text	=	Raw Linode list filter string in JSON format.
id	bigint	=	This Record’s unique ID.
name	text		The name of this Record. This property’s actual usage and whether it is required depends on the type of record it represents. For example, for CNAME, it is the hostname.
port	bigint		The port this Record points to. Only valid and required for SRV record requests.
priority	bigint		The priority of the target host for this Record. Lower values are preferred. Only valid for MX and SRV record requests. Required for SRV record requests.
protocol	text		The protocol this Record’s service communicates with. An underscore (_) is prepended automatically to the submitted value for this property. Only valid for SRV record requests.
record_type	text		The type of Record this is in the DNS system: A, AAAA, NS, MX, CNAME, TXT, SRV, PTR, CAA.
service	text		The name of the service. Only valid and required for SRV record requests.
tag	text		The tag portion of a CAA record. Only valid and required for CAA record requests.
target	text		The target for this Record. For requests, this property’s actual usage and whether it is required depends on the type of record this represents. For example, for CNAME it is the domain target.
ttl_sec	bigint		Time to Live - the amount of time in seconds that the domain record may be cached by resolvers or other domain servers.
weight	bigint		The relative weight of this Record used in the case of identical priority. Higher values are preferred. Only valid and required for SRV record requests.

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

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

steampipe_export_linode --config '<your_config>' linode_domain_record