turbot/gcp_insights

Query: source_compute_images_for_compute_disk

Usage

powerpipe query gcp_insights.query.source_compute_images_for_compute_disk

SQL

select
i.id :: text as image_id
from
gcp_compute_disk d,
gcp_compute_image i
where
d.id = $1
and d.source_image <> ''
and d.source_image = i.self_link;