Retrieves a list of all deployment groups.

Table Specific Information

Select

The adapter 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.

The rest of the filter is executed client-side in the adapter.

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.