Query: network_interface_overview

select
  name as "Name",
  mac_address as "MAC Address",
  provisioning_state as "Provisioning State",
  etag as "ETag",
  region as "Region",
  resource_group as "Resource Group",
  subscription_id as "Subscription ID",
  id as "ID"
from
  azure_network_interface
  cross join jsonb_array_elements(ip_configurations) as ip
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);