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);