Skip to main content

vw_internal_networks

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

Overview​

Namevw_internal_networks
TypeView
Idazure.managed_network_fabric.vw_internal_networks

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.annotation') as "annotation",
JSON_EXTRACT(properties, '$.mtu') as "mtu",
JSON_EXTRACT(properties, '$.connectedIPv4Subnets') as "connected_ipv4_subnets",
JSON_EXTRACT(properties, '$.connectedIPv6Subnets') as "connected_ipv6_subnets",
JSON_EXTRACT(properties, '$.importRoutePolicyId') as "import_route_policy_id",
JSON_EXTRACT(properties, '$.exportRoutePolicyId') as "export_route_policy_id",
JSON_EXTRACT(properties, '$.importRoutePolicy') as "import_route_policy",
JSON_EXTRACT(properties, '$.exportRoutePolicy') as "export_route_policy",
JSON_EXTRACT(properties, '$.ingressAclId') as "ingress_acl_id",
JSON_EXTRACT(properties, '$.egressAclId') as "egress_acl_id",
JSON_EXTRACT(properties, '$.isMonitoringEnabled') as "is_monitoring_enabled",
JSON_EXTRACT(properties, '$.extension') as "extension",
JSON_EXTRACT(properties, '$.vlanId') as "vlan_id",
JSON_EXTRACT(properties, '$.bgpConfiguration') as "bgp_configuration",
JSON_EXTRACT(properties, '$.staticRouteConfiguration') as "static_route_configuration",
JSON_EXTRACT(properties, '$.configurationState') as "configuration_state",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.administrativeState') as "administrative_state",
subscriptionId,
resourceGroupName,
l3IsolationDomainName,
internalNetworkName
FROM azure.managed_network_fabric.internal_networks
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND l3IsolationDomainName = 'replace-me';