cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Custom SQL Report for Alerts by severity

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)

0 Kudos
6 Replies
Level 15

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?)

0 Kudos

probably; something like this should work:

SELECT a.*, n.IP_Address
FROM 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.

0 Kudos

Try:

SELECT *

FROM dbo.AlertHistoryView a

JOIN Nodes n ON n.NodeID = a.RelatedNodeID

WHERE a.Severity = 0

That will give you all the fields

- David Smith

Actually this worked ...Thanks

0 Kudos