When I was running NPM v11.x, I had some SQL queries to determine (or validate) if there were alerts that had failed to be sent, or to prove that an alert had been "successfully sent" to the exchange system, or just to detect alert storms ( as sometimes NPM 11.x would try to send a lot of alerts to Exchange in a short amount of time, and Exchange would quickly start denying them because NPM attempted to open too many connections to Exchange) .
I had a few queries I ran, like this one for example, to determine if any alerts had failed to be sent via email:
SELECT TOP 1000
[MsgID]
,[LogDateTime]
,[AlertDefID]
,[ObjectType]
,[ObjectID]
,[ObjectName]
,[ActionType]
,[Message]
FROM [SolarWindsOrion].[dbo].[AlertLog]
where message like 'Failed%'
It appears in v12.x that these tables are now empty, and there are new/other alerting tables in place. When I try to put it all together to fix my query, I can't seem to find any table in the database that lets me "validate" the status of alert notifications (email or otherwise) being successfully sent to systems outside of NPM. Maybe now this information goes into logs on the system that sends the alerts?
Does anyone know where I would have to look for this information? If a user asks me "where's my alert I thought I should have gotten at 4:15 AM", It appears with v12 I don't have any way to trace it within NPM to prove it at least made it out of the system, or no alert notification was (purposely) be sent to them at all (also very useful to prove).
