-
Re: Alerting report
mark wiggans Oct 28, 2008 5:27 PM (in response to BXIV)This one is sort of similar- Maybe you could tweak it to serve your needs...
Active Alerts for Advanced Alerts - replace "All triggered alerts" on summary
-
Re: Alerting report
BXIV Oct 31, 2008 10:43 AM (in response to mark wiggans)I looked at that and only see that it does current alerts, I need a history for the alerts.-
Re: Alerting report
BXIV Oct 31, 2008 10:44 AM (in response to BXIV)Currently I have this :
Select AlertLog.MsgID as 'Incident ID',AlertLog.LogDateTime, AlertLog.ObjectID,AlertLog.ObjectName,AlertLog.Message
From AlertLog,Nodes,Events
WHERE AlertLog.ActionType != 'EMail' and AlertLog.ObjectType = 'Node' and AlertLog.ObjectID = Nodes.NodeID and AlertLog.MsgID like '%'
order by AlertLog.LogDateTime-
Re: Alerting report
BXIV Oct 31, 2008 3:57 PM (in response to BXIV)Got it!
Select distinct top 60 AlertLog.MsgID,AlertLog.LogDateTime, AlertLog.ObjectID,AlertLog.ObjectName,AlertLog.Message
From AlertLog,Nodes
WHERE AlertLog.ActionType = 'EMail' and AlertLog.ObjectType = 'Node' and AlertLog.ObjectID = Nodes.NodeID and AlertLog.MsgID like '%'
order by AlertLog.LogDateTime DESCChange the 60 if you want more alert history to show up on the report.
-
Re: Alerting report
njoylifJan 22, 2014 1:24 PM (in response to BXIV)
I'd like to take it a step further by getting a report that has the message in it...i.e. if it is a windows event log alert -> provide that message...
anyone done this?
-
-
-
-