turbot/aws_insights

Query: cloudtrail_trail_logging_status

Usage

powerpipe query aws_insights.query.cloudtrail_trail_logging_status

Steampipe Tables

SQL

with trail_logging_status as (
select
name as trail_name,
case
when not is_logging then 'disabled'
else 'enabled'
end as logging_status
from
aws_cloudtrail_trail
where
home_region = region
)
select
logging_status,
count(*)
from
trail_logging_status
group by logging_status;

Dashboards

The query is used in the dashboards: