steampipe plugin install azure

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';

Schema for azure_lb_backend_address_pool

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
backend_ip_configurationsjsonbAn array of references to IP addresses defined in network interfaces.
cloud_environmenttextThe Azure Cloud Environment.
etagtextA unique read-only string that changes whenever the resource is updated.
gateway_load_balancer_tunnel_interfacejsonbAn array of gateway load balancer tunnel interfaces.
idtextThe resource ID.
load_balancer_backend_addressesjsonbAn array of backend addresses.
load_balancer_nametext=The friendly name that identifies the load balancer.
load_balancing_rulesjsonbAn array of references to load balancing rules that use this backend address pool.
nametext=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_idtextA reference to an outbound rule that uses this backend address pool.
outbound_rulesjsonbAn array of references to outbound rules that use this backend address pool.
provisioning_statetextThe provisioning state of the backend address pool resource. Possible values include: 'Succeeded', 'Updating', 'Deleting', 'Failed'.
resource_grouptext=The resource group which holds this resource.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
titletextTitle of the resource.
typetextType 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