0 Replies Latest reply on Jun 7, 2013 11:54 AM by tberry

    Issue with Report Not Updating

    tberry

      I have a report that we use to see up and down times that was written in report writer. The issue I have is that it will stop updating the information into the report. If I manually run the SQL query I get the blank entries as well. Once I restart the server then it starts working again. Anyone have any ideas why this happens?

       

      The query is:

       

      SELECT

          StartTime.EventTime,

                (SELECT TOP 1

                 EventTime

                 FROM Events AS Endtime WHERE EndTime.EventType = 52 AND (Endtime.EventTime > StartTime.EventTime)),

             Nodes.Caption,

             Nodes.NodeID

       

       

      FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID

      WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N') AND

      eventtime between dateadd(day, -7, getdate()) and getdate()

      ORDER BY EventTime DESC, Nodes.Caption ASC