Query: network_subnets_for_compute_virtual_machine_scale_set_vm

with ip_configs as (
  select
    nic.ip_configurations as ip_config,
    lower(vm.id) as vm_id,
    lower(nic.id) as nic_i
  from
    azure_compute_virtual_machine_scale_set_vm as vm
    left join azure_compute_virtual_machine_scale_set_network_interface as nic on lower(vm.id) = lower(nic.virtual_machine ->> 'id')
  where
    lower(vm.id) = $1
)
select
  lower(s.id) as subnet_id
from
  ip_configs,
  jsonb_array_elements(ip_config) as c
  left join azure_subnet as s on lower(s.id) = lower(c -> 'properties' -> 'subnet' ->> 'id')
where
  lower(s.id) is not null;