turbot/azure_insights

Query: compute_snapshot_input

Usage

powerpipe query azure_insights.query.compute_snapshot_input

SQL

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