turbot/azure_insights

Query: network_express_route_circuit_service_provider_properties

Usage

powerpipe query azure_insights.query.network_express_route_circuit_service_provider_properties

SQL

select
service_provider_properties ->> 'serviceProviderName' as "Name",
service_provider_properties ->> 'bandwidthInMbps' as "Bandwidth In Mbps",
service_provider_properties ->> 'peeringLocation' as "Peering Location"
from
azure_express_route_circuit
where
lower(id) = $1;

Dashboards

The query is used in the dashboards: