Table: alicloud_alidns_domain - Query Alibaba Cloud DNS Domains using SQL

Alibaba Cloud DNS (Alidns) is a scalable and high-performance Domain Name System (DNS) service provided by Alibaba Cloud. Alidns allows users to manage and configure DNS records for their domains, ensuring faster and more reliable domain resolution.

Table Usage Guide

The alicloud_alidns_domain table provides insights into DNS domains managed within Alibaba Cloud DNS (Alidns). As a network administrator or DevOps engineer, you can explore domain-specific details through this table, including DNS records, TTL values, registrant details, and the DNS servers associated with the domains. Utilize it to manage and monitor domain configurations, detect misconfigurations, and ensure optimal domain performance.

Examples

Basic info

Retrieve basic information about all Alidns domains, including their names, IDs, and creation times. This helps in inventory management and tracking.

select
  domain_name,
  domain_id,
  create_time,
  registrant_email
from
  alicloud_alidns_domain;

select
  domain_name,
  domain_id,
  create_time,
  registrant_email
from
  alicloud_alidns_domain;

List expired domain instances

Identify expired domain instances to ensure timely renewals and avoid service disruptions.

select
  domain_name,
  domain_id,
  instance_expired,
  instance_end_time
from
  alicloud_alidns_domain
where
  instance_expired;

select
  domain_name,
  domain_id,
  instance_expired,
  instance_end_time
from
  alicloud_alidns_domain
where
  instance_expired = 1;

List star-marked domains

Explore domains marked as "star domains" for prioritization or special handling.

select
  domain_name,
  domain_id,
  starmark
from
  alicloud_alidns_domain
where
  starmark;

select
  domain_name,
  domain_id,
  starmark
from
  alicloud_alidns_domain
where
  starmark = 1;

List DNS servers for a domain

Retrieve the DNS servers associated with a specific domain to verify the configuration.

select
  domain_name,
  dns_servers
from
  alicloud_alidns_domain
where
  domain_name = 'example.com';

select
  domain_name,
  dns_servers
from
  alicloud_alidns_domain
where
  domain_name = 'example.com';

List domains with high record counts

Identify domains with a high number of DNS records for optimization and management.

select
  domain_name,
  record_count
from
  alicloud_alidns_domain
where
  record_count > 100;

select
  domain_name,
  record_count
from
  alicloud_alidns_domain
where
  record_count > 100;

Domains by resource group

Group domains by their resource group IDs to analyze resource allocation and usage.

select
  resource_group_id,
  count(*) as domain_count
from
  alicloud_alidns_domain
group by
  resource_group_id;

select
  resource_group_id,
  count(*) as domain_count
from
  alicloud_alidns_domain
group by
  resource_group_id;

Domains with remarks

Retrieve all domains that have remarks for additional metadata or notes.

select
  domain_name,
  remark
from
  alicloud_alidns_domain
where
  remark is not null;

select
  domain_name,
  remark
from
  alicloud_alidns_domain
where
  remark is not null;

Schema for alicloud_alidns_domain

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The Alicloud Account ID in which the resource is located.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
ali_domain	boolean		Indicates whether the domain is registered with Alibaba Cloud.
available_ttls	jsonb		The list of available TTL (Time-To-Live) values for DNS records in the domain.
create_time	timestamp with time zone		The creation time of the domain.
create_timestamp	timestamp with time zone		The timestamp when the domain was created.
dns_servers	jsonb		The DNS servers associated with the domain.
domain_id	text		The unique identifier of the domain.
domain_name	text	=	The name of the domain.
group_id	text	=	The ID of the group the domain belongs to.
group_name	text		The name of the group the domain belongs to.
in_clean	boolean		Indicates whether the domain is in a cleaning state.
instance_end_time	text		The end time of the instance associated with the domain.
instance_expired	boolean		Indicates whether the instance associated with the domain has expired.
instance_id	text		The instance ID of the domain.
line_type	text		The type of DNS record line, indicating the routing rules for the domain.
min_ttl	bigint		The minimum TTL (Time-To-Live) value for DNS records in the domain.
puny_code	text		The Punycode representation of the domain name.
record_count	bigint		The number of DNS records associated with the domain.
record_lines	jsonb		The DNS record lines associated with the domain.
region	text		The Alicloud region in which the resource is located.
registrant_email	text		The email address of the domain registrant.
remark	text		Remarks for the domain.
resource_group_id	text		The resource group ID of the domain.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
starmark	boolean		Indicates whether the domain is marked as a star domain.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		A list of tags attached with the resource.
title	text		Title of the resource.
version_code	text		The code of the domain version.
version_name	text		The name of the domain version.

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

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

steampipe_export_alicloud --config '<your_config>' alicloud_alidns_domain