Skip to main content

vw_origins

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

Overview​

Namevw_origins
TypeView
Idazure.cdn.vw_origins

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.hostName') as "host_name",
JSON_EXTRACT(properties, '$.httpPort') as "http_port",
JSON_EXTRACT(properties, '$.httpsPort') as "https_port",
JSON_EXTRACT(properties, '$.originHostHeader') as "origin_host_header",
JSON_EXTRACT(properties, '$.priority') as "priority",
JSON_EXTRACT(properties, '$.weight') as "weight",
JSON_EXTRACT(properties, '$.enabled') as "enabled",
JSON_EXTRACT(properties, '$.privateLinkAlias') as "private_link_alias",
JSON_EXTRACT(properties, '$.privateLinkResourceId') as "private_link_resource_id",
JSON_EXTRACT(properties, '$.privateLinkLocation') as "private_link_location",
JSON_EXTRACT(properties, '$.privateLinkApprovalMessage') as "private_link_approval_message",
JSON_EXTRACT(properties, '$.resourceState') as "resource_state",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.privateEndpointStatus') as "private_endpoint_status",
subscriptionId,
resourceGroupName,
profileName,
endpointName,
originName
FROM azure.cdn.origins
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me' AND endpointName = 'replace-me';