turbot/ibm_insights

Query: ibm_compute_unused_instance_disk_count

Usage

powerpipe query ibm_insights.query.ibm_compute_unused_instance_disk_count

SQL

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

Dashboards

The query is used in the dashboards: