Skip to main content

vw_express_route_circuits

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

Overview​

Namevw_express_route_circuits
TypeView
Idazure.network.vw_express_route_circuits

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
sku as sku,
etag as etag,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.allowClassicOperations') as "allow_classic_operations",
JSON_EXTRACT(properties, '$.circuitProvisioningState') as "circuit_provisioning_state",
JSON_EXTRACT(properties, '$.serviceProviderProvisioningState') as "service_provider_provisioning_state",
JSON_EXTRACT(properties, '$.authorizations') as "authorizations",
JSON_EXTRACT(properties, '$.peerings') as "peerings",
JSON_EXTRACT(properties, '$.serviceKey') as "service_key",
JSON_EXTRACT(properties, '$.serviceProviderNotes') as "service_provider_notes",
JSON_EXTRACT(properties, '$.serviceProviderProperties') as "service_provider_properties",
JSON_EXTRACT(properties, '$.expressRoutePort') as "express_route_port",
JSON_EXTRACT(properties, '$.bandwidthInGbps') as "bandwidth_in_gbps",
JSON_EXTRACT(properties, '$.stag') as "stag",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.gatewayManagerEtag') as "gateway_manager_etag",
JSON_EXTRACT(properties, '$.globalReachEnabled') as "global_reach_enabled",
JSON_EXTRACT(properties, '$.authorizationKey') as "authorization_key",
JSON_EXTRACT(properties, '$.authorizationStatus') as "authorization_status",
JSON_EXTRACT(properties, '$.enableDirectPortRateLimit') as "enable_direct_port_rate_limit",
subscriptionId,
resourceGroupName,
circuitName
FROM azure.network.express_route_circuits
WHERE subscriptionId = 'replace-me';