turbot/azure_insights

Query: compute_virtual_machine_scale_set_input

Usage

powerpipe query azure_insights.query.compute_virtual_machine_scale_set_input

SQL

select
v.title as label,
lower(v.id) as value,
json_build_object(
'subscription', s.display_name,
'resource_group', v.resource_group,
'region', v.region,
'unique_id', v.unique_id
) as tags
from
azure_compute_virtual_machine_scale_set as v,
azure_subscription as s
where
lower(v.subscription_id) = lower(s.subscription_id)
order by
v.title;