steampipe plugin install azure

Table: azure_lb_nat_rule - Query Azure Load Balancer NAT Rules using SQL

Azure Load Balancer NAT Rules are part of the Azure Load Balancer service, which ensures high availability and network performance to your applications. NAT Rules are responsible for translating the public IP address and port of a packet to a private IP address and port. They play a crucial role in managing network traffic and routing.

Table Usage Guide

The azure_lb_nat_rule table provides insights into the NAT rules within Azure Load Balancer. As a network engineer, explore NAT rule-specific details through this table, including the associated load balancer, protocol, and ports. Utilize it to uncover information about NAT rules, such as their configuration, associated resources, and the effectiveness of the network routing.

Examples

Basic info

Explore which Azure Load Balancer NAT rules are currently in use and assess their provisioning states to ensure optimal performance and resource allocation. This query is particularly useful in managing and troubleshooting network traffic within your Azure environment.

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

List failed load balancer nat rules

Explore instances where load balancer NAT rules have failed in Azure. This helps in pinpointing areas of concern and aids in troubleshooting the issues for smooth operation.

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

List load balancer nat rules order by idle timeout

Analyze the settings to understand the order of NAT rules based on their idle timeout within a load balancer. This can be useful in optimizing system performance and managing network traffic more efficiently.

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

Schema for azure_lb_nat_rule

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
backend_ip_configurationjsonbA reference to a private IP address defined on a network interface of a VM. Traffic sent to the frontend port of each of the frontend IP configurations is forwarded to the backend IP.
backend_portbigintThe port used for the internal endpoint. Acceptable values range from 1 to 65535.
cloud_environmenttextThe Azure Cloud Environment.
enable_floating_ipbooleanConfigures a virtual machine's endpoint for the floating IP capability required to configure a SQL AlwaysOn Availability Group. This setting is required when using the SQL AlwaysOn Availability Groups in SQL server. This setting can't be changed after you create the endpoint.
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_configurationjsonbA reference to frontend IP addresses.
frontend_portbigintThe port for the external endpoint. Port numbers for each rule must be unique within the Load Balancer. Acceptable values range from 1 to 65534.
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 inbound NAT rules used by the load balancer. This name can be used to access the resource.
protocoltextThe reference to the transport protocol used by the load balancing rule. Possible values include: 'TransportProtocolUDP', 'TransportProtocolTCP', 'TransportProtocolAll'.
provisioning_statetextThe provisioning state of the inbound NAT rule resource.
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_nat_rule