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 = (split_part($1, '/', 1))::bigint
and project = split_part($1, '/', 2);

Dashboards

The query is used in the dashboards: