Control: Unattached floating IP addresses should be released

powerpipe control run digitalocean_thrifty.control.network_floating_ip_unattached

powerpipe login
powerpipe control run digitalocean_thrifty.control.network_floating_ip_unattached --share

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;