Control: Unattached floating IP addresses should be released

Usage

Run the control in your terminal:

steampipe check digitalocean_thrifty.control.network_floating_ip_unattached

Snapshot and share results via Steampipe Cloud:

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

digitalocean_floating_ip

digitalocean_region

SQL

select
  ip.urn as resource,
  case
    when ip.droplet_id is null then 'alarm'
    else 'ok'
  end as status,
  case
    when ip.droplet_id is null then ip.title || ' not attached.'
    else ip.title || ' is attached.'
  end as reason,
  r.name as region
from
  digitalocean_floating_ip as ip
  left join digitalocean_region as r on r.slug = ip.region_slug;

Tags