turbot/steampipe-mod-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: