steampipe plugin install azure

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

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 Private DNS zone uniquely.
max_number_of_record_setsbigintThe maximum number of record sets that can be created in this Private DNS zone.
max_number_of_virtual_network_linksbigintThe maximum number of virtual networks that can be linked to this Private DNS zone.
max_number_of_virtual_network_links_with_registrationbigintThe maximum number of virtual networks that can be linked to this Private DNS zone with registration enabled.
nametext=The friendly name that identifies the Private DNS zone.
number_of_record_setsbigintThe current number of record sets in this Private DNS zone.
number_of_virtual_network_linksbigintThe current number of virtual networks that are linked to this Private DNS zone.
number_of_virtual_network_links_with_registrationbigintThe current number of virtual networks that are linked to this Private DNS zone with registration enabled.
provisioning_statetextThe provisioning state of the resource. Possible values include: `Creating`, `Updating`, `Deleting`, `Succeeded`, `Failed`, `Canceled`.
regiontextThe Azure region/location in which the resource is located.
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 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