Return
-
Title
How to delete old alarms from the Foglight database? -
Description
There are a large number of alarms that have been cleared but are still visible in the console and the database, how can these be cleared in the database?
-
Resolution
IMPORTANT:
Before following the workaround below, please make a backup of the Foglight database and installation folder!!!
Workaround:
Run the following script against the database (syntax here is for Oracle):
DELETE FROM ALARM_ALARM WHERE CREATED_TIME < sysdate - 30 DAY;If using MS SQL Server as backend DB repository then the syntax would be:
DELETE FROM alarm_alarm WHERE created_time < GETDATE() - 30