skip to Main Content

We are using the Azure DevOps Test Plan module for our manual testing. We have a Test Plan, under which, we have Test Suite, under which we have Test Cases that are assigned to different Testers. Testers use ADO to mark a Test Case outcome as passed or fail.

We want to download the Test Case outcome/results, but I don’t see that option. We have a Test Run tab under Test Plan which shows all Run outcomes but doesn’t give the option to download.

3

Answers


  1. Chosen as BEST ANSWER

    Below are the steps to download the Test Run results from ADO –

    1. Navigate to Test Plan -> Runs

    2. Click on filters, remove all filters and run the query

    3. Click on one result and press Ctrl + A and then Ctrl + C

    4. Paste the content in Notepad++, then copy the content from Notepad++ and paste it Excel.

    5. This will give you list of all Test Runs with results. You can get the latest outcome of test run, by sorting data using Run ID in descending order and then using unique rows only.


  2. You could Export the test plan properties, test suite properties along with details of the test cases and test points as either an email or print to pdf by using the Export function of the test suite: doc

    Make sure you have test access and permission in Azure DevOps.

    enter image description here

    enter image description here

    enter image description here

    Login or Signup to reply.
  3. I am afraid that there is no out-of-box method can directly export the test results of test runs to excel.

    To meet your requirement, you can use Rest API to list all required test runs and test results. Then you can export them to Excel.

    You can use the following two Rest APIs:

    Get Test Runs: Runs – Query

    GET https://dev.azure.com/{organization}/{project}/_apis/test/runs?minLastUpdatedDate={minLastUpdatedDate}&maxLastUpdatedDate={maxLastUpdatedDate}&state={state}&planIds={planIds}&isAutomated={isAutomated}&publishContext={publishContext}&buildIds={buildIds}&buildDefIds={buildDefIds}&branchName={branchName}&releaseIds={releaseIds}&releaseDefIds={releaseDefIds}&releaseEnvIds={releaseEnvIds}&releaseEnvDefIds={releaseEnvDefIds}&runTitle={runTitle}&$top={$top}&continuationToken={continuationToken}&api-version=7.0
    

    Get Test Results: Results – List

    GET https://dev.azure.com/{organization}/{project}/_apis/test/Runs/{runId}/results?detailsToInclude={detailsToInclude}&$skip={$skip}&$top={$top}&outcomes={outcomes}&api-version=7.0
    

    Here is PowerShell sample:

    $token = "PAT"
    
    $url=" https://dev.azure.com/orgname/projectname/_apis/test/runs?api-version=7.0"
    
    $token = [System.Convert]::ToBase64String([System.Text.Encoding]::ASCII.GetBytes(":$($token)"))
    
    $response = Invoke-RestMethod -Uri $url -Headers @{Authorization = "Basic $token"} -Method Get -ContentType application/json
    
    echo $response
    
    ForEach( $testrunid in $response.value.id ) 
    {
      echo $testrunid
      $url1 ="https://dev.azure.com/orgname/projectname/_apis/test/Runs/$($testrunid)/results?api-version=7.0"
      $response1 = Invoke-RestMethod -Uri $url1 -Headers @{Authorization = "Basic $token"} -Method Get -ContentType application/json
      
      ForEach( $testresult in $response1.value) 
      {
         $outcome = $testresult.outcome
         $startedDate = $testresult.startedDate
         $testCase =$testresult.testCase.name
         $completedDate = $testresult.completedDate
         $testCaseTitle = $testresult.testCaseTitle
         echo $outcome
         echo $startedDate
         $Output = New-Object -TypeName PSObject -Property @{
        outcome = $outcome
        runid =$testrunid
        startedDate = $startedDate
        completedDate= $completedDate
        testCase = $testCase 
        testCaseTitle = $testCaseTitle
       } | Select-Object runid, outcome,startedDate,testCase,testCaseTitle,completedDate
    $Output | Export-Csv C:testresult.csv -Append
    
      }
       
    }
    

    You can customize the output excel column according to your requirements.

    Result:

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search