Query: kms_key_rotation_status

select
  rotation_status,
  count(*)
from
  (
    select
      case
        when rotation_period is null then 'disabled'
        else 'enabled'
      end rotation_status
    from
      gcp_kms_key
  ) as k
group by
  rotation_status
order by
  rotation_status desc;