Skip to main content

vw_web_pub_subs

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

Overview​

Namevw_web_pub_subs
TypeView
Idazure.web_pubsub.vw_web_pub_subs

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
sku as sku,
kind as kind,
identity as identity,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.externalIP') as "external_ip",
JSON_EXTRACT(properties, '$.hostName') as "host_name",
JSON_EXTRACT(properties, '$.publicPort') as "public_port",
JSON_EXTRACT(properties, '$.serverPort') as "server_port",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.sharedPrivateLinkResources') as "shared_private_link_resources",
JSON_EXTRACT(properties, '$.tls') as "tls",
JSON_EXTRACT(properties, '$.hostNamePrefix') as "host_name_prefix",
JSON_EXTRACT(properties, '$.liveTraceConfiguration') as "live_trace_configuration",
JSON_EXTRACT(properties, '$.resourceLogConfiguration') as "resource_log_configuration",
JSON_EXTRACT(properties, '$.networkACLs') as "network_ac_ls",
JSON_EXTRACT(properties, '$.applicationFirewall') as "application_firewall",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.disableLocalAuth') as "disable_local_auth",
JSON_EXTRACT(properties, '$.disableAadAuth') as "disable_aad_auth",
JSON_EXTRACT(properties, '$.regionEndpointEnabled') as "region_endpoint_enabled",
JSON_EXTRACT(properties, '$.resourceStopped') as "resource_stopped",
JSON_EXTRACT(properties, '$.socketIO') as "socket_io",
subscriptionId,
resourceGroupName,
resourceName
FROM azure.web_pubsub.web_pub_subs
WHERE subscriptionId = 'replace-me';