Ye, I have stumbled upon same thing quite recently. Check my comments here and Lada's reply. You may need to do some SQLing my friend, unless there is a way to do it easily via GUI in latest 11.5.2 version (I will be upgrading this week, so, don't know yet)
Figured, haven't written SQL queries in years, should be fun...
Thank you Alex..
SELECT AlertLog.LogDateTime, AlertLog.ObjectName , AlertLog.Message, AlertDefinitions.AlertName
on AlertLog.AlertDefID = AlertDefinitions.AlertDefID
WHERE AlertLog.alertdefID ='37d37380-47fe-41d9-8769-180b40b61304' --change alert definition ID to match alert you are interested in.
and AlertLog.Message = 'Alert Triggered'
and AlertLog.LogDateTime between '07/15/2015 12:01 AM' and '07/16/2015 12:01 AM' --change date
Hope this helps, was written for NPM 11.0
Ahh, ye, you are on 11.0 - it is easy then. As per your example above all alert logs are sitting nicely in "AlertLog" table I had to ask you first what version of NPM you are on... In the latest release DB Schema was change and AlertLog table is empty now... Hope in 11.5.2 (as per Lada's reply here) we will get them all back in AlertHistroyView