turbot/digitalocean_insights

Query: network_vpc_association

Usage

powerpipe query digitalocean_insights.query.network_vpc_association

SQL

-- Droplets
select
d.title as "Title",
'digitalocean_droplet' as "Type",
d.urn as "URN",
'/digitalocean_insights.dashboard.droplet_detail?input.droplet_urn=' || d.urn as link
from
digitalocean_droplet as d,
digitalocean_vpc as v
where
v.id = d.vpc_uuid
and v.urn = $1
-- Databases
union all
select
d.title as "Title",
'digitalocean_database' as "Type",
d.urn as "URN",
'/digitalocean_insights.dashboard.database_cluster_detail?input.database_cluster_urn=' || d.urn as link
from
digitalocean_database as d,
digitalocean_vpc as v
where
v.id = d.private_network_uuid
and v.urn = $1
-- Load Balancers
union all
select
l.title as "Title",
'digitalocean_load_balancer' as "Type",
l.urn as "URN",
null as link
from
digitalocean_load_balancer as l,
digitalocean_vpc as v
where
v.id = l.vpc_uuid
and v.urn = $1

Dashboards

The query is used in the dashboards: