turbot/aws_insights

Query: vpc_no_flow_logs_count

Usage

powerpipe query aws_insights.query.vpc_no_flow_logs_count

Steampipe Tables

SQL

select
count(*) filter(where vpc_id not in (select resource_id from aws_vpc_flow_log)) as value,
'Flow Logs Disabled' as label,
case count(*) filter(where vpc_id not in (select resource_id from aws_vpc_flow_log))
when 0 then 'ok'
else 'alert'
end as type
from
aws_vpc;

Dashboards

The query is used in the dashboards: