This content has been marked as final. Show 2 replies
To be clear- you are looking for the last time the node went down?
This should get you pointed in the right direction:
select caption, max(eventtime) as 'last time down', message from nodes join events on nodeid = networknode where eventtype = 1 and status = 2 and (eventtime > (getdate()-1) ) group by caption, message