Skip to main content

vw_static_sites

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

Overview​

Namevw_static_sites
TypeView
Idazure.app_service.vw_static_sites

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,
systemData as system_data,
sku as sku,
identity as identity,
JSON_EXTRACT(properties, '$.defaultHostname') as "default_hostname",
JSON_EXTRACT(properties, '$.repositoryUrl') as "repository_url",
JSON_EXTRACT(properties, '$.branch') as "branch",
JSON_EXTRACT(properties, '$.customDomains') as "custom_domains",
JSON_EXTRACT(properties, '$.repositoryToken') as "repository_token",
JSON_EXTRACT(properties, '$.buildProperties') as "build_properties",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.stagingEnvironmentPolicy') as "staging_environment_policy",
JSON_EXTRACT(properties, '$.allowConfigFileUpdates') as "allow_config_file_updates",
JSON_EXTRACT(properties, '$.templateProperties') as "template_properties",
JSON_EXTRACT(properties, '$.contentDistributionEndpoint') as "content_distribution_endpoint",
JSON_EXTRACT(properties, '$.keyVaultReferenceIdentity') as "key_vault_reference_identity",
JSON_EXTRACT(properties, '$.userProvidedFunctionApps') as "user_provided_function_apps",
JSON_EXTRACT(properties, '$.linkedBackends') as "linked_backends",
JSON_EXTRACT(properties, '$.provider') as "provider",
JSON_EXTRACT(properties, '$.enterpriseGradeCdnStatus') as "enterprise_grade_cdn_status",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.databaseConnections') as "database_connections",
subscriptionId,
resourceGroupName,
name
FROM azure.app_service.static_sites
WHERE subscriptionId = 'replace-me';