alerts.application_types table
The alerts.application_types table contains details about application types that cause connection watch messages to be generated when the applications connect and disconnect. Use this table to configure the severity of connection and disconnection events by application type.
For example, a gateway connection is treated as a resolution (clearing a disconnect), whereas an event list connect is a Type 1 event, which is resolved by a disconnection. A gateway disconnection is treated as a problem, whereas an event list disconnection is a resolution. You can use the alerts.application_types table to configure a gateway to generate a Type 1 event (warning) on disconnection and a Type 2 event (disconnection cleared) on connection, and configure an event list to generate a Type 1 event on connection and a Type 2 event (clear) on disconnection.
The alerts.application_types table is read by the connection_watch_connect and connection_watch_disconnect triggers.
You can add a new application type to this table by adding a row, if required. You can also change the behavior of an application by updating its row.
The following table describes the columns in the alerts.application_types table.
| Column name | Data type | Description |
|---|---|---|
| application | varchar(64) | Primary key for the table. This is the internal application name specified as a regular expression for efficient string matching. |
| description | varchar(64) | Descriptive name for the event. |
| connect_type | int | Event type for the connection. |
| connect_severity | int | Event severity for the connection. |
| disconnect_type | int | Event type for the disconnection. |
| disconnect_severity | int | Event severity for the disconnection. |
| expire_time | int | Number of seconds until the alert is cleared automatically. Used by the Expire automation. |
| discard | Boolean | Set to TRUE if the event is to be suppressed. |