turbot/azure_insights

Query: network_security_group_flow_logs_status

Usage

powerpipe query azure_insights.query.network_security_group_flow_logs_status

SQL

select
status,
count(*)
from
(
select
case
when (flow_logs is null) then 'disabled'
else 'enabled'
end status
from
azure_network_security_group
) as n
group by
status
order by
status;

Dashboards

The query is used in the dashboards: