turbot/gcp_insights

Query: compute_disk_attached_instances_count

Usage

powerpipe query gcp_insights.query.compute_disk_attached_instances_count

Steampipe Tables

SQL

select
'Attached Instances' as label,
case
when users is null then 0
else jsonb_array_length(users)
end as value,
case
when jsonb_array_length(users) > 0 then 'ok'
else 'alert'
end as "type"
from
gcp_compute_disk
where
id = $1;

Dashboards

The query is used in the dashboards: