Resetting Alerts and Test Result Evaluations in Mailscape Database

Overview:
Occasionally, the Alerts table in the Mailscape database may enter a "bad state" resulting in multiple alerts for the same alert category/server combination. If this occurs, you can reset all alerts and re-evaluate data models by performing the steps below.

Symptoms:

• Multiple alerts firing for identical alert category/server combinations
• Alert actions not behaving as expected in Mailscape monitoring

Resolution Steps:

1. Access the Mailscape Database:
   Use SQL Server Management Studio (SSMS) or your preferred SQL query tool to connect to the Mailscape database.
2. Run the Following SQL Commands:
   This process will clear the evaluation and alert tables:

sqlTRUNCATE TABLE [dbo].[TestResultEvaluations]
DELETE FROM [dbo].[Alerts]

• TRUNCATE TABLE on [TestResultEvaluations] removes all rows, resetting evaluation data.
• DELETE FROM on [Alerts] removes all current alerts from the system.

1. What Happens Next:
   • All current alerts will be reset.
   • The system will re-evaluate all models—if any items qualify for alerts after the reset, new alerts will be generated.