turbot/oci_insights

Query: kms_vault_lifecycle_state

Usage

powerpipe query oci_insights.query.kms_vault_lifecycle_state

Steampipe Tables

SQL

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;

Dashboards

The query is used in the dashboards: