vw_dnssec_configs

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

Overview

Name	vw_dnssec_configs
Type	View
Id	azure.dns.vw_dnssec_configs

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
etag as etag,
systemData as system_data,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.signingKeys') as "signing_keys",
subscriptionId,
resourceGroupName,
zoneName
FROM azure.dns.dnssec_configs
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND zoneName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
etag as etag,
systemData as system_data,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.signingKeys') as "signing_keys",
subscriptionId,
resourceGroupName,
zoneName
FROM azure.dns.dnssec_configs
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND zoneName = 'replace-me';