vw_network_fabric_controllers
Creates, updates, deletes, gets or lists a vw_network_fabric_controllers resource.
Overview
| Name | vw_network_fabric_controllers |
| Type | View |
| Id | azure.managed_network_fabric.vw_network_fabric_controllers |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.annotation') as "annotation",
JSON_EXTRACT(properties, '$.infrastructureExpressRouteConnections') as "infrastructure_express_route_connections",
JSON_EXTRACT(properties, '$.workloadExpressRouteConnections') as "workload_express_route_connections",
JSON_EXTRACT(properties, '$.infrastructureServices') as "infrastructure_services",
JSON_EXTRACT(properties, '$.workloadServices') as "workload_services",
JSON_EXTRACT(properties, '$.managedResourceGroupConfiguration') as "managed_resource_group_configuration",
JSON_EXTRACT(properties, '$.networkFabricIds') as "network_fabric_ids",
JSON_EXTRACT(properties, '$.workloadManagementNetwork') as "workload_management_network",
JSON_EXTRACT(properties, '$.isWorkloadManagementNetworkEnabled') as "is_workload_management_network_enabled",
JSON_EXTRACT(properties, '$.tenantInternetGatewayIds') as "tenant_internet_gateway_ids",
JSON_EXTRACT(properties, '$.ipv4AddressSpace') as "ipv4_address_space",
JSON_EXTRACT(properties, '$.ipv6AddressSpace') as "ipv6_address_space",
JSON_EXTRACT(properties, '$.nfcSku') as "nfc_sku",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
networkFabricControllerName
FROM azure.managed_network_fabric.network_fabric_controllers
WHERE subscriptionId = 'replace-me';
SELECT
location as location,
tags as tags,
json_extract_path_text(properties, '$.annotation') as "annotation",
json_extract_path_text(properties, '$.infrastructureExpressRouteConnections') as "infrastructure_express_route_connections",
json_extract_path_text(properties, '$.workloadExpressRouteConnections') as "workload_express_route_connections",
json_extract_path_text(properties, '$.infrastructureServices') as "infrastructure_services",
json_extract_path_text(properties, '$.workloadServices') as "workload_services",
json_extract_path_text(properties, '$.managedResourceGroupConfiguration') as "managed_resource_group_configuration",
json_extract_path_text(properties, '$.networkFabricIds') as "network_fabric_ids",
json_extract_path_text(properties, '$.workloadManagementNetwork') as "workload_management_network",
json_extract_path_text(properties, '$.isWorkloadManagementNetworkEnabled') as "is_workload_management_network_enabled",
json_extract_path_text(properties, '$.tenantInternetGatewayIds') as "tenant_internet_gateway_ids",
json_extract_path_text(properties, '$.ipv4AddressSpace') as "ipv4_address_space",
json_extract_path_text(properties, '$.ipv6AddressSpace') as "ipv6_address_space",
json_extract_path_text(properties, '$.nfcSku') as "nfc_sku",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
networkFabricControllerName
FROM azure.managed_network_fabric.network_fabric_controllers
WHERE subscriptionId = 'replace-me';