turbot/oci_insights

Query: blockstorage_boot_volume_storage_by_tenancy

Usage

powerpipe query oci_insights.query.blockstorage_boot_volume_storage_by_tenancy

SQL

select
t.title as "Tenancy",
sum(v.size_in_gbs) as "GB"
from
oci_core_boot_volume as v,
oci_identity_tenancy as t
where
t.id = v.tenant_id
and v.lifecycle_state <> 'TERMINATED'
group by
t.title
order by
t.title;

Dashboards

The query is used in the dashboards: