Skip to main content

vw_virtual_network_gateways

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

Overview​

Namevw_virtual_network_gateways
TypeView
Idazure.network.vw_virtual_network_gateways

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
extendedLocation as extended_location,
etag as etag,
identity as identity,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.autoScaleConfiguration') as "auto_scale_configuration",
JSON_EXTRACT(properties, '$.ipConfigurations') as "ip_configurations",
JSON_EXTRACT(properties, '$.gatewayType') as "gateway_type",
JSON_EXTRACT(properties, '$.vpnType') as "vpn_type",
JSON_EXTRACT(properties, '$.vpnGatewayGeneration') as "vpn_gateway_generation",
JSON_EXTRACT(properties, '$.enableBgp') as "enable_bgp",
JSON_EXTRACT(properties, '$.enablePrivateIpAddress') as "enable_private_ip_address",
JSON_EXTRACT(properties, '$.activeActive') as "active_active",
JSON_EXTRACT(properties, '$.disableIPSecReplayProtection') as "disable_ip_sec_replay_protection",
JSON_EXTRACT(properties, '$.gatewayDefaultSite') as "gateway_default_site",
JSON_EXTRACT(properties, '$.sku') as "sku",
JSON_EXTRACT(properties, '$.vpnClientConfiguration') as "vpn_client_configuration",
JSON_EXTRACT(properties, '$.virtualNetworkGatewayPolicyGroups') as "virtual_network_gateway_policy_groups",
JSON_EXTRACT(properties, '$.bgpSettings') as "bgp_settings",
JSON_EXTRACT(properties, '$.customRoutes') as "custom_routes",
JSON_EXTRACT(properties, '$.resourceGuid') as "resource_guid",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.enableDnsForwarding') as "enable_dns_forwarding",
JSON_EXTRACT(properties, '$.inboundDnsForwardingEndpoint') as "inbound_dns_forwarding_endpoint",
JSON_EXTRACT(properties, '$.vNetExtendedLocationResourceId') as "vnet_extended_location_resource_id",
JSON_EXTRACT(properties, '$.natRules') as "nat_rules",
JSON_EXTRACT(properties, '$.enableBgpRouteTranslationForNat') as "enable_bgp_route_translation_for_nat",
JSON_EXTRACT(properties, '$.allowVirtualWanTraffic') as "allow_virtual_wan_traffic",
JSON_EXTRACT(properties, '$.allowRemoteVnetTraffic') as "allow_remote_vnet_traffic",
JSON_EXTRACT(properties, '$.adminState') as "admin_state",
JSON_EXTRACT(properties, '$.resiliencyModel') as "resiliency_model",
subscriptionId,
resourceGroupName,
virtualNetworkGatewayName
FROM azure.network.virtual_network_gateways
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me';