Viewing Open Work Items, TFS via PowerShell

tfs-open-work-items.ps1

<#

Taken from Julian Kay's Blog:

http://juliankay.com/development/querying-tfs-with-tfpt-exe-and-powershell/

#>

$TFSSERVER   = "hq-tfs08-01.branded3.net"

Function Get-WorkItem
{
    $query = "SELECT [System.Id], [System.Title] FROM WorkItems " +
             "WHERE [System.AssignedTo] = 'Julian Kay' " +
             "AND [System.State] <> 'Closed' " +
             "AND [System.State] <> 'Resolved' " +
             "ORDER BY [System.Id]"

    tfpt query /collection:$TFSSERVER /wiql:$query /include:data
}