Skip to main content

load_balancer_backend_address_pools

Creates, updates, deletes, gets or lists a load_balancer_backend_address_pools resource.

Overview

Nameload_balancer_backend_address_pools
TypeResource
Idazure.network.load_balancer_backend_address_pools

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource ID.
namestringName of the resource.
backendIPConfigurationsarrayAn array of references to IP addresses defined in network interfaces.
drainPeriodInSecondsintegerAmount of seconds Load Balancer waits for before sending RESET to client and backend address.
etagstringA unique read-only string that changes whenever the resource is updated.
inboundNatRulesarrayAn array of references to inbound NAT rules that use this backend address pool.
loadBalancerBackendAddressesarrayAn array of backend addresses.
loadBalancingRulesarrayAn array of references to load balancing rules that use this backend address pool.
locationstringThe location of the backend address pool.
outboundRuleobjectReference to another subresource.
outboundRulesarrayAn array of references to outbound rules that use this backend address pool.
provisioningStatestringThe provisioning state of the backend address pool resource. Known values are: "Failed", "Succeeded", "Canceled", "Creating", "Updating", and "Deleting". (Failed, Succeeded, Canceled, Creating, Updating, Deleting)
syncModestringBackend address synchronous mode for the backend pool. Known values are: "Automatic" and "Manual". (Automatic, Manual)
tunnelInterfacesarrayAn array of gateway load balancer tunnel interfaces.
typestringResource type.
virtualNetworkobjectReference to another subresource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, load_balancer_name, backend_address_pool_name, subscription_idGets load balancer backend address pool.
listselectresource_group_name, load_balancer_name, subscription_idGets all the load balancer backed address pools.
create_or_updateinsertresource_group_name, load_balancer_name, backend_address_pool_name, subscription_idCreates or updates a load balancer backend address pool.
create_or_updatereplaceresource_group_name, load_balancer_name, backend_address_pool_name, subscription_idCreates or updates a load balancer backend address pool.
deletedeleteresource_group_name, load_balancer_name, backend_address_pool_name, subscription_idDeletes the specified load balancer backend address pool.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
backend_address_pool_namestringThe name of the backend address pool. Required.
load_balancer_namestringThe name of the load balancer. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets load balancer backend address pool.

SELECT
id,
name,
backendIPConfigurations,
drainPeriodInSeconds,
etag,
inboundNatRules,
loadBalancerBackendAddresses,
loadBalancingRules,
location,
outboundRule,
outboundRules,
provisioningState,
syncMode,
tunnelInterfaces,
type,
virtualNetwork
FROM azure.network.load_balancer_backend_address_pools
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND load_balancer_name = '{{ load_balancer_name }}' -- required
AND backend_address_pool_name = '{{ backend_address_pool_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates a load balancer backend address pool.

INSERT INTO azure.network.load_balancer_backend_address_pools (
id,
name,
properties,
resource_group_name,
load_balancer_name,
backend_address_pool_name,
subscription_id
)
SELECT
'{{ id }}',
'{{ name }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ load_balancer_name }}',
'{{ backend_address_pool_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
properties,
type
;

REPLACE examples

Creates or updates a load balancer backend address pool.

REPLACE azure.network.load_balancer_backend_address_pools
SET
id = '{{ id }}',
name = '{{ name }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND load_balancer_name = '{{ load_balancer_name }}' --required
AND backend_address_pool_name = '{{ backend_address_pool_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
properties,
type;

DELETE examples

Deletes the specified load balancer backend address pool.

DELETE FROM azure.network.load_balancer_backend_address_pools
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND load_balancer_name = '{{ load_balancer_name }}' --required
AND backend_address_pool_name = '{{ backend_address_pool_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;