1 Reply Latest reply on Nov 3, 2008 4:44 PM by lasher

    Reboot Report Help

      I was wondering if someone can help me with a SQL report. I'm trying to write a report that shows Pc's that Didn't reboot the previous night. I can get the report to show what PC's that didn't reboot using a specific date, I'd like to use the expression 'current date' so I can have the report automatically email our help desk folks.


       Shawn Waldman

        • Re: Reboot Report Help

          You could try something like this in an Advanced SQL report.


          SELECT  Nodes.Caption AS NodeName, Nodes.LastBoot AS Last_Boot
          FROM
          Nodes
          WHERE
          CONVERT(VARCHAR(10),Nodes.LastBoot,101) <> CONVERT(VARCHAR(10),getdate(),101)


           


          That should be a good starting point.