steampipe plugin install azure

Table: azure_dns_zone - Query Azure DNS Zones using SQL

Azure DNS is a hosting service for DNS domains, providing name resolution using Microsoft Azure infrastructure. By hosting domains in Azure, it provides you with the same reliability and performance provided to Microsoft’s global network. Azure DNS also supports private DNS domains.

Table Usage Guide

The azure_dns_zone table provides insights into DNS zones within Microsoft Azure. As a network administrator, explore DNS zone-specific details through this table, including record sets, number of record sets, and associated metadata. Utilize it to uncover information about DNS zones, such as those with certain properties, the relationships between different zones, and the verification of DNS settings.

Examples

Basic info

This query allows you to analyze the configuration of your Azure DNS zones. It helps you identify instances where specific tags are used, providing insights into the organization and management of your resources.

select
name,
resource_group,
tags
from
azure_dns_zone;
select
name,
resource_group,
tags
from
azure_dns_zone;

List public DNS zones with record sets

Explore which public DNS zones in your Azure environment contain more than one record set. This can help in managing and organizing your DNS records effectively.

select
name,
resource_group
from
azure_dns_zone
where
number_of_record_sets > 1;
select
name,
resource_group
from
azure_dns_zone
where
number_of_record_sets > 1;

List public DNS zones with delegated name servers

Determine the areas in which public DNS zones are utilizing delegated name servers, which can be beneficial for those seeking to manage or troubleshoot their DNS configurations.

select
name,
resource_group,
ns
from
azure_dns_zone,
jsonb_array_elements_text(name_servers) as ns
where
zone_type = 'Public'
and ns not like '%.azure-dns.%.';
select
name,
resource_group,
ns.value as ns
from
azure_dns_zone,
json_each(name_servers) as ns
where
zone_type = 'Public'
and ns.value not like '%.azure-dns.%.';

Schema for azure_dns_zone

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
etagtextAn unique read-only string that changes whenever the resource is updated.
idtextContains ID to identify a DNS zone uniquely.
max_number_of_record_setsbigintThe maximum number of record sets that can be created in this DNS zone.
max_number_of_records_per_record_setbigintThe maximum number of records per record set that can be created in this DNS zone.
nametext=The friendly name that identifies the DNS zone.
name_serversjsonbThe name servers for this DNS zone.
number_of_record_setsbigintThe current number of record sets in this DNS zone.
regiontextThe Azure region/location in which the resource is located.
registration_virtual_networksjsonbA list of references to virtual networks that register hostnames in this DNS zone.
resolution_virtual_networksjsonbA list of references to virtual networks that resolve records in this DNS zone.
resource_grouptext=The resource group which holds this resource.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe resource type of the DNS zone.
zone_typetextThe type of this DNS zone (always `Public`, see `azure_private_dns_zone` table for private DNS zones).

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

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

steampipe_export_azure --config '<your_config>' azure_dns_zone