turbot/ibm_insights

Query: ibm_compute_instance_age_table

Usage

powerpipe query ibm_insights.query.ibm_compute_instance_age_table

SQL

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

Dashboards

The query is used in the dashboards: