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;