Query: load_balancer_outbound_rules

select
  r ->> 'name' as "Name",
  r -> 'properties' ->> 'allocatedOutboundPorts' as "Allocated Outbound Ports",
  r -> 'properties' ->> 'enableTcpReset' as "Enable TCP Reset",
  r -> 'properties' ->> 'frontendPort' as "Frontend Port",
  r -> 'properties' ->> 'idleTimeoutInMinutes' as "Idle Timeout In Minutes",
  r -> 'properties' ->> 'protocol' as "Protocol",
  r -> 'properties' -> 'frontendIPConfigurations' ->> 'id' as "Frontend IP Configuration ID",
  r -> 'properties' -> 'backendAddressPool'  ->> 'id' as "Backend Address Pool ID",
  r ->> 'id' as "ID"
from
  azure_lb,
  jsonb_array_elements(outbound_rules) as r
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);