turbot/azure_insights

Query: compute_snapshot_by_network_access_policy_status

Usage

powerpipe query azure_insights.query.compute_snapshot_by_network_access_policy_status

Steampipe Tables

SQL

select
status,
count(*)
from
(
select
network_access_policy,
case
when network_access_policy = 'AllowPrivate' then 'restricted'
when network_access_policy = 'AllowAll' then 'unrestricted'
else 'denied'
end as status
from
azure_compute_snapshot
) as cs
group by
status
order by
status;

Dashboards

The query is used in the dashboards: