vw_afd_custom_domains
Creates, updates, deletes, gets or lists a vw_afd_custom_domains
resource.
Overview
Name | vw_afd_custom_domains |
Type | View |
Id | azure.cdn.vw_afd_custom_domains |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
JSON_EXTRACT(properties, '$.profileName') as "profile_name",
JSON_EXTRACT(properties, '$.tlsSettings') as "tls_settings",
JSON_EXTRACT(properties, '$.azureDnsZone') as "azure_dns_zone",
JSON_EXTRACT(properties, '$.preValidatedCustomDomainResourceId') as "pre_validated_custom_domain_resource_id",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.deploymentStatus') as "deployment_status",
JSON_EXTRACT(properties, '$.domainValidationState') as "domain_validation_state",
JSON_EXTRACT(properties, '$.hostName') as "host_name",
JSON_EXTRACT(properties, '$.extendedProperties') as "extended_properties",
JSON_EXTRACT(properties, '$.validationProperties') as "validation_properties",
subscriptionId,
resourceGroupName,
profileName,
customDomainName
FROM azure.cdn.afd_custom_domains
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me';
SELECT
json_extract_path_text(properties, '$.profileName') as "profile_name",
json_extract_path_text(properties, '$.tlsSettings') as "tls_settings",
json_extract_path_text(properties, '$.azureDnsZone') as "azure_dns_zone",
json_extract_path_text(properties, '$.preValidatedCustomDomainResourceId') as "pre_validated_custom_domain_resource_id",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.deploymentStatus') as "deployment_status",
json_extract_path_text(properties, '$.domainValidationState') as "domain_validation_state",
json_extract_path_text(properties, '$.hostName') as "host_name",
json_extract_path_text(properties, '$.extendedProperties') as "extended_properties",
json_extract_path_text(properties, '$.validationProperties') as "validation_properties",
subscriptionId,
resourceGroupName,
profileName,
customDomainName
FROM azure.cdn.afd_custom_domains
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me';