Skip to main content

vw_endpoints

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

Overview​

Namevw_endpoints
TypeView
Idazure.cdn.vw_endpoints

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.originPath') as "origin_path",
JSON_EXTRACT(properties, '$.contentTypesToCompress') as "content_types_to_compress",
JSON_EXTRACT(properties, '$.originHostHeader') as "origin_host_header",
JSON_EXTRACT(properties, '$.isCompressionEnabled') as "is_compression_enabled",
JSON_EXTRACT(properties, '$.isHttpAllowed') as "is_http_allowed",
JSON_EXTRACT(properties, '$.isHttpsAllowed') as "is_https_allowed",
JSON_EXTRACT(properties, '$.queryStringCachingBehavior') as "query_string_caching_behavior",
JSON_EXTRACT(properties, '$.optimizationType') as "optimization_type",
JSON_EXTRACT(properties, '$.probePath') as "probe_path",
JSON_EXTRACT(properties, '$.geoFilters') as "geo_filters",
JSON_EXTRACT(properties, '$.defaultOriginGroup') as "default_origin_group",
JSON_EXTRACT(properties, '$.urlSigningKeys') as "url_signing_keys",
JSON_EXTRACT(properties, '$.deliveryPolicy') as "delivery_policy",
JSON_EXTRACT(properties, '$.webApplicationFirewallPolicyLink') as "web_application_firewall_policy_link",
JSON_EXTRACT(properties, '$.hostName') as "host_name",
JSON_EXTRACT(properties, '$.origins') as "origins",
JSON_EXTRACT(properties, '$.originGroups') as "origin_groups",
JSON_EXTRACT(properties, '$.customDomains') as "custom_domains",
JSON_EXTRACT(properties, '$.resourceState') as "resource_state",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
profileName,
endpointName
FROM azure.cdn.endpoints
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me';