steampipe plugin install godaddy

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
datatextRefers 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_nametext=The name of the domain.
nametext=The name of the record.
portbigintThe port for the dns record.
prioritybigintThe priority of the record. The valid values are MX and SRV only.
protocolbigintThe protocol being used for a particular type of DNS record.
servicebigintThe type of the service.
titletextTitle of the resource.
ttlbigintThe resource record cache time to live (TTL), in seconds.
typetext=The record type. Valid values are A, AAAA, CAA, CNAME, MX, NAPTR, NS, PTR, SOA, SPF, SRV and TXT.
weightbigintWeighted 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