turbot/aws_insights

Query: cloudtrail_trail_per_region

Usage

powerpipe query aws_insights.query.cloudtrail_trail_per_region

Steampipe Tables

SQL

select
region,
case
when is_multi_region_trail then 'Multi-Regional Trails'
else 'Regional Trails'
end as status,
count(*) as trails
from
aws_cloudtrail_trail
where
region = home_region
group by
region,
status;

Dashboards

The query is used in the dashboards: