turbot/azure_insights

Query: compute_virtual_machine_scale_set_by_subscription

Usage

powerpipe query azure_insights.query.compute_virtual_machine_scale_set_by_subscription

SQL

select
a.title as "Subscription",
count(vmss.*) as "Scale Sets"
from
azure_compute_virtual_machine_scale_set as vmss,
azure_subscription as a
where
a.subscription_id = vmss.subscription_id
group by
a.title
order by
a.title;

Dashboards

The query is used in the dashboards: