List of Event_Type codes

rarbuckle1892

Hi All,

In report writer there is a column for Event_Type and I have been trying to find a list as to what those codes all correspond to. I can probably figure it out based on the message but I was hoping for an official list I could provide to the report requester. Any idea where such a list would be?

 

Event Time	Node	Event_Type	Message
23:59:00 tt	YYPH03WS309BCAA	507	Component "File Age Monitor" for application "Epic BCA & File Monitor" on node "YYPH03WS309BCAA" is in an unknown state
23:59:00 tt	YYPH03WS309BCAA	505	Application "Epic BCA & File Monitor" on node "YYPH03WS309BCAA" is in an unknown state
23:45:00 tt	n1qr0400recbcaa.ynhh.org	100	IP address of n1qr0400recbcaa.ynhh.org changed from 10.104.13.133 to 10.100.53.113

zackm

Sure thing.

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:

SELECTCONVERT(CHAR(24),e.EventTime,113) 'Event Time',n.Caption 'Node',t.Name 'Event Type',e.MessageFROM dbo.Events eJOIN dbo.EventTypes t ON e.EventType = t.EventTypeJOIN 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 firstORDER BY e.EventTime DESC

Which would look like this:

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems