Skip to main content

pools

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

Overview

Namepools
TypeResource
Idazure.devops_infrastructure.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}. # pylint: disable=line-too-long
namestringThe name of the resource.
agentProfileobjectDefines how the machine will be handled once it executed a job. Required.
devCenterProjectResourceIdstringThe resource id of the DevCenter Project the pool belongs to. Required.
fabricProfileobjectDefines the type of fabric the agent will run on. Required.
identityobjectThe managed service identities assigned to this resource.
locationstringThe geo-location where the resource lives. Required.
maximumConcurrencyintegerDefines how many resources can there be created at any given time. Required.
organizationProfileobjectDefines the organization in which the pool will be used. Required.
provisioningStatestringThe status of the current operation. Known values are: "Succeeded", "Failed", "Canceled", "Provisioning", "Updating", "Deleting", and "Accepted". (Succeeded, Failed, Canceled, Provisioning, Updating, Deleting, Accepted)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
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
getselectresource_group_name, pool_name, subscription_idGet a Pool.
list_by_resource_groupselectresource_group_name, subscription_idList Pool resources by resource group.
list_by_subscriptionselectsubscription_idList Pool resources by subscription ID.
create_or_updateinsertresource_group_name, pool_name, subscription_id, locationCreate a Pool.
updateupdateresource_group_name, pool_name, subscription_idUpdate a Pool.
create_or_updatereplaceresource_group_name, pool_name, subscription_id, locationCreate a Pool.
deletedeleteresource_group_name, pool_name, subscription_idDelete a 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
pool_namestringName of the pool. It needs to be globally unique. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Get a Pool.

SELECT
id,
name,
agentProfile,
devCenterProjectResourceId,
fabricProfile,
identity,
location,
maximumConcurrency,
organizationProfile,
provisioningState,
systemData,
tags,
type
FROM azure.devops_infrastructure.pools
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND pool_name = '{{ pool_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a Pool.

INSERT INTO azure.devops_infrastructure.pools (
tags,
location,
properties,
identity,
resource_group_name,
pool_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ identity }}',
'{{ resource_group_name }}',
'{{ pool_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
identity,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Update a Pool.

UPDATE azure.devops_infrastructure.pools
SET
identity = '{{ identity }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND pool_name = '{{ pool_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
identity,
location,
properties,
systemData,
tags,
type;

REPLACE examples

Create a Pool.

REPLACE azure.devops_infrastructure.pools
SET
tags = '{{ tags }}',
location = '{{ location }}',
properties = '{{ properties }}',
identity = '{{ identity }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND pool_name = '{{ pool_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND location = '{{ location }}' --required
RETURNING
id,
name,
identity,
location,
properties,
systemData,
tags,
type;

DELETE examples

Delete a Pool.

DELETE FROM azure.devops_infrastructure.pools
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND pool_name = '{{ pool_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;