turbot/oci_insights

Query: blockstorage_boot_volume_storage_by_compartment

Usage

powerpipe query oci_insights.query.blockstorage_boot_volume_storage_by_compartment

SQL

with compartments as (
select
id,
'root [' || title || ']' as title
from
oci_identity_tenancy
union
(
select
c.id,
c.title || ' [' || t.title || ']' as title
from
oci_identity_compartment c,
oci_identity_tenancy t
where
c.tenant_id = t.id
and c.lifecycle_state = 'ACTIVE'
)
)
select
c.title as "Title",
sum(v.size_in_gbs) as "GB"
from
oci_core_boot_volume as v,
compartments as c
where
c.id = v.compartment_id
and v.lifecycle_state <> 'TERMINATED'
group by
c.title
order by
c.title;

Dashboards

The query is used in the dashboards: