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)
Top Replies
-
The SQL view: dbo.AlertHistoryView would be a good start SELECT * FROM dbo.AlertHistoryView WHERE Severity = 0 -
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
-
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
-
-
-
-
-
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
-