turbot/aws_insights

Query: kms_key_input

Usage

powerpipe query aws_insights.query.kms_key_input

Steampipe Tables

SQL

select
coalesce(a.title, k.title) as label,
k.arn as value,
json_build_object(
'target_key_id',
a.target_key_id,
'account_id',
k.account_id,
'region',
k.region
) as tags
from
aws_kms_key as k
left join aws_kms_alias as a on a.target_key_id = k.id
order by
a.title;

Dashboards

The query is used in the dashboards: