Description
The table stores the history of test set runs.
Columns
The table contains the following columns:
TestRunId : int, primary key, allows null: no
The unique numeric identifier of the item.
ProjId : int, allows null: yes
The ID of the project that contains the item.
ReleaseId : int, allows null: yes
The ID of the related release, iteration or build.
TestConfigId : int, allows null: yes
The ID of the test configuration that was used for the test run.
TestSetId : int, allows null: yes
The ID of the related test set.
Agents : nvarchar (max 2000 chars, or 4002 bytes), allows null: yes
Indicates the agent that was used for automated tests.
DateFinished : datetime, allows null: yes
The date and time when the run finished.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateStarted : datetime, allows null: no
The date and time when the run started.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
ExecutionType : nvarchar (max 100 chars, or 202 bytes), allows null: no
The type of the test run.
IsSequential : nvarchar (max 1 char, or 4 bytes), allows null: no
Indicates whether the test must be run in the order specified in the related test set.
NbrAwaitingRun : int, allows null: yes
The number of tests awaiting run.
NbrBlocked : int, allows null: yes
The number of tests that were blocked.
NbrFailed : int, allows null: yes
The number of failed tests.
NbrPassed : int, allows null: yes
The number of passed tests.
NbrTests : int, allows null: yes
The total number of tests in the related test set.
RunByHostId : int, allows null: yes
The ID of the test host used for automated tests.
RunByUserId : int, allows null: no
The ID of the user who performed the run.
RunTime : int, allows null: yes
The time it took to run the test set, in seconds.
ScheduleId : int, allows null: yes
The ID of the schedule that initiated the automated run.
StatusCode : nvarchar (max 100 chars, or 202 bytes), allows null: no
The status of the test run (Passed, Failed, Awaiting Run, and so on).