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;