turbot/aws_insights

Query: flow_logs_count_for_vpc

Usage

powerpipe query aws_insights.query.flow_logs_count_for_vpc

Steampipe Tables

SQL

select
'Flow Logs' as label,
count(*) as value,
case
when count(*) > 0 then 'ok'
else 'alert'
end as type
from
aws_vpc_flow_log
where
resource_id = reverse(split_part(reverse($1), '/', 1));

Dashboards

The query is used in the dashboards: