turbot/ibm_insights

Query: ibm_is_volume_attached_instances_count

Usage

powerpipe query ibm_insights.query.ibm_is_volume_attached_instances_count

Steampipe Tables

SQL

select
'Attached Instances' as label,
case
when jsonb_array_length(volume_attachments) = 0 then 0
else jsonb_array_length(volume_attachments)
end as value,
case
when jsonb_array_length(volume_attachments) > 0 then 'ok'
else 'alert'
end as "type"
from
ibm_is_volume
where
crn = $1;

Params

ArgsNameDefaultDescriptionVariable
$1crn

    Dashboards

    The query is used in the dashboards: