turbot/digitalocean_insights

Query: image_images_for_droplet

Usage

powerpipe query digitalocean_insights.query.image_images_for_droplet

SQL

select
i.urn as image_urn
from
digitalocean_image as i,
digitalocean_droplet as d
where
i.id :: text = image ->> 'id'
and d.urn = $1;