Tableau Connector for Azure DevOps

Build 24.0.9060

AgentPools

Retrieves a list of agent pools.

Table Specific Information

Select

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

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.

The allowed values are 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

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

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

The allowed values are manage, none, use.

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