6 Replies Latest reply on May 8, 2015 8:54 AM by professionalusername

    Using Report writer for SQL Query error

    mukesh1979

      Hi Guys,

       

      Please help. I am new to Report Writer and SQL syntax.

       

      When I try to run the query I get an error as SQL Error:Invalid Object Name"NetflowApplicationSummary"

       

      SELECT TOP 100
      NetflowApplicationSummary.AppName AS Application_Name,
      NetflowApplicationSummary.Port AS Port_Number,
      Nodes.Caption AS NodeName,
      SUM(NetflowApplicationSummary.TotalBytes) AS SUM_of_Bytes_Transferred,
      NetflowApplicationSummary.Protocol AS Protocol_Number,
      Nodes.NodeID AS NodeID

      FROM
      NetflowApplicationSummary INNER JOIN Nodes ON (NetflowApplicationSummary.NodeID = Nodes.NodeID)


      WHERE
      ( DateTime BETWEEN 40120.5 AND 40121.5416666667 )

      GROUP BY NetflowApplicationSummary.AppName, NetflowApplicationSummary.Port, Nodes.Caption, NetflowApplicationSummary.Protocol, Nodes.NodeID


      ORDER BY 4 DESC