Description
The TestRuns view contains a detailed history of test set runs.
Dependencies
Columns
Agents : nvarchar (max 2000 chars, or 4002 bytes), allows null: yes
Indicates the agent that was used for automated tests.
ConfigurationName : nvarchar (max 255 chars, or 512 bytes), allows null: no
The name of the test configuration.
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.
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.
ReleaseName : nvarchar (max 815 chars, or 1632 bytes), allows null: yes
The full name of the related release, iteration, or build.
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.
RunByUserName : varchar (max 78 chars), allows null: no
An alias for the PersonName column of the Persons view.
The name of the user, in the Last name, First name format.
RunTime : int, allows null: yes
The time it took to run the test set, in seconds.
RunTimeFormated : varchar (max 100 chars), allows null: yes
The time it took to run the test set, in the hh:mm:ss format.
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).
TestConfigId : int, allows null: yes
The ID of the test configuration that was used for the test run.
TestHost : nvarchar (max 100 chars, or 202 bytes), allows null: no
An alias for the HostName column of the TestHosts table.
The name of the test host.
TestRunId : int, allows null: no
The unique numeric identifier of the item.
TestSetId : int, allows null: yes
The ID of the related test set.
TestSetName : nvarchar (max 255 chars, or 512 bytes), allows null: no
An alias for the Title column of the TestSets table.
The title of the test set.