turbot/ibm_insights

Query: ibm_compute_instance_disk_age_table

Usage

powerpipe query ibm_insights.query.ibm_compute_instance_disk_age_table

SQL

select
d.name as "Name",
d.id as "ID",
now() :: date - d.created_at :: date as "Age in Days",
d.created_at as "Create Time",
a.name as "Account",
d.account_id as "Account ID",
d.region as "Region"
from
ibm_is_instance_disk as d,
ibm_account as a
where
d.account_id = a.customer_id
order by
d.name;

Dashboards

The query is used in the dashboards: