Query: ibm_compute_unused_instance_disk_count

select
  count(d.*) as value,
  'Unused' as label,
  case count(d.*) when 0 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 i.status <> 'running';