Query: load_balancer_load_balancing_rules

select
  r ->> 'name' as "Name",
  r -> 'properties' ->> 'backendPort' as "Backend Port",
  r -> 'properties' ->> 'disableOutboundSnat' as "Disable Outbound Snat",
  r -> 'properties' ->> 'enableFloatingIP' as "Enable Floating IP",
  r -> 'properties' ->> 'enableTcpReset' as "Enable TCP Reset",
  r -> 'properties' -> 'frontendPort' as "Frontend Port",
  r -> 'properties' -> 'idleTimeoutInMinutes' as "Idle Timeout In Minutes",
  r -> 'properties' -> 'backendAddressPool' ->> 'id' as "Backend Address Pool",
  r -> 'properties' -> 'frontendIPConfiguration' ->> 'id' as "Frontend IP Configuration ID",
  r -> 'properties' -> 'probe' ->> 'id' as "Probe ID",
  r -> 'properties' ->> 'protocol' as "Protocol",
  r ->> 'id' as "ID"
from
  azure_lb,
  jsonb_array_elements(load_balancing_rules) as r
where
  lower(id) = $1;