Table: azure_lb_outbound_rule - Query Azure Load Balancer Outbound Rules using SQL

Azure Load Balancer Outbound Rules are part of the Azure Load Balancer service, which allows you to manage and distribute network traffic. Outbound Rules in Azure Load Balancer provide you with the ability to control the outbound network traffic from a virtual network to the internet. They offer you the flexibility to scale and tune your outbound connectivity.

Table Usage Guide

The azure_lb_outbound_rule table provides insights into the outbound rules of Azure Load Balancers. As a network administrator, you can use this table to get detailed information about each outbound rule, including the associated Load Balancer, the allocated outbound ports, and the protocol used. This can help you better understand your network traffic and potentially identify any configuration issues or areas for optimization.

Examples

Basic info

Determine the status and type of your Azure Load Balancer outbound rules to understand their current provisioning state and manage your network traffic more effectively.

select
  id,
  name,
  type,
  provisioning_state,
  etag
from
  azure_lb_outbound_rule;

select
  id,
  name,
  type,
  provisioning_state,
  etag
from
  azure_lb_outbound_rule;

List failed load balancer outbound rules

Discover the segments that have failed in the provisioning process of outbound rules in Azure's load balancer. This can be useful to identify and troubleshoot problematic areas in your network infrastructure.

select
  id,
  name,
  type,
  provisioning_state
from
  azure_lb_outbound_rule
where
  provisioning_state = 'Failed';

select
  id,
  name,
  type,
  provisioning_state
from
  azure_lb_outbound_rule
where
  provisioning_state = 'Failed';

List load balancer outbound rules order by idle timeout

Analyze the settings to understand the sequence of outbound rules for a load balancer based on their idle timeout duration. This can help in effective management and optimization of network resources.

select
  id,
  name,
  type,
  idle_timeout_in_minutes
from
  azure_lb_outbound_rule
order by
  idle_timeout_in_minutes;

select
  id,
  name,
  type,
  idle_timeout_in_minutes
from
  azure_lb_outbound_rule
order by
  idle_timeout_in_minutes;

Schema for azure_lb_outbound_rule

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
allocated_outbound_ports	bigint		The number of outbound ports to be used for NAT.
backend_address_pools	jsonb		A reference to a pool of DIPs. Outbound traffic is randomly load balanced across IPs in the backend IPs.
cloud_environment	text		The Azure Cloud Environment.
enable_tcp_reset	boolean		Receive bidirectional TCP Reset on TCP flow idle timeout or unexpected connection termination. This element is only used when the protocol is set to TCP.
etag	text		A unique read-only string that changes whenever the resource is updated.
frontend_ip_configurations	jsonb		The Frontend IP addresses of the load balancer.
id	text		The resource ID.
idle_timeout_in_minutes	bigint		The timeout for the TCP idle connection. The value can be set between 4 and 30 minutes. The default value is 4 minutes. This element is only used when the protocol is set to TCP.
load_balancer_name	text	=	The friendly name that identifies the load balancer.
name	text	=	The name of the resource that is unique within the set of outbound rules used by the load balancer. This name can be used to access the resource.
protocol	text		The protocol for the outbound rule in load balancer. Possible values include: 'LoadBalancerOutboundRuleProtocolTCP', 'LoadBalancerOutboundRuleProtocolUDP', 'LoadBalancerOutboundRuleProtocolAll'.
provisioning_state	text		The provisioning state of the outbound rule resource. Possible values include: 'ProvisioningStateSucceeded', 'ProvisioningStateUpdating', 'ProvisioningStateDeleting', 'ProvisioningStateFailed'.
resource_group	text	=	The resource group which holds this resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
title	text		Title of the resource.
type	text		Type of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_lb_outbound_rule