Query: kms_vault_lifecycle_state

select
  case when lifecycle_state = 'DISABLED' then 'disabled' else 'enabled' end as status,
  count(*)
from
  oci_kms_vault
where
  lifecycle_state <> 'DELETED'
group by
  status;