turbot/oci_insights

Query: kms_key_lifecycle_state

Usage

powerpipe query oci_insights.query.kms_key_lifecycle_state

Steampipe Tables

SQL

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

Dashboards

The query is used in the dashboards: