ODBC Driver for Azure DevOps

Build 22.0.8479


Retrieves all machines for the specific deployment group.

Table Specific Information


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

  • ProjectId supports the '=' operator.
  • DeploymentGroupId supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.

NOTE: DeploymentGroupId is required in order to query DeploymentGroupMachines.

For example:

    SELECT * FROM DeploymentGroupMachines WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND DeploymentGroupId = 29


Name Type References Description
Id [KEY] Integer Id of the deployment group machine.
ProjectId String


Id of the project.
DeploymentGroupId Integer


Id of the deployment group.
AgentLinksSelfHref String Agent self reference link.
AgentLinksWebHref String Agent web reference link.
AgentAccessPoint String This agent's access point.
AgentAuthorizationClientId String Client identifier for this agent.
AgentAuthorizationPublicKeyExponent String The exponent for the public key.
AgentAuthorizationPublicKeyModulus String The modulus for the public key.
AgentCreatedOn Datetime Date on which this agent was created.
AgentEnabled Boolean Whether or not this agent should run jobs.
AgentId Integer Identifier of the agent.
AgentMaxParallelism Integer Maximum job parallelism allowed for this agent.
AgentName String Name of the agent.
AgentOsDescription String Agent OS.
AgentProvisioningState String Provisioning state of this agent.
AgentStatus String Whether or not the agent is online.
AgentStatusChangedOn Datetime Date on which the last connectivity status change occurred.
AgentVersion String Agent version.
PropertiesCount Integer The count of properties in the collection.
PropertiesItem String The item in the properties collection.
PropertiesKeys String The set of keys in the collection.
PropertiesValues String The set of values in the collection.
Tags String Tags of the deployment target.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479