Query: ibm_compute_instance_age_table

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;