Report Writer - Down Nodes with Event Time

Is it possible to create a report that generates currently down nodes with its event time.

Ex.

Node Name Event Time

Device_A 22-April-2009 11:45:06 AM

Thanks!

Find more posts tagged with

down_interfaces

event_time

report

Accepted answers

Thanks JP,

This is what I needed.

Thank you very much for your help.

All comments

I suppose you already asked this in another thread, but a custom sql report that you wrote w/ the MAX included will do this for you

SELECT max(Events.EventTime) AS Event_Time, Nodes.Caption AS NodeName
FROM Nodes
INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)

WHERE
(Nodes.Status = '2')
AND

(
(Events.EventType = 5000) OR
(Events.EventType = 1)
)

group by Nodes.Caption
ORDER BY 1 DESC

Thanks JP,

This is what I needed.

Thank you very much for your help.

I am doing this as well, however can you help with getting the right Events.Message to display properly also?

Quick Links