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