Table: linode_domain - Query Linode Domains using SQL

Linode Domains is a service within Linode that allows you to manage and configure domain and subdomain records for your websites. It provides a centralized way to set up and manage DNS records for various Linode resources, including virtual machines, databases, web applications, and more. Linode Domains helps you stay informed about the health and performance of your DNS configurations and take appropriate actions when predefined conditions are met.

Table Usage Guide

The linode_domain table provides insights into Domains within Linode. As a DevOps engineer, explore domain-specific details through this table, including domain and subdomain records, TTL values, and associated metadata. Utilize it to uncover information about domains, such as those with misconfigured DNS records, the relationships between domains and subdomains, and the verification of TTL values.

Examples

List all domains

Explore all the domains available in your Linode account. This can help in managing and organizing your resources effectively.

select
  *
from
  linode_domain;

select
  *
from
  linode_domain;

Domains with a given tag

Discover the segments that are tagged with a specific label, enabling you to organize and manage your resources more effectively. This is particularly useful when you need to perform actions on a group of resources that share a common tag.

select
  domain,
  tags
from
  linode_volume
where
  tags ? 'foo'

Error: SQLite does not support '?' operator for checking the existence of a key in a JSON object.

Schema for linode_domain

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
axfr_ips	jsonb		The list of IPs that may perform a zone transfer for this Domain. This is potentially dangerous, and should be set to an empty list unless you intend to use it.
description	text		A description for this Domain. This is for display purposes only.
domain	text	=	The domain this Domain represents. These must be unique in our system; you cannot have two Domains representing the same domain.
domain_type	text		If this Domain represents the authoritative source of information for the domain it describes, or if it is a read-only copy of a master (also called a slave).
expire_sec	bigint		The amount of time in seconds that may pass before this Domain is no longer authoritative.
filter	text	=	Raw Linode list filter string in JSON format.
id	bigint	=	The unique ID of this Domain.
master_ips	jsonb		The IP addresses representing the master DNS for this Domain.
refresh_sec	bigint		The amount of time in seconds before this Domain should be refreshed.
retry_sec	bigint		The interval, in seconds, at which a failed refresh should be retried.
soa_email	text		Start of Authority email address. This is required for master Domains.
status	text		Used to control whether this Domain is currently being rendered: disabled, active, edit_mode, has_errors.
tags	jsonb		Tags applied to this domain as a map.
tags_src	jsonb		List of Tags applied to this domain.
ttl_sec	bigint		Time to Live - the amount of time in seconds that this Domain's records may be cached by resolvers or other domain servers.

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