pools

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

Overview

Name	pools
Type	Resource
Id	azure.devops_infrastructure.pools

Fields

vw_pools

Name	Datatype	Description
agent_profile	text	field from the properties object
dev_center_project_resource_id	text	field from the properties object
fabric_profile	text	field from the properties object
identity	text	Managed service identity (system assigned and/or user assigned identities)
location	text	The geo-location where the resource lives
maximum_concurrency	text	field from the properties object
organization_profile	text	field from the properties object
poolName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

pools

Name	Datatype	Description
identity	object	Managed service identity (system assigned and/or user assigned identities)
location	string	The geo-location where the resource lives
properties	object	Pool properties
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	poolName, resourceGroupName, subscriptionId	Get a Pool
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List Pool resources by resource group
list_by_subscription	SELECT	subscriptionId	List Pool resources by subscription ID
create_or_update	INSERT	poolName, resourceGroupName, subscriptionId	Create a Pool
delete	DELETE	poolName, resourceGroupName, subscriptionId	Delete a Pool
update	UPDATE	poolName, resourceGroupName, subscriptionId	Update a Pool

SELECT examples

List Pool resources by subscription ID

vw_pools

SELECT
agent_profile,
dev_center_project_resource_id,
fabric_profile,
identity,
location,
maximum_concurrency,
organization_profile,
poolName,
provisioning_state,
resourceGroupName,
subscriptionId,
tags
FROM azure.devops_infrastructure.vw_pools
WHERE subscriptionId = '{{ subscriptionId }}';

pools

SELECT
identity,
location,
properties,
tags
FROM azure.devops_infrastructure.pools
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new pools resource.

All Properties

/*+ create */
INSERT INTO azure.devops_infrastructure.pools (
poolName,
resourceGroupName,
subscriptionId,
properties,
identity,
tags,
location
)
SELECT 
'{{ poolName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ identity }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: maximumConcurrency
          value: integer
        - name: organizationProfile
          value:
            - name: kind
              value: string
        - name: agentProfile
          value:
            - name: kind
              value: string
            - name: resourcePredictions
              value: []
            - name: resourcePredictionsProfile
              value:
                - name: kind
                  value: []
        - name: fabricProfile
          value:
            - name: kind
              value: string
        - name: devCenterProjectResourceId
          value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a pools resource.

/*+ update */
UPDATE azure.devops_infrastructure.pools
SET 
identity = '{{ identity }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
poolName = '{{ poolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified pools resource.

/*+ delete */
DELETE FROM azure.devops_infrastructure.pools
WHERE poolName = '{{ poolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';