Query: ibm_compute_unused_instance_disk

select
  'Status' as label,
  case when i.status = 'running' then 'In-Use' else 'Unused' end as value,
  case when i.status = 'running' then 'ok' else 'alert' end as type
from
  ibm_is_instance_disk as d,
 ibm_is_instance as i
where
  d.instance_id = i.id
  and d.id = $1;