turbot/digitalocean_insights

Query: droplet_public_access

Usage

powerpipe query digitalocean_insights.query.droplet_public_access

Steampipe Tables

SQL

select
'Public Access' as label,
case
when image ->> 'public' = 'true' then 'Enabled'
else 'Disabled'
end as value,
case
when image ->> 'public' = 'true' then 'alert'
else 'ok'
end as "type"
from
digitalocean_droplet
where
urn = $1;

Dashboards

The query is used in the dashboards: