steampipe plugin install azure

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
allocated_outbound_portsbigintThe number of outbound ports to be used for NAT.
backend_address_poolsjsonbA reference to a pool of DIPs. Outbound traffic is randomly load balanced across IPs in the backend IPs.
cloud_environmenttextThe Azure Cloud Environment.
enable_tcp_resetbooleanReceive bidirectional TCP Reset on TCP flow idle timeout or unexpected connection termination. This element is only used when the protocol is set to TCP.
etagtextA unique read-only string that changes whenever the resource is updated.
frontend_ip_configurationsjsonbThe Frontend IP addresses of the load balancer.
idtextThe resource ID.
idle_timeout_in_minutesbigintThe 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_nametext=The friendly name that identifies the load balancer.
nametext=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.
protocoltextThe protocol for the outbound rule in load balancer. Possible values include: 'LoadBalancerOutboundRuleProtocolTCP', 'LoadBalancerOutboundRuleProtocolUDP', 'LoadBalancerOutboundRuleProtocolAll'.
provisioning_statetextThe provisioning state of the outbound rule resource. Possible values include: 'ProvisioningStateSucceeded', 'ProvisioningStateUpdating', 'ProvisioningStateDeleting', 'ProvisioningStateFailed'.
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_outbound_rule