Skip to main content

vw_network_fabrics

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

Overview​

Namevw_network_fabrics
TypeView
Idazure.managed_network_fabric.vw_network_fabrics

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.annotation') as "annotation",
JSON_EXTRACT(properties, '$.networkFabricSku') as "network_fabric_sku",
JSON_EXTRACT(properties, '$.fabricVersion') as "fabric_version",
JSON_EXTRACT(properties, '$.routerIds') as "router_ids",
JSON_EXTRACT(properties, '$.networkFabricControllerId') as "network_fabric_controller_id",
JSON_EXTRACT(properties, '$.rackCount') as "rack_count",
JSON_EXTRACT(properties, '$.serverCountPerRack') as "server_count_per_rack",
JSON_EXTRACT(properties, '$.ipv4Prefix') as "ipv4_prefix",
JSON_EXTRACT(properties, '$.ipv6Prefix') as "ipv6_prefix",
JSON_EXTRACT(properties, '$.fabricASN') as "fabric_asn",
JSON_EXTRACT(properties, '$.terminalServerConfiguration') as "terminal_server_configuration",
JSON_EXTRACT(properties, '$.managementNetworkConfiguration') as "management_network_configuration",
JSON_EXTRACT(properties, '$.racks') as "racks",
JSON_EXTRACT(properties, '$.l2IsolationDomains') as "l2_isolation_domains",
JSON_EXTRACT(properties, '$.l3IsolationDomains') as "l3_isolation_domains",
JSON_EXTRACT(properties, '$.configurationState') as "configuration_state",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.administrativeState') as "administrative_state",
subscriptionId,
resourceGroupName,
networkFabricName
FROM azure.managed_network_fabric.network_fabrics
WHERE subscriptionId = 'replace-me';