Table: namecheap_domain_host - Query Namecheap Domain Hosts using SQL
Namecheap Domain Hosts is a resource within the Namecheap domain registration and management service that allows users to manage and configure host records for their domains. These host records, also known as DNS records, are essential for directing internet traffic to the correct servers and services associated with a domain. As such, they play a crucial role in domain name resolution, website hosting, email delivery, and other domain-related functions.
Table Usage Guide
The namecheap_domain_host
table provides insights into the DNS host records configured for domains within the Namecheap service. As a system administrator or DevOps engineer, explore host record-specific details through this table, including the associated domain, record type, address, and TTL (Time to Live) values. Utilize it to monitor and manage DNS configurations, ensure proper domain name resolution, and maintain the overall health and performance of your domains.
Examples
List domain host records
Discover the segments that contain specific details of a domain's host records, such as its name and address. This can be useful in managing and organizing your domains, particularly in identifying which domains have specific host settings.
select domain, name, type, address, ttl, mx_preffrom namecheap_domain_hostorder by domain, name;
select domain, name, type, address, ttl, mx_preffrom namecheap_domain_hostorder by domain, name;
List host records for a given domain
Explore the host records associated with a particular domain to gain insights into its configuration and settings. This can be especially useful for managing and troubleshooting domain-related issues.
select domain, name, type, address, ttl, mx_preffrom namecheap_domain_hostwhere domain = 'steampipe.io';
select domain, name, type, address, ttl, mx_preffrom namecheap_domain_hostwhere domain = 'steampipe.io';
List CNAME records
Explore which domain names are associated with specific addresses, useful for identifying potential redirections or aliases. This can provide insights into your domain hosting configuration for better management and security.
select domain, name, address, ttlfrom namecheap_domain_hostwhere type = 'CNAME';
select domain, name, address, ttlfrom namecheap_domain_hostwhere type = 'CNAME';
Schema for namecheap_domain_host
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
address | text | Target address for the host, e.g. steampipe.io., 1.2.3.4 | |
domain | text | = | Name of the domain, e.g. steampipe.io. |
email_type | text | Email type for the domain. | |
friendly_name | text | Friendly name of the host, e.g. MX2. | |
host_id | bigint | Unique ID of the host record at Namecheap, e.g. 1234. | |
is_active | boolean | True if the record is active. | |
is_ddns_enabled | boolean | True if dynamic DNS is enabled. | |
is_using_our_dns | boolean | True if the domain is using Namecheap DNS. | |
mx_pref | bigint | MX priority of the host. | |
name | text | Name of the host, e.g. www or @ for the root domain. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
ttl | bigint | TTL of the record. | |
type | text | Type of the host, e.g. CNAME. | |
username | text | =, !=, ~~, ~~*, !~~, !~~* | The name of the user. |
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)" -- namecheap
You can pass the configuration to the command with the --config
argument:
steampipe_export_namecheap --config '<your_config>' namecheap_domain_host