Dashboard: DigitalOcean VPC Detail

This dashboard answers the following questions for each VPC:

How is the vpc configured?
What tags are applied?
Which droplets, databases and clusters are attached to it?
What relationships does the VPC have with other resources?

This dashboard contains 2 cards, 1 graph, 1 input and 3 tables.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-digitalocean-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select DigitalOcean VPC Detail dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run digitalocean_insights.dashboard.network_vpc_detail --share

Queries

This dashboard uses the the following queries:

-- 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

Dashboard: DigitalOcean VPC Detail

Usage

Queries

Tags