Exporting results to a JSON file by using the product

When you want to analyze test results in a text format, you can export all test results or specific test results that are captured during a test run to a JSON file by using the product.

Before you begin

You must have at least one or more test results.

About this task

You can automatically export reports to a comma-separated values (CSV) or JSON file at the end of a test run. You can select the appropriate options to export reports from the command line, workbench, or both from the product preferences (Window > Preferences > Test > Performance Test Reports > Export Reports).

Procedure

  1. Open the workbench, and then go to File > Export.
  2. Expand the Test folder, and then select Performance Test Run Statistics as JSON file.
  3. Click Next.
    The Export Performance Test Run Statistics window is displayed.
  4. Specify the folder path to save exported test results in the Export Directory field.

    Alternatively, you can click Browse and select a directory.

  5. Select the encoding system for the exported results from the Exported encoding drop-down list.
  6. Expand the project, and then select one or more test results that you want to export.
    Note: When you select a test result, you can export data of specific time ranges. For example, Entire Run, 5 Users, or 15 Users. By default, the report includes the data for the Entire Run.
  7. Click Next and perform any of the following actions described in the following table to include the type of results into the JSON file:
    Requirements Options available Actions
    When you select a test result Simple

    1. Select Simple to export only the last value of each counter from results.

    2. Optional: Select Time Range Comparison to export data of specific time ranges.

    3. Optional: Select the time range that is displayed depending on the test result that you selected.

      For example, Entire Run, 5 Users or 15 Users.
      Note: By default, the report includes the data for the Entire Run.
    Full

    1. Select Full to export all the data for every sample interval during the test run.

    2. Optional: Select the Split output if counters number exceeds check box, and then specify a value to create multiple JSON files if the number of counters in the exported file exceed the specified value.
      Note: The default value is set to 250.
    When you select one or more test results Simple

    Select Simple to export only the last value of each counter from results.
    Full

    1. Select Full to export all the data for every sample interval during the test run.

    2. Optional: Select the Split output if counters number exceeds check box, and then specify a value to create multiple JSON files if the number of counters in the exported file exceed the specified value.
      Note: The default value is set to 250.
  8. Select the Include per instance counters check box to include a description of the name of the result, node name, and time range for each counter.
  9. Select the Export each agent separately check box to group the data in the exported JSON file by prefixing the name of the counters with the name of the agent.
  10. Optional: Select the One file per agent check box to export data that was run on the agent in separate JSON files.
    Note: The One file per agent option is available only when you select the Export each agent separately option.
  11. Click Finish to save the exported results to a JSON file.

Results

You have exported test results in to the JSON file by using the product.

What to do next

You can now analyze the result and share the file with stakeholders for further analysis of the results.