Query: network_express_route_circuit_peerings_secondary

select
  name as "Name",
  replace(jsonb_path_query(peerings, '$.properties.secondaryAzurePort')::text, '"', '') as "Secondary Azure Port",
  replace(jsonb_path_query(peerings, '$.properties.secondaryPeerAddressPrefix')::text, '"', '') as "Secondary Peer Address Prefix"
from
  azure_express_route_circuit
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3)
order by
  name;