turbot/aws_insights

Query: vpc_flow_logs_status

Usage

powerpipe query aws_insights.query.vpc_flow_logs_status

Steampipe Tables

SQL

with vpc_logs as (
select
vpc_id,
case
when vpc_id in (select resource_id from aws_vpc_flow_log) then 'enabled'
else 'disabled'
end as flow_logs_configured
from
aws_vpc
)
select
flow_logs_configured,
count(*)
from
vpc_logs
group by
flow_logs_configured;

Dashboards

The query is used in the dashboards: