Query: compute_virtual_machine_scale_set_vm_network_interface

select
  nic ->> 'name' as "Name",
  (nic -> 'properties' ->> 'enableAcceleratedNetworking')::boolean as "Enable Accelerated Networking",
  (nic -> 'properties' ->> 'enableIPForwarding')::boolean as "Enable IP Forwarding",
  (nic -> 'properties' ->> 'primary')::boolean as "Primary",
  ip ->> 'name' as "IP Config Name",
  (ip -> 'properties' ->> 'primary')::boolean as "IP Primary",
  ip -> 'properties' ->> 'privateIPAddressVersion' as "Private IP Address Version"
from
  azure_compute_virtual_machine_scale_set_vm,
  jsonb_array_elements(virtual_machine_network_profile_configuration -> 'networkInterfaceConfigurations') nic,
  jsonb_array_elements(nic -> 'properties' -> 'ipConfigurations') ip
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);