turbot/aws_insights

Query: vpc_flow_log_destination

Usage

powerpipe query aws_insights.query.vpc_flow_log_destination

Steampipe Tables

SQL

select
log_destination_type as "Log Destination Type",
case when log_destination like 'arn:aws:s3%' then log_destination else 'NA' end as "Bucket",
case
when log_destination like '%:log-group:%' then log_destination
When log_group_name is not null then log_group_name
else 'NA' end as "Log Group"
from
aws_vpc_flow_log
where
flow_log_id = $1

Dashboards

The query is used in the dashboards: