Retrieves all machines for the specific deployment group.

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.
• DeploymentGroupId supports the '=' operator.

The rest of the filter is executed client-side in the connector.

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	DeploymentGroups.Id	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.