Retrieves a list of all deployment groups.

Table Specific Information

Select

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

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。

Name	Type	Description
Action	String	Get the deployment group only if this action can be performed on it. 使用できる値は次のとおりです。manage, none, use
Expand	Boolean	Include these additional details in the returned object. 使用できる値は次のとおりです。none, tags