This table is typically used by Unicenter Asset Management. Templates are user-defined questionnaires, which can be modified by the Agents and returned to the database as regular inventory data. When a template is defined in the system, it is given a display title and a user-supplied description. Each template definition is identified by its unique DOMAINID and TPID values. The TPNAME is the display name of the template, while the TPFNAME is the filename to which the Agent will return the template inventory information. The TPVER contains a version number of the template. Each time it is modified, the version field is incremented. TPUSERID contains the Admin Console User ID (USERSEC table) of the User who created/last modified the template.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| tpid | integer | not null | Unique Template ID |
| domainid | integer | not null | Domain ID |
| tpname | nvarchar(64) | with null | Display name of template |
| tpfname | nvarchar(64) | with null | Filename of template |
| tpver | integer | with null | Revision |
| tpuserid | integer | with null | User who created template. Not Used. |
| tpdesc | nvarchar(15000) | with null | Description |
| auto_server_version | integer | with null | Object Version. Automatically maintained by Ingres Rule. |
| auto_rep_version | date | with null | Replication version |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| tpid domainid |
tplmemo | tpid domainid |