Skip to main content

vw_communications_gateways

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

Overview​

Namevw_communications_gateways
TypeView
Idazure.voice_services.vw_communications_gateways

Fields​

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

SQL Definition​

SELECT
location as location,
identity as identity,
sku as sku,
tags as tags,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.serviceLocations') as "service_locations",
JSON_EXTRACT(properties, '$.connectivity') as "connectivity",
JSON_EXTRACT(properties, '$.codecs') as "codecs",
JSON_EXTRACT(properties, '$.e911Type') as "e911_type",
JSON_EXTRACT(properties, '$.platforms') as "platforms",
JSON_EXTRACT(properties, '$.apiBridge') as "api_bridge",
JSON_EXTRACT(properties, '$.autoGeneratedDomainNameLabelScope') as "auto_generated_domain_name_label_scope",
JSON_EXTRACT(properties, '$.autoGeneratedDomainNameLabel') as "auto_generated_domain_name_label",
JSON_EXTRACT(properties, '$.teamsVoicemailPilotNumber') as "teams_voicemail_pilot_number",
JSON_EXTRACT(properties, '$.onPremMcpEnabled') as "on_prem_mcp_enabled",
JSON_EXTRACT(properties, '$.integratedMcpEnabled') as "integrated_mcp_enabled",
JSON_EXTRACT(properties, '$.emergencyDialStrings') as "emergency_dial_strings",
JSON_EXTRACT(properties, '$.dnsDelegations') as "dns_delegations",
JSON_EXTRACT(properties, '$.customSipHeaders') as "custom_sip_headers",
JSON_EXTRACT(properties, '$.allocatedSignalingAddressPrefixes') as "allocated_signaling_address_prefixes",
JSON_EXTRACT(properties, '$.allocatedMediaAddressPrefixes') as "allocated_media_address_prefixes",
subscriptionId,
resourceGroupName,
communicationsGatewayName
FROM azure.voice_services.communications_gateways
WHERE subscriptionId = 'replace-me';