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;