7 Replies Latest reply on Mar 7, 2017 3:18 PM by tdanner

    Creating a last 24hr reboot noc view

    timt

      Hi,

       

      When I run this query, I get a different time as to the actual lastboot time, but when I checked the message center for last reboot event time, it is correct.  Any ideas, or does anyone have any recommended query to create a Node Last Reboot in 24 hours?


      Thank you!

       

       

       

      SELECT e.Nodes.Caption, EventTime as RebootTime

      FROM Orion.Events e

      where eventtype = 14

      and HOURDIFF(eventtime, GETUTCDATE()) < 24

      order by eventtime desc