2 Replies Latest reply on Nov 24, 2008 3:32 PM by rdmott

    Last Boot / Report Writer

      I am creating a report with the last boot time of servers.  Would also like to add a column which shows that the time since the last boot.  It's a bit of redundancy here, but will make the customer happy.  One column shows a reboot of 31 Oct 08 at 08:00AM.  I'd like the next column to show how many days/hours since that last reboot. 


       SolarWinds says that this is an advanced SQL report that needs to be done.  I'm a network guy and not a DBA. Any guys out there with some possible help on this?


      Here's what I currently have:


      SELECT  TOP 10000 Nodes.IP_Address AS IP_Address,
      Nodes.LastBoot AS Last_Boot


      FROM
      Nodes



      WHERE 
      (
        (Nodes.Vendor = 'Microsoft')
      )


       


      ORDER BY 1 ASC