turbot/aws_insights

Query: kms_key_aliases

Usage

powerpipe query aws_insights.query.kms_key_aliases

Steampipe Tables

SQL

select
p ->> 'AliasArn' as "Alias Arn",
p ->> 'AliasName' as "Alias Name",
p ->> 'LastUpdatedDate' as "Last Updated Date",
p ->> 'TargetKeyId' as "Target Key ID"
from
aws_kms_key,
jsonb_array_elements(aliases) as p
where
arn = $1
and region = split_part($1, ':', 4)
and account_id = split_part($1, ':', 5);

Dashboards

The query is used in the dashboards: