Table: azure_private_dns_zone - Query Azure Private DNS Zones using SQL

Azure Private DNS Zone is a service within Microsoft Azure that allows you to use your own domain name, rather than the Azure-provided names. It provides a simple, reliable, secure DNS service to manage and resolve domain names in a Virtual Network without the need for custom DNS solutions. Azure Private DNS Zones helps you to customize domain names for Azure services, manage DNS records, and improve network security.

Table Usage Guide

The azure_private_dns_zone table provides insights into Azure Private DNS Zones within Azure DNS. As a network administrator, explore zone-specific details through this table, including properties, records, and associated metadata. Utilize it to uncover information about zones, such as their status, the number of records, and their associated virtual networks.

Examples

Basic info

Explore which private DNS zones are present in your Azure environment and determine the associated resource groups and tags for better resource management and categorization.

select
  name,
  resource_group,
  tags
from
  azure_private_dns_zone;

select
  name,
  resource_group,
  tags
from
  azure_private_dns_zone;

List private DNS zones with record sets

Identify private DNS zones in Azure that have more than one record set. This is useful for managing and organizing DNS resources efficiently.

select
  name,
  resource_group
from
  azure_private_dns_zone
where
  number_of_record_sets > 1;

select
  name,
  resource_group
from
  azure_private_dns_zone
where
  number_of_record_sets > 1;

List private DNS zones linked to no virtual networks

Explore which private DNS zones in Azure are not linked to any virtual networks. This can be useful in identifying potential areas of network optimization or redundancy elimination.

select
  name,
  resource_group
from
  azure_private_dns_zone
where
  number_of_virtual_network_links_with_registration = 0;

select
  name,
  resource_group
from
  azure_private_dns_zone
where
  number_of_virtual_network_links_with_registration = 0;

Schema for azure_private_dns_zone

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
etag	text		An unique read-only string that changes whenever the resource is updated.
id	text		Contains ID to identify a Private DNS zone uniquely.
max_number_of_record_sets	bigint		The maximum number of record sets that can be created in this Private DNS zone.
max_number_of_virtual_network_links	bigint		The maximum number of virtual networks that can be linked to this Private DNS zone.
max_number_of_virtual_network_links_with_registration	bigint		The maximum number of virtual networks that can be linked to this Private DNS zone with registration enabled.
name	text	=	The friendly name that identifies the Private DNS zone.
number_of_record_sets	bigint		The current number of record sets in this Private DNS zone.
number_of_virtual_network_links	bigint		The current number of virtual networks that are linked to this Private DNS zone.
number_of_virtual_network_links_with_registration	bigint		The current number of virtual networks that are linked to this Private DNS zone with registration enabled.
provisioning_state	text		The provisioning state of the resource. Possible values include: `Creating`, `Updating`, `Deleting`, `Succeeded`, `Failed`, `Canceled`.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The resource type of the Private DNS zone.

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_private_dns_zone