Hey Guys I need a script for a report in the web console for triggered alerts based on severity...specifically Informational...I think the code is 0 (zero)
The SQL view: dbo.AlertHistoryView would be a good start
SELECT * FROM dbo.AlertHistoryView WHERE Severity = 0
BINGO! Appreciate it Zack.
(bonus, any way to have the IP's listed in the data columns?)
probably; something like this should work:SELECT a.*, n.IP_AddressFROM dbo.AlertHistoryView a
JOIN Nodes n ON n.NodeID = a.RelatedNodeID
WHERE Severity = 0
No dice on this one but the first line worked. Ill go with that one. Appreciate it.
