turbot/azure_insights

Query: storage_account_network_access_status

Usage

powerpipe query azure_insights.query.storage_account_network_access_status

Steampipe Tables

SQL

select
network_rule,
count(*)
from
(
select
case
when network_rule_default_action = 'Deny' then 'restricted'
else 'unrestricted'
end network_rule
from
azure_storage_account
) as cd
group by
network_rule
order by
network_rule;

Dashboards

The query is used in the dashboards: