test-result-tables.md

title	titleSuffix	description	ms.technology	ms.topic	ms.assetid	ms.author	author	ms.date
Test Result tables	Azure DevOps Server	Learn how to query for data about test results.	devops-analytics	reference	0fa44e3e-3033-49e7-a796-eb4fbd12d984	kaelli	KathrynEE	10/20/2021

Test Result tables

[!INCLUDE temp]

Use the FactTestResult table and the associated dimension tables to query for data about test results. For information about the measures and dimensions that are associated with these tables in the SQL Server Analysis Services cube, see Test results.

Test results, test suites, and test plans

The DimTestResult table provides details about the test results themselves. You can use the DimTestPlan and DimTestSuite tables to organize the results by test plan and test suite.

Test results and test runs

You can use the DimTestRun, DimConfiguration, and DimPerson dimension tables to include data about how the tests were run.

Test results and builds

You can use the DimBuild, DimBuildFlavor, and DimBuildPlatform dimension tables, to include data about the build that was used to create the test results.

Test results and team project data

You can use the DimTeamProject, DimArea, and DimIteration tables to obtain details about how the tests are organized in the team project. You can use DimDate to show when the test results were created.

Related articles

• Test results
• Test Management Reports
• Testing overview
• Work Item Test Result tables
• Table reference for the relational warehouse database