Query: network_load_balancer_backend_address_pools_for_compute_virtual_machine_scale_set_vm

with compute_virtual_machine_scale_set_network_interface as (
  select
    nic.id as nic_id,
    lower(c ->> 'id') as config_id
  from
    azure_compute_virtual_machine_scale_set_network_interface as nic,
    jsonb_array_elements(ip_configurations) as c
  where
    lower(nic.virtual_machine ->> 'id') = $1
)
select
  lower(p.id) as pool_id
from
  azure_lb_backend_address_pool as p,
  jsonb_array_elements(backend_ip_configurations) as c
where
  lower(c ->> 'id') in (
    select
      config_id
    from
      compute_virtual_machine_scale_set_network_interface
  )