turbot/alicloud_insights

Query: ecs_disk_attached_instances_count

Usage

powerpipe query alicloud_insights.query.ecs_disk_attached_instances_count

Steampipe Tables

SQL

select
'Attached Instances' as label,
case
when attachments is null then 0
else jsonb_array_length(attachments)
end as value,
case
when jsonb_array_length(attachments) > 0 then 'ok'
else 'alert'
end as "type"
from
alicloud_ecs_disk
where
account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4)
and arn = $1;

Dashboards

The query is used in the dashboards: