Table: godaddy_dns_record - Query GoDaddy DNS Records using SQL

GoDaddy DNS Records are a critical part of the GoDaddy domain hosting service. They allow users to control the domain's email settings, website location, and other important aspects of their internet presence. By managing DNS records, users can direct web traffic to their desired location, configure email routing, and ensure secure and reliable operation of their domain.

Table Usage Guide

The godaddy_dns_record table provides insights into DNS records within GoDaddy's domain hosting service. As a network administrator or website owner, explore specific details through this table, including record type, name, and data. Utilize it to manage and monitor your DNS records, ensuring your domain's web traffic and email routing are correctly configured and operating as intended.

Important Notes

To filter the resource using name, you must set type in the where clause.

Examples

Basic info

Explore which domain names are associated with your GoDaddy DNS records. This query can help you gain insights into your DNS configuration, including the protocol and type of each record, which could be beneficial for managing and troubleshooting your network.

select
  name,
  domain_name,
  data,
  protocol,
  type,
  ttl
from
  godaddy_dns_record;

select
  name,
  domain_name,
  data,
  protocol,
  type,
  ttl
from
  godaddy_dns_record;

List all DNS records for a specific domain name

Explore all DNS records associated with a specific domain name. This can be useful for understanding and managing the various services and protocols tied to your domain.

select
  name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  domain_name = 'example.com';

select
  name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  domain_name = 'example.com';

List all DNS records of a specific type for a specific domain name

Determine the specific DNS records associated with a particular domain name. This query can be used to gain insights into the configuration and settings of a domain, which can be beneficial for troubleshooting or optimization purposes.

select
  name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  domain_name = 'example.com'
  and type = 'A';

select
  name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  domain_name = 'example.com'
  and type = 'A';

List all DNS records with a TTL less than or equal to a certain value

Explore DNS records that have a time-to-live (TTL) value of 3600 seconds or less. This can be useful for identifying domains that may require frequent updates or are more susceptible to potential caching issues.

select
  name,
  domain_name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  ttl <= '3600';

select
  name,
  domain_name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  ttl <= 3600;

List all DNS records with a specific data value

Explore DNS records that are associated with a specific IP address. This is useful for identifying potential anomalies or inconsistencies in your DNS configuration.

select
  name,
  domain_name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  data = '192.168.1.1';

select
  name,
  domain_name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  data = '192.168.1.1';

List all DNS records with a specific priority value

Determine the areas in which DNS records have been assigned a specific priority value. This is useful for assessing the configuration of your domain names and ensuring that the most important records have the correct priority level.

select
  name,
  domain_name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  priority = '10';

select
  name,
  domain_name,
  data,
  protocol,
  type,
  service,
  ttl
from
  godaddy_dns_record
where
  priority = '10';

Schema for godaddy_dns_record

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
data	text		Refers to the value of the DNS record being added or updated. The value of this field will depend on the type of DNS record being added or updated.
domain_name	text	=	The name of the domain.
name	text	=	The name of the record.
port	bigint		The port for the dns record.
priority	bigint		The priority of the record. The valid values are MX and SRV only.
protocol	bigint		The protocol being used for a particular type of DNS record.
service	bigint		The type of the service.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.
ttl	bigint		The resource record cache time to live (TTL), in seconds.
type	text	=	The record type. Valid values are A, AAAA, CAA, CNAME, MX, NAPTR, NS, PTR, SOA, SPF, SRV and TXT.
weight	bigint		Weighted resource record sets only: Among resource record sets that have the same combination of DNS name and type, a value that determines the proportion of DNS queries that Amazon Route 53 responds to using the current resource record set. Route 53 calculates the sum of the weights for the resource record sets that have the same combination of DNS name and type. Route 53 then responds to queries based on the ratio of a resource's weight to the total.

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

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

steampipe_export_godaddy --config '<your_config>' godaddy_dns_record