Control: Load balancers not assigned to any droplet should be reviewed

Usage

Run the control in your terminal:

steampipe check digitalocean_thrifty.control.network_load_balancer_unused

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share digitalocean_thrifty.control.network_load_balancer_unused

digitalocean_load_balancer

digitalocean_region

SQL

select
  b.urn as resource,
  case
    when jsonb_array_length(b.droplet_ids) < 1 then 'alarm'
    else 'ok'
  end as status,
  b.title || ' assigned with ' || jsonb_array_length(b.droplet_ids) || ' droplet(s).' as reason,
  r.name as region
from
  digitalocean_load_balancer as b
  left join digitalocean_region as r on r.slug = b.region_slug;

Tags