TestHosts Table

Applies to QAComplete 12.90 SaaS & On-Premises, last modified on September 09, 2021

Description

The table stores hosts that are used in Test Management. The hosts used in Test Automation (legacy) are stored in the AutomationHosts table.

Columns

The table contains the following columns:

Id  :  int, primary key, allows null: no

The unique numeric identifier of the host.

DeptId  :  int, allows null: no

The ID of the department that owns the host.

Agents  :  nvarchar (max 2000 chars, or 4002 bytes), allows null: no

The application used for automation (for example, TestComplete/TestExecute).

CreateUserId  :  int, allows null: no

The ID of the user who initially configured the test host.

Custom1..Custom10  :  nvarchar (max), allows null: yes

The values of custom fields 1 - 10.

These columns correspond to fields that can be available for rich editing.

DateCreated  :  datetime, allows null: no

The date and time when 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 when 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.

Description  :  nvarchar (max), allows null: yes

The description of the test host.

This column corresponds to a field that can be available for rich editing.

HostConfiguration  :  nvarchar (max), allows null: yes

A test configuration associated with the host.

HostName  :  nvarchar (max 100 chars, or 202 bytes), allows null: no

The name of the test host.

IsActive  :  varchar (max 1 char), allows null: no

Indicates whether the host is active.

LastActivityDate  :  datetime, allows null: yes

The column is reserved for system use only.

LastActivityStatus  :  varchar (max 100 chars), allows null: yes

The column is reserved for system use only.

OS  :  nvarchar (max 100 chars, or 202 bytes), allows null: no

The operating system running on the host.

SecurityToken  :  uniqueidentifier, allows null: no

The column is reserved for system use only.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the test host.

See Also

TestHosts View
Test Management

Highlight search results