Query: kms_key_disabled_status

select
  disabled_status,
  count(*)
from
  (
    select
      case
        when enabled then 'enabled'
        else 'disabled'
      end disabled_status
    from
      aws_kms_key
  ) as t
group by
  disabled_status
order by
  disabled_status desc;