turbot/ibm_insights

Query: ibm_is_volume_age_table

Usage

powerpipe query ibm_insights.query.ibm_is_volume_age_table

Steampipe Tables

SQL

select
v.name as "Name",
now()::date - v.created_at::date as "Age in Days",
v.created_at as "Create Time",
v.status as "Status",
a.name as "Account",
v.account_id as "Account ID",
v.region as "Region",
v.zone ->> 'name' as "Zone",
v.crn as "CRN",
v.id as "ID"
from
ibm_is_volume as v,
ibm_account as a
where
v.account_id = a.customer_id
order by
v.name;

Dashboards

The query is used in the dashboards: