turbot/oci_insights

Query: blockstorage_block_volume_with_backups

Usage

powerpipe query oci_insights.query.blockstorage_block_volume_with_backups

Steampipe Tables

SQL

select
case
when volume_backup_policy_assignment_id is null then 'no backup policy'
else 'with backup policy'
end as status,
count(*)
from
oci_core_volume
where
lifecycle_state <> 'TERMINATED'
group by
status;

Dashboards

The query is used in the dashboards: