1 of 1 people found this helpful
There's actually a table in the database called dbo.EventTypes that enumerates this data for you:
SELECT EventType, Name FROM dbo.EventTypes
You can also tie the enumerated name into event reports as such:
SELECT CONVERT(CHAR(24),e.EventTime,113) 'Event Time' ,n.Caption 'Node' ,t.Name 'Event Type' ,e.Message FROM dbo.Events e JOIN dbo.EventTypes t ON e.EventType = t.EventType JOIN NodesData n ON n.NodeID = e.NetworkNode --You could optionally add limitations here as well such as: --Only events in the last 1 day --WHERE e.EventTime > (GetDate()-1) --Only Node Down and Node Up Events --WHERE e.EventType IN ('1','5') --Lastly, we sort by the newest events first ORDER BY e.EventTime DESC
Which would look like this:
Loop1 Systems: SolarWinds Training and Professional Services
Thank you! I was able to get exactly what I was looking for.