Since I banged my head against the wall to figure this out in powershell I thought I'd share it with everyone:
$ProjectName = "foo"
$TfsServerUrl = "http://tfsserverurl:8080/tfs/bar"
$testPlanName = "testplanname"
#===================================================
# Settings
#===================================================
Write-Host "Input parameters: "
$ParamObject = @{
'ProjectName' = $ProjectName;
'TfsServerUrl' = $TfsServerUrl;
'testPlanName' = $testPlanName;
}
$ParamObject | Format-Table
#===================================================
# Main Script Body
#===================================================
#load assemblies
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.TeamFoundation.Client")
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.TeamFoundation.WorkItemTracking.Client")
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.TeamFoundation.TestManagement.Common")
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.TeamFoundation.TestManagement.Client")
#get TFS structure, project
$tfs = new-object Microsoft.TeamFoundation.Client.TfsTeamProjectCollection([Microsoft.TeamFoundation.Client.TfsTeamProjectCollection]::GetFullyQualifiedUriForName($tfsServerUrl));
$tms = $tfs.GetService([Microsoft.TeamFoundation.TestManagement.Client.ITestManagementService]);
$project = [Microsoft.TeamFoundation.TestManagement.Client.ITestManagementTeamProject]$tms.GetTeamProject($ProjectName);
#powershell bug workaround, $project.TestPlans property is not available
$testPlansProperty = [Microsoft.TeamFoundation.TestManagement.Client.ITestManagementTeamProject].GetProperty("TestPlans").GetGetMethod();
$testPlans = $testPlansProperty.Invoke($project, "instance,public", $null, $null, $null);
# List all Test Plans
foreach($p in $testPlans.Query("Select * From TestPlan"))
{
"Plan - {0} : {1}" -f $p.Id, $p.Name
}
$currentPlan = $testPlans.Query("Select * From TestPlan Where planName = '{0}'" -f $testPlanName)
$plan = $currentPlan | where {$_.Name -eq $testPlanName}
$testCases = $plan.RootSuite.AllTestCases
foreach($testCase in $testCases)
{
write-host ""
write-host "-----------"
write-host "START - Test Case" $testCase.Id
write-host "Parameters:"
$testCase.TestSuiteEntry.TestCase.DefaultTable
write-host "-----------"
}