Skip to main content

vw_network_to_network_interconnects

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

Overview​

Namevw_network_to_network_interconnects
TypeView
Idazure.managed_network_fabric.vw_network_to_network_interconnects

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.nniType') as "nni_type",
JSON_EXTRACT(properties, '$.isManagementType') as "is_management_type",
JSON_EXTRACT(properties, '$.useOptionB') as "use_optionb",
JSON_EXTRACT(properties, '$.layer2Configuration') as "layer2_configuration",
JSON_EXTRACT(properties, '$.optionBLayer3Configuration') as "option_b_layer3_configuration",
JSON_EXTRACT(properties, '$.npbStaticRouteConfiguration') as "npb_static_route_configuration",
JSON_EXTRACT(properties, '$.importRoutePolicy') as "import_route_policy",
JSON_EXTRACT(properties, '$.exportRoutePolicy') as "export_route_policy",
JSON_EXTRACT(properties, '$.egressAclId') as "egress_acl_id",
JSON_EXTRACT(properties, '$.ingressAclId') as "ingress_acl_id",
JSON_EXTRACT(properties, '$.configurationState') as "configuration_state",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.administrativeState') as "administrative_state",
subscriptionId,
resourceGroupName,
networkFabricName,
networkToNetworkInterconnectName
FROM azure.managed_network_fabric.network_to_network_interconnects
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND networkFabricName = 'replace-me';