This is the 'primary' database for AMS and it contains the definition of each individual Alert.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | varchar(50) | not null | 50 chars, text field, read only access. This is the unique identifier for an Alert record and is generated by the Level 1 API. It is also used to link records in the History database with a specific Alert. |
| name | varchar(80) | with null | 80 chars, text field, read/write access. This is the display name of an Alert. Because it does not identify a specific Alert it is not required to be unique. For Alerts generated by Unicenter Events this will be the Category field. |
| description | varchar(4096) | with null | 4096 chars, text field, read/write access. This is a detailed description text for the alert. For Alerts generated by Unicenter Events this is the Message Text field. |
| class | varchar(50) | with null | 50 chars, text field, read/write access. This is the unique ID of the Class this Alert belongs to and it links a record in the Class database with this Alert. The Name from the Class record is displayed to the user, not the ID. For Alerts generated by Unicenter Events this will be the MSGAction text. The Class record contains additional information for this Alert. |
| queue | varchar(50) | with null | 50 chars, text field, read/write access. This is the unique ID of the Queue this Alert currently resides in and it links a record in the Queue database with this Alert. The Name from the Queue record is displayed to the user, not the ID. The Queue record contains additional information for to this Alert. If this field is not specified when the Alert is created, the Level 1 API will use the setting from the Class record as the default. |
| display | varchar(50) | with null | 50 chars, text field, read/write access. This is the unique ID of the Display Attributes for this Alert. The Name from the Attributes record is displayed to the user, not the ID. The Display Attribute record specifies how the text of the Alert is displayed in Smart Console. The record contains settings for blinking, reverse video, underline, strikethrough, bold, italic, foreground color and background color. If this field is not specified when the Alert is created, the Level 1 API will use the setting from the Class record as the default. |
| escalation | varchar(50) | with null | 50 chars, text field, read/write access. This is the unique ID of the Escalation policy that applies to this Alert and it links a record in the Escalation database with this Alert. The Name from the Escalation record is displayed to the user, not the ID. The Escalation record contains additional information for this Alert. If this field is not specified when the Alert is created, the Level 1 API will use the setting from the Class record as the default |
| groupid | varchar(50) | with null | This is a 50-char group-id, indicating a group of alerts. An Alert Class is a group of Alerts with common attributes. Class attributes are used as default values when an Alert is created and attributes specified when the Alert is created will override these values. |
| groupcount | integer | with null | Integer counting the number of entries in a group-id. Group-id is a 50-char field, indicating a group of alerts. An Alert Class is a group of Alerts with common attributes. Class attributes are used as default values when an Alert is created and attributes specified when the Alert is created will override these values. |
| urgency | integer | with null | Integer field, read/write access. This is a relative indicator of how critical the Alert is and is the other factor in determining the Priority of an Alert. An Alert with high Impact and high Urgency has a greater Priority than Alerts with medium Impact and/or Urgency. If this field is not specified when the Alert is created, the Level 1 API will use the setting from the Class record as the default. |
| retention | integer | with null | Integer field, read/write access. The number of days to retain an Alert in the database after it has been closed. The Alert will be written to a file and deleted from the database when the Archive program is run and the retention period has passed. If the retention period is not specified when the Alert record is defined, the default retention period for the Class is used. |
| acknowledged | integer | with null | Boolean field, read/write access. This indicates whether or not an Alert has been acknowledged. |
| active | char(1) | with null | Boolean field, read/write access. A value of TRUE means the Alert is still active. When the Alert is closed Active is set to FALSE, the "Closed" field is set to the current time, and a record is written to the History database. |
| alarmed | integer | with null | 50 chars, text field, read/write access. This is the unique ID of the Alarm policy that applies to this Alert and it links a record in the Alarm database with this Alert. The Name from the Alarm record is displayed to the user, not the ID. The Alarm record contains additional information for this Alert. |
| facility | varchar(12) | with null | 12 chars, text field, read/write access. The facility code of the application creating the Alert condition, for MOM Management Alerts this will be CAMM, and for Unicenter Event Alerts this will be "CAOP". |
| node | varchar(64) | with null | 64 chars, text field, read/write access. This identifies where the event that caused the Alert to be generated occurred. |
| routenode | varchar(64) | with null | 64 chars, text field, this is the administration node for the node where the alert was created. |
| source | varchar(50) | with null | 50 chars, text field, read/write access. For Alerts generated by Unicenter Events this will be the Process Information field. |
| workstation | varchar(64) | with null | WORKSTATION: 64 chars, text field, read/write access. This is the workstation where the Alert was generated. For Alerts generated by Unicenter Events this will be the Workstation field. |
| url | varchar(1024) | with null | 1024 chars, read/write access. URL is a link to a knowledge base article appropriate to the Alert. |
| occurred | integer | with null | Integer field, read/write access. This is when the event that triggered the alert occurred. For Alerts generated by Unicenter Events this will be the Created field. |
| appversion | varchar(8) | with null | APPVERSION: 8 chars, text field, read/write access. This field contains Version information for the Application that created an Alert. |
| appdata1 | varchar(256) | with null | 256 chars, text field, read/write access. |
| appdata2 | varchar(256) | with null | 256 chars, text field, read/write access. |
| appdata3 | varchar(256) | with null | 256 chars, text field, read/write access. |
| appdata4 | varchar(256) | with null | 256 chars, text field, read/write access. |
| appdata5 | varchar(256) | with null | 256 chars, text field, read/write access. |
| udata | varchar(1060) | with null | 1029 chars, text field, read/write access. |
| ticket | varchar(32) | with null | Tvarchar(32): If the alert generated a new helpdesk ticket, this field holds the ticket number |
| transferred | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when an Alert record is transferred and writes a record to the History database. |
| escalated | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when an Alert record is escalated and writes a record to the History database. |
| annotated | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when an Alert record is annotated and writes a record to the History database. |
| created | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when an Alert record is created and writes a record to the History database. |
| modified | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time whenever a field other than "Status" is changed. This field only displays the most recent change, however records are written to the History database whenever a field is changed. |
| closed | integer | with null | ULONG cast of time_t, read only access. The Level 1 API sets this field to the current time when the 'Active' field is set to FALSE and a record is written to the History database. |
| escalating | integer | not null | Escalating integer not null default 0: An internal field used to denote a date/time when an alert will escalate |
| assoccount | integer | not null | Assoccount integer not null default -1: The number of WV repository associations for this alert |
Product Name: Unicenter Network and System Management/Alert Management
Table Type: Table