Query: kms_key_disabled_status

select
  lower(disabled_status),
  count(*) as "Keys"
from (
  select
    key_state as disabled_status
  from
    alicloud_kms_key
  where
    lower(key_state) != 'pendingdeletion') as t
group by
  disabled_status
order by
  disabled_status desc;