Control: Unattached external IP addresses should be removed

powerpipe control run azure_thrifty.control.network_public_ip_unattached

powerpipe login
powerpipe control run azure_thrifty.control.network_public_ip_unattached --share

select
  ip.id as resource,
  case
    when ip.ip_configuration_id is null then 'alarm'
    else 'ok'
  end as status,
  case
    when ip.ip_configuration_id is null then ip.title  || ' has no associations.'
    else ip.title || ' associated with network interface ' || split_part(ip.ip_configuration_id, '/', 9) || '.'
  end as reason
  
  , ip.resource_group
  , display_name as subscription
from
  azure_public_ip as ip,
  azure_subscription as sub
where
  sub.subscription_id = ip.subscription_id;