Table: azure_lb_backend_address_pool - Query Azure Load Balancer Backend Address Pools using SQL

A Backend Address Pool is a part of Azure Load Balancer, which contains IP addresses served by the load balancer. It is a critical component for defining the resource allocation and traffic distribution in the Azure Load Balancer. It provides a centralized way to manage and distribute network traffic among multiple resources, such as virtual machines.

Table Usage Guide

The azure_lb_backend_address_pool table provides insights into the backend address pools associated with Azure Load Balancers. As a Network Administrator, explore pool-specific details through this table, including associated load balancers, network interfaces, and IP configurations. Utilize it to understand the distribution of network traffic, manage resource allocation, and ensure optimal load balancing across your Azure resources.

Examples

Basic info

Explore the status and type of your Azure load balancer's backend address pool to understand its current operational state and configuration. This helps in managing and troubleshooting your network traffic operations effectively.

select
  id,
  name,
  load_balancer_name,
  provisioning_state,
  type
from
  azure_lb_backend_address_pool;

select
  id,
  name,
  load_balancer_name,
  provisioning_state,
  type
from
  azure_lb_backend_address_pool;

List failed load balancer backend address pools

Determine the areas in which Azure load balancer backend address pools have failed to provision. This can be useful for troubleshooting and identifying areas that require attention or modification.

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

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

Query examples

Schema for azure_lb_backend_address_pool

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.
backend_ip_configurations	jsonb		An array of references to IP addresses defined in network interfaces.
cloud_environment	text		The Azure Cloud Environment.
etag	text		A unique read-only string that changes whenever the resource is updated.
gateway_load_balancer_tunnel_interface	jsonb		An array of gateway load balancer tunnel interfaces.
id	text		The resource ID.
load_balancer_backend_addresses	jsonb		An array of backend addresses.
load_balancer_name	text	=	The friendly name that identifies the load balancer.
load_balancing_rules	jsonb		An array of references to load balancing rules that use this backend address pool.
name	text	=	The name of the resource that is unique within the set of backend address pools used by the load balancer. This name can be used to access the resource.
outbound_rule_id	text		A reference to an outbound rule that uses this backend address pool.
outbound_rules	jsonb		An array of references to outbound rules that use this backend address pool.
provisioning_state	text		The provisioning state of the backend address pool resource. Possible values include: 'Succeeded', 'Updating', 'Deleting', 'Failed'.
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_backend_address_pool