Query: network_public_association

select
  'Association' as label,
  case
    when ip_configuration_id is not null then 'Associated'
    else 'Not Associated'
  end as value,
  case
    when ip_configuration_id is not null then 'ok'
    else 'alert'
  end as type
from
  azure_public_ip
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);