turbot/aws_insights

Query: kms_cmk_lifecycle_table

Usage

powerpipe query aws_insights.query.kms_cmk_lifecycle_table

Steampipe Tables

SQL

select
k.id as "Key ID",
case when k.key_rotation_enabled then 'Enabled' else null end as "Key Rotation",
k.key_state as "Key State",
k.key_manager as "Key Manager",
k.deletion_date as "Deletion Date",
a.title as "Account",
k.account_id as "Account ID",
k.region as "Region",
k.arn as "ARN"
from
aws_kms_key as k,
aws_account as a
where
k.account_id = a.account_id
and k.key_manager = 'CUSTOMER'
order by
k.id;

Dashboards

The query is used in the dashboards: