turbot/alicloud_insights

Query: kms_key_age_table

Usage

powerpipe query alicloud_insights.query.kms_key_age_table

SQL

select
k.key_id as "Key ID",
now()::date - k.creation_date::date as "Age in Days",
k.creation_date as "Creation Date",
k.key_state as "Key State",
a.title as "Account",
k.account_id as "Account ID",
k.region as "Region",
k.arn as "ARN"
from
alicloud_kms_key as k,
alicloud_account as a
where
k.account_id = a.account_id
order by
k.creation_date,
k.key_id;

Dashboards

The query is used in the dashboards: