1 of 1 people found this helpful
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
INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)
(Nodes.Status = '2')
(Events.EventType = 5000) OR
(Events.EventType = 1)
group by Nodes.Caption
ORDER BY 1 DESC
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?