2 Replies Latest reply on Aug 3, 2011 10:20 AM by Andy McBride

    Node uptime in days for specific group... possible?

    jshiv

      All,

      I have found the query below that will show me all nodes and the "days up" for each.  My goal is this report for a specific Orion group and to be able to view this report via the web console.  Help and guidance much appreciated.

      SELECT NodeID, VendorIcon, Caption,MachineType,
      DateDiff(Day,Nodes.LastBoot,GetDate()) AS DaysUp
      FROM Nodes
      ORDER BY 5 DESC

       

      JSHIV