turbot/azure_insights

Query: network_express_route_circuit_by_subscription

Usage

powerpipe query azure_insights.query.network_express_route_circuit_by_subscription

SQL

select
sub.title as "Subscription",
count(n.*) as "Express Route Circuits"
from
azure_express_route_circuit as n,
azure_subscription as sub
where
sub.subscription_id = n.subscription_id
group by
sub.title
order by
sub.title;

Dashboards

The query is used in the dashboards: