turbot/digitalocean_insights

Query: droplet_network_vpc_details

Usage

powerpipe query digitalocean_insights.query.droplet_network_vpc_details

SQL

select
vpc.name as "Name",
vpc.urn as "URN",
vpc.id as "ID",
vpc.ip_range as "IP Range",
vpc.created_at as "Create Time"
from
digitalocean_droplet dr
join digitalocean_vpc vpc on vpc.id = vpc_uuid
where
dr.urn = $1
order by
vpc.name;

Dashboards

The query is used in the dashboards: