turbot/azure_insights

Query: compute_virtual_machine_scale_set_by_resource_group

Usage

powerpipe query azure_insights.query.compute_virtual_machine_scale_set_by_resource_group

SQL

select
resource_group || ' [' || sub.title || ']' as "Resource Group",
count(s.*) as "Scale Sets"
from
azure_compute_virtual_machine_scale_set as s,
azure_subscription as sub
where
s.subscription_id = sub.subscription_id
group by
resource_group,
sub.title
order by
resource_group;

Dashboards

The query is used in the dashboards: