SSIS Components for Azure DevOps

Build 24.0.9063

AgentPools

Retrieves a list of agent pools.

Table Specific Information

Select

The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=,in' operators.
  • PoolType supports the '=' operator.
  • Action supports the '=' operator.
  • Properties supports the 'in' operator.
The rest of the filter is executed client-side in the 本製品.

For example:

	SELECT * FROM AgentPools WHERE Id IN (1, 2, 3)
	SELECT * FROM AgentPools WHERE Id = 9
	SELECT * FROM AgentPools WHERE PoolType = 'deployment'
	SELECT * FROM AgentPools WHERE Action = 'manage'

Insert

The following are examples of inserting into an AgentPools table:

INSERT INTO AgentPools (Name) VALUES ('PoolA')
INSERT INTO AgentPools (IsHosted, CreatedByDisplayName, AgentCloudId, Name) VALUES (false, 'Cdata', 1, 'Cdata_Ecity')

Update

The following is an example of updating an AgentPools table:

UPDATE AgentPools SET Name = 'Data1' WHERE Id = 1

Delete

The following is an example of deleting data in an AgentPools table:

DELETE FROM AgentPools WHERE Id = '1'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the agent pool.

AgentCloudId Integer False

The ID of the associated agent cloud.

AutoProvision Boolean False

Whether or not a queue should be automatically provisioned for each project collection.

AutoSize Boolean False

Whether or not the pool should autosize itself based on the agent cloud provider settings.

AutoUpdate Boolean False

Whether or not a pool should be automatically updated.

CreatedByDescriptor String False

The descriptor is the primary way to reference the creator while the system is running.

CreatedByDisplayName String False

This is the non-unique display name of the creator.

CreatedById String False

Id of the creator.

CreatedByUrl String False

Full http link to the creator.

CreatedOn Datetime False

The date/time of the pool creation.

IsHosted Boolean False

Indicates whether or not this pool is managed by the service.

IsLegacy Boolean False

Determines whether the pool is legacy.

Name String False

The name of the agent pool.

OwnerDescriptor String False

The descriptor is the primary way to reference the owner while the system is running.

OwnerDisplayName String False

This is the non-unique display name of the owner.

OwnerId String False

Id of the owner.

OwnerUrl String False

Full Http Link to the owner.

PoolType String False

The type of the pool.

使用できる値は次のとおりです。automation, deployment

Properties String False

Represents a property bag as a collection of key-value pairs.

Scope String False

The scope of the pool.

Size Integer False

The current size of the pool.

TargetSize Integer False

Target parallelism.

Pseudo-Columns

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

Name Type Description
Action String

Filter by whether the calling user has use or manage permissions.

使用できる値は次のとおりです。manage, none, use

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063