Description
Contains detailed information on test hosts.
Dependencies
Columns
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 Text Feature.
Custom11..Custom90 : varchar (max 100 chars), allows null: yes
The values of custom fields 11 through 90.
DateOpened : datetime, allows null: no
An alias for the DateCreated column of the TestHosts table.
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.
DeptId : int, allows null: no
The ID of the department that owns the host.
Description : nvarchar (max), allows null: yes
The description of the test host.
This column corresponds to a field that can be available for Rich Text Feature.
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.
Id : int, allows null: no
The unique numeric identifier of the 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.
NbrFiles : int, allows null: yes
The number of files attached to the associated item.
NbrNotes : int, allows null: yes
The number of notes attached to the associated item.
NbrTimesRun : int, allows null: yes
The number of tests that have been run on the test host.
NotesDescription : varchar (max), allows null: yes
An alias for the LatestNotes column of the ExtendedAttributes table.
A description of the latest note attached to the associated item.
OpenedByName : varchar (max 78 chars), allows null: yes
The name of the user who added the associated item, in the Last name, First name format.
OS : nvarchar (max 100 chars, or 202 bytes), allows null: no
The operating system running on the host.
RunByHostId : int, allows null: yes
The ID of the test host used for automated tests.
SecurityToken : uniqueidentifier, allows null: no
The column is reserved for system use only.
TestRunItemId : int, allows null: no
The unique numeric identifier of the test run item.
Title : nvarchar (max 2206 chars, or 4414 bytes), allows null: no
The title of the host, in the “<Host name> - <Operation system> - <Test Agent>” format.
UpdateUserId : int, allows null: no
The ID of the user who last updated the test host.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the associated item, in the Last name, First name format.