turbot/aws_insights

Query: cloudtrail_trail_per_account

Usage

powerpipe query aws_insights.query.cloudtrail_trail_per_account

Steampipe Tables

SQL

select
account_id,
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
account_id,
status;

Dashboards

The query is used in the dashboards: