turbot/aws_insights

Query: cloudtrail_trail_bucket

Usage

powerpipe query aws_insights.query.cloudtrail_trail_bucket

SQL

select
s3_bucket_name as "S3 Bucket Name",
s.arn as "S3 Bucket ARN"
from
aws_cloudtrail_trail as t left join aws_s3_bucket as s on s.name = t.s3_bucket_name
where
t.region = home_region
and t.arn = $1;

Dashboards

The query is used in the dashboards: