turbot/oci_insights

Query: ons_subscription_by_lifecycle_state

Usage

powerpipe query oci_insights.query.ons_subscription_by_lifecycle_state

Steampipe Tables

SQL

select
case when lifecycle_state = 'PENDING' then 'unused' else 'in_use' end as status,
count(lifecycle_state)
from
oci_ons_subscription
where
lifecycle_state <> 'DELETED'
group by
status;