Exporting report counters to a CSV file - Legacy Reports

To perform further analysis on test results, export the report counters to a CSV file. You can change the test preferences to export results automatically.

Procedure

  1. In the Test Navigator, double-click the run whose counters you want to export. Each run begins with the name of the schedule or test, and ends with the date of the run in brackets. The Performance Test Runs view opens and displays the details of the selected run.
  2. In the Performance Test Runs view, expand the All Hosts node, right-click the report whose counters you want to export, and select Export report counters to CSV.
  3. In the Export Report Counters window, browse to the target CSV file or type its name (with the .csv extension).
  4. In the Exported encoding field, you typically keep the default (locale-specific encoding) unless the exported CSV file is shared by multiple applications that recognize a specific encoding or by computers in different locales. For example, if the language on your computer is Japanese and you are exporting the file to a computer with English encoding, set Exported encoding to ASCII.
  5. In Export type, select Full or Simple.
    Option Description
    Full The CSV file will contain all of the values of the counter; that is, the values of each counter for each statistical interval of the run. Select Export overall results to export results from the All Hosts location. Clear this option to export the data from each location, but not the data from All Hosts.
    Simple The CSV file will contain the last value for each counter. Select Include counter details to include the name of the run, node name, and the time range for each counter.
  6. Click Finish.

What to do next

To automatically export report counters after a run completes from the command line, Open the Default Report Preferences page. Click Windows > Preferences > Test > Performance Test Reports > Export Reports, and select the reports to be exported. The CSV file will contain the last value for each counter in the report.
Feedback