turbot/ibm_insights

Query: ibm_compute_instance_disk_by_account

Usage

powerpipe query ibm_insights.query.ibm_compute_instance_disk_by_account

SQL

select
a.name as "account",
count(d.*) as "disks"
from
ibm_is_instance_disk as d,
ibm_account as a
where
a.customer_id = d.account_id
group by
account
order by count(d.*) desc;

Dashboards

The query is used in the dashboards: