Report Writer - Down Nodes with Event Time

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?