turbot/gcp_insights

Query: storage_bucket_age_table

Usage

powerpipe query gcp_insights.query.storage_bucket_age_table

SQL

select
b.name as "Name",
b.id as "ID",
now()::date - b.time_created::date as "Age in Days",
b.time_created as "Create Time",
p.name as "Project",
p.project_id as "Project ID",
b.location as "Location",
b.self_link as "Self-Link"
from
gcp_storage_bucket as b,
gcp_project as p
where
p.project_id = b.project
order by
b.time_created,
b.name;

Dashboards

The query is used in the dashboards: