Query: kms_cmk_lifecycle_table

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;