Description
The table stores the run history of tests created in Test Automation. The run history of tests created in the new Test Management module is stored in the TestRuns table.
Columns
The table contains the following columns:
AutomationRunId : int, primary key, allows null: no
The unique numeric identifier of the automation run.
AutomationHostId : int, allows null: no
The ID of the automation host related to the automation run.
ProjId : int, allows null: no
The ID of the project that contains the automation run.
AutomationTestItemId : int, allows null: yes
The ID of the related automation test.
AutomationType : nvarchar (max 255 chars, or 512 bytes), allows null: yes
The automation tool that generated the run (TestComplete or QTP).
CreateUserId : int, allows null: no
The ID of the user who generated the run.
DateCreated : datetime, allows null: no
The date and time the item was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: no
The date and time the item was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DurationInSecs : int, allows null: no
The duration of the automation run, in seconds.
EndTime : datetime, allows null: no
The time the run completed.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
FileId : int, allows null: no
The ID of the test log file.
FullTestName : nvarchar (max), allows null: no
The full name of the related test.
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 number of individual tests in the run.
StartTime : datetime, allows null: no
The time the run started.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
Status : varchar (max 100 chars), allows null: no
The status of the automation run.
UpdateUserId : int, allows null: no
The ID of the user who last updated the run.