AutomationRuns View

Applies to QAComplete 12.70 SaaS, last modified on January 11, 2021

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.

See Also

AutomationRuns Table
Legacy Test Management

Highlight search results