AutomationRuns Table

Applies to QAComplete 12.80 SaaS, last modified on April 20, 2021

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.

See Also

AutomationRuns View
Legacy Test Management

Highlight search results