While logging alerts we want to store the Alert Duration (CLEARED_TIMESTAMP - ACTIVE_TIMESTAMP) etc in the same table ie. ALERT_LOG.
1.Can we add more custom columns to the ALERT_LOG table.
2 Can we write some expressions while the alert is logged to update custom columns in this table.
One way is to use Triggers on the MSSQL Server side (our database) but that may adversely effect performance as the alert rate is very high.