Query: load_balancer_inbound_nat_rules

select
  p ->> 'name' as "Name",
  p -> 'properties' ->> 'backendPort' as "Backend Port",
  p -> 'properties' ->> 'enableFloatingIP' as "Enable Floating IP",
  p -> 'properties' ->> 'enableTcpReset' as "Enable TCP Reset",
  p -> 'properties' -> 'frontendIPConfiguration' ->> 'id' as "Frontend IP Configuration ID",
  p -> 'properties' ->> 'frontendPort' as "Frontend Port",
  p -> 'properties' ->> 'idleTimeoutInMinutes' as "Idle Timeout In Minutes",
  p -> 'properties' ->> 'protocol' as "Protocol",
  p ->> 'id' as "ID"
from
  azure_lb,
  jsonb_array_elements(inbound_nat_rules) as p
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);