turbot/steampipe-mod-gcp-insights

Query: compute_disk_inventory_table

Usage

powerpipe query gcp_insights.query.compute_disk_inventory_table

SQL

select
d.name as "Name",
d.creation_timestamp as "Creation Timestamp",
d.status as "Status",
d.size_gb as "Size GB",
d.type_name as "Type Name",
d.disk_encryption_key_type as "Disk Encryption Key Type",
d.source_image as "Source Image",
d.source_snapshot as "Source Snapshot",
d.labels as "Labels",
d.id::text as "ID",
p.name as "Project",
d.location as "Location"
from
gcp_compute_disk as d,
gcp_project as p
where
p.project_id = d.project
order by
d.name;

Dashboards

The query is used in the dashboards: