DeploymentGroups
Retrieves a list of all deployment groups.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- ProjectId supports the '=' operator.
- Id supports the '=' operator.
- Name supports the '=' operator.
- Action supports the '=' operator.
- Expand supports the '=' operator.
For example:
SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Id = 29 SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Action = 'manage' SELECT * FROM DeploymentGroups WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND Expand = 'tags'
Insert
The following is an example of inserting into a DeploymentGroups table:
INSERT INTO DeploymentGroups (ProjectId, Name) VALUES ('c831d3b4-a289-462f', 'TestName')
Update
The following is an example of updating a DeploymentGroups table:
UPDATE DeploymentGroups SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'
Delete
The following is an example of deleting data in a DeploymentGroups table:
DELETE FROM DeploymentGroups WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
Id of the deployment group. | |
Description | String | False |
Description of the deployment group. | |
MachineCount | Integer | True |
Number of deployment targets in the deployment group. | |
MachineTags | String | True |
List of unique tags across all deployment targets in the deployment group. | |
Name | String | False |
Name of the deployment group. | |
PoolId | Integer | False |
Id of the agent pool. | |
PoolIsHosted | Boolean | True |
A value indicating whether or not this pool is managed by the service. | |
PoolIsLegacy | Boolean | True |
Determines whether the pool is legacy. | |
PoolName | String | True |
Name of the pool. | |
PoolType | String | True |
The type of the pool. | |
PoolScope | String | True |
The scope of the pool. | |
PoolSize | Integer | True |
The current size of the pool. | |
ProjectId | String | True |
Id of the project. | |
ProjectName | String | True |
Name of the project. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
Name | Type | Description |
Action | String |
Get the deployment group only if this action can be performed on it. The allowed values are manage, none, use. |
Expand | Boolean |
Include these additional details in the returned object. The allowed values are none, tags. |