KBI 310951 New Feature: Find Out Alert Firing Status In Argent AT
Version
Argent Advanced Technology 3.1A-1404-T3 or earlier
Date
Wednesday, 4 June 2014
Summary
Argent AT 3.1A-1404-T3 has been enhanced to log firing status of each Alert in SQL table ARGSOFT_AAC_ALERTS_FIRED
Global System View provides a quick search screen to display the audit information
Customer can use context menu to show detail of selected Alert in notepad
Customer can also use Argent Reports or other reporting tools to directly query this SQL table with customized filter
The table structure is defined as follows:
Column | Type | Description |
UUID | varchar (36) | Primary key |
EVENT_UUID | varchar (36) | Matches the UUID in AAC_CONSOLE |
ALERT_STATUS | int | 1: Fired Successfully
2: Failed to Fire If failed, see ALERT_ERROR_TXT field |
ALERT_FIRE_TIME | datetime | Date/time of fired Alert |
ALERT_NAME_VC256 | nvarchar(256) | Alert definition name |
ALERT_TYPE_VC256 | nvarchar(256) | Type of Alert Email Alert, System Command Alert, Etc. |
ALERT_ENGINE_VC256 | nvarchar(256) | Alert Engine
(e .g. Motor Name, Alert Executor Name, Etc.) |
ALERT_TO_VC256 | nvarchar(256) | Optional Alert ‘To’ * |
ALERT_BODY_TXT | ntext | Optional Alert ‘Body’ * |
ALERT_ERROR_TXT | ntext | If Alert failed, the error message, e.g.: 5.2.2 SMTP Server rejected host |
Technical Background
N/A
Resolution
Upgrade to Argent Advanced Technology 3.1A-1404-T3 or later