TFPT query exmple

tfpt_ex1.ps1

# Given AX project #, return ID.
param (
    [string]$projno =  $( Read-Host "Enter project # (e.g. 123.4)" )
)

[string]$tfpt = "C:\Program Files (x86)\Microsoft Team Foundation Server 2012 Power Tools\TFPT.EXE"
[string]$svr = "http://myTfsServer:8080/tfs/defaultcollection"
[string]$projname = "myProjName"
[string]$query = "SELECT [System.Id], [System.Title] FROM WorkItems " +
    "WHERE [System.TeamProject] = '$projname' " +
    "AND [System.Title] CONTAINS '$projno' " +
    "ORDER BY [System.Id] asc"

$data = & $tfpt query /collection:$svr /wiql:$query /include:data

if ($data -ne $null) {
    $line = ($data | select -first 1)
    $taskid = $line.split("`t")[0]
    $taskid | clip
}
$data

Write-Host "Press any key to continue ..."
$x = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")