Query: network_interface_public_ip_address

with public_ip_address_id as (
  select
    ip -> 'properties' -> 'publicIPAddress' ->> 'id' as public_ip_address
  from
    azure_network_interface as nci
    cross join jsonb_array_elements(ip_configurations) as ip
  where
    lower(nci.id) = $1
    and nci.subscription_id = split_part($1, '/', 3)
)
select
  'Public IP Address' as label,
  api.ip_address as value
from
  azure_public_ip as api,
  public_ip_address_id as pip
where
  lower(api.id) = lower(pip.public_ip_address);