This database will contain the history for individual Alert, Queues, Classes and Escalation records.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| datetime | integer | not null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when an Escalation policy record is altered. |
| id | varchar(50) | not null | 50 chars, text field, read only access. This is the ID of the Alert record that this History record is for. The ID is unique in the Alert database, but not in the History database as multiple History records will exist for each Alert. |
| text | varchar(1024) | with null | 1024 chars, text field, read only access. The Level 1 API uses this field to describe the event that caused the History record to be generated. History records are generated when an Alert is created, modified, and/or closed. |
| username | varchar(60) | with null | 60 chars, text field. The Level 1 API sets this field to the ID of the user who created, modified or closed the Alert that this History record is linked to. AMSDMN will be the USER for implicit history entries. |
| column_name | varchar(50) | with null | 50-char read only access. The Level 1 API sets this field to the column_name, which got modified, when an Escalation policy record is altered. |
| previous_value | varchar(1024) | with null | 1024-char read only access. The Level 1 API sets this field to the column previous value, which got modified, when an Escalation policy record is altered. |
| current_value | varchar(1024) | with null | 1024-char read only access. The Level 1 API sets this field to the column current value, which got modified, when an Escalation policy record is altered. |
Product Name: Unicenter Network and System Management/Alert Management
Table Type: Table