DeploymentGroupMachines
Retrieves all machines for the specific deployment group.
Table Specific Information
Select
The driver 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.
NOTE: DeploymentGroupId is required in order to query DeploymentGroupMachines.
For example:
SELECT * FROM DeploymentGroupMachines WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND DeploymentGroupId = 29
Columns
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. |