turbot/gcp_insights

Query: compute_disk_storage_by_project

Usage

powerpipe query gcp_insights.query.compute_disk_storage_by_project

SQL

select
p.title as "Project",
sum(d.size_gb) as "GB"
from
gcp_compute_disk as d,
gcp_project as p
where
p.project_id = d.project
group by
p.title
order by count(d.*) desc;

Dashboards

The query is used in the dashboards: