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;