Query: ibm_kms_key_state

select
  case when state in ('2', '3') then 'disabled' else 'enabled' end as status,
  count(*)
from
  ibm_kms_key
where
  state <> '5'
group by
  status;