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;