Description
Contains detailed information on automation runs.
Dependencies
Columns
AutomationHostId : int, allows null: no
The ID of the automation host related to the automation run.
AutomationRunId : int, allows null: no
The unique numeric identifier of 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).
CreatedBy : varchar (max 52 chars), allows null: no
The name of the user who generated the run.
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.
HostName : nvarchar (max), allows null: no
The name of the automation host.
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.
ParentTest : nvarchar (max), allows null: yes
The name of the parent test.
ProjId : int, allows null: no
The ID of the project that contains the automation 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.
TestName : nvarchar (max), allows null: yes
The name of the related test.
TestType : varchar (max 13 chars), allows null: yes
The type of the test (Project Suite, Test Project, or QTP Test).
UpdatedBy : varchar (max 52 chars), allows null: no
The name of the user who last updated the run.
UpdateUserId : int, allows null: no
The ID of the user who last updated the run.