Comments
-
it works. I check and confirm after 24h.
-
Thanks brother, I did adjust it for my convenient. Could you adjust my code for last 24 hours?. It does not show yesterday's down nodes. so i need to count the last 24 hours from max(e.eventtype=1). select count(n.caption) as [Down Count], n.caption as Name,n.ip as IP from Orion.Nodes N join Orion.Events E on E.NetObjectID…
-
Thanks.
-
Brother, can you give me simple query to view the total down time from last node down and last node down time?.