* Create varying alerting levels for HA events
Within the High Availability settings of NPM there is an option to turn on/off email alerting for three different options, trying to find the right balance of knowing when a poller failed over rather than getting spammed by alerts is tricky.
Maybe change this to different levels rather than three options and put some context behind each level would be helpful. At very least put a timestamp in there rather than relying on the time it lands in your inbox.
Right now i have all three turned on but then have a report that runs this SQL query to tell me when something actually failed all be it yesterday:
SELECT * FROM [dbo].[HA_Audit]
WHERE
(
DT >= dateadd(day,datediff(day,1,GETDATE()),0) AND DT < dateadd(day,datediff(day,0,GETDATE()),0)
)
AND
(
(Msg like '%PoolMaster changed%')
)
Order by DT DESC
