Query: ibm_kms_root_key_rotation_status

select
  rotation_status,
  count(*)
from
  (
    select
      case
        when rotation_policy = '{}' then 'disabled'
        else 'enabled'
      end rotation_status
    from
      ibm_kms_key
    where
      not extractable
      and state <> '5'
  ) as t
group by
  rotation_status
order by
  rotation_status desc;