turbot/aws_insights

Query: cloudtrail_trails_for_kms_key

Usage

powerpipe query aws_insights.query.cloudtrail_trails_for_kms_key

Steampipe Tables

SQL

select
t.arn as trail_arn
from
aws_cloudtrail_trail as t
where
t.kms_key_id = $1
and t.region = split_part($1, ':', 4)
and t.account_id = split_part($1, ':', 5);