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';