Skip to main content

ip_pools

Creates, updates, deletes, gets or lists an ip_pools resource.

Overview

Nameip_pools
TypeResource
Idazure_stack.fabric_admin.ip_pools

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
namestringThe name of the resource
propertiesobjectProperties of an IpPool.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, location, ipPoolReturn the requested IP pool.
listselectsubscriptionId, resourceGroupName, location$filterReturns a list of all IP pools at a certain location.
create_or_updateinsertsubscriptionId, resourceGroupName, location, ipPoolCreate an IP pool. Once created an IP pool cannot be deleted.

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
ipPoolstringIP pool name.
locationstringThe name of Azure region.
resourceGroupNamestringName of the resource group.
subscriptionIdstringThe ID of the target subscription.
$filterstringOData filter parameter.

SELECT examples

Return the requested IP pool.

SELECT
id,
name,
properties,
type
FROM azure_stack.fabric_admin.ip_pools
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND location = '{{ location }}' -- required
AND ipPool = '{{ ipPool }}' -- required
;

INSERT examples

Create an IP pool. Once created an IP pool cannot be deleted.

INSERT INTO azure_stack.fabric_admin.ip_pools (
data__properties,
subscriptionId,
resourceGroupName,
location,
ipPool
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ location }}',
'{{ ipPool }}'
RETURNING
id,
name,
properties,
type
;