Skip to main content

vw_record_sets

Creates, updates, deletes, gets or lists a vw_record_sets resource.

Overview​

Namevw_record_sets
TypeView
Idazure.dns.vw_record_sets

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
id as id,
name as name,
type as type,
etag as etag,
JSON_EXTRACT(properties, '$.metadata') as "metadata",
JSON_EXTRACT(properties, '$.TTL') as "ttl",
JSON_EXTRACT(properties, '$.fqdn') as "fqdn",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.targetResource') as "target_resource",
JSON_EXTRACT(properties, '$.trafficManagementProfile') as "traffic_management_profile",
JSON_EXTRACT(properties, '$.ARecords') as "a_records",
JSON_EXTRACT(properties, '$.AAAARecords') as "aaaa_records",
JSON_EXTRACT(properties, '$.MXRecords') as "mx_records",
JSON_EXTRACT(properties, '$.NSRecords') as "ns_records",
JSON_EXTRACT(properties, '$.PTRRecords') as "ptr_records",
JSON_EXTRACT(properties, '$.SRVRecords') as "srv_records",
JSON_EXTRACT(properties, '$.TXTRecords') as "txt_records",
JSON_EXTRACT(properties, '$.CNAMERecord') as "cname_record",
JSON_EXTRACT(properties, '$.SOARecord') as "soa_record",
JSON_EXTRACT(properties, '$.caaRecords') as "caa_records",
JSON_EXTRACT(properties, '$.DSRecords') as "ds_records",
JSON_EXTRACT(properties, '$.TLSARecords') as "tlsa_records",
JSON_EXTRACT(properties, '$.NAPTRRecords') as "naptr_records",
subscriptionId,
resourceGroupName,
zoneName,
recordType,
relativeRecordSetName
FROM azure.dns.record_sets
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND zoneName = 'replace-me';