Query: network_network_interfaces_for_compute_virtual_machine_scale_set

with nic_list as (
  select
    n ->> 'name' as nic_name
  from
    azure_compute_virtual_machine_scale_set as s,
    jsonb_array_elements(virtual_machine_network_profile -> 'networkInterfaceConfigurations') n
  where
    lower(s.id) = $1
    and s.subscription_id = split_part($1, '/', 3)
)
select
  lower(nic.id) as network_interface_id
from
  azure_compute_virtual_machine_scale_set_network_interface as nic
where
  nic.name = (select nic_name from nic_list )
  and lower(split_part(nic.virtual_machine ->> 'id', '/virtualMachines', 1)) = $1
limit 1