lchance posted on Wed, Jun 17 2009 9:58 AM

rated by 0 users

I'm attempting to build a report on Endpoints Bytes Transmitted, but when I enable this field BYTES TRANSFERRED the entire reports comes up empty/null.

Point of interest here: I see tables for NetFlowSummary1, NetFlowSummary2 and NetFlowSummary3 but I do not see just a NetFlowSummary - would this make any difference when the SQL codes shows just the name of NetFlowSummary.

 Here's the SQL part of it:

SELECT  TOP 10000 Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate,
FlowCorrelation_Source_FlowCorrelation.IPAddress AS IP_Address,
FlowCorrelation_Source_FlowCorrelation.FullHostname AS Full_Hostname,
SUM(NetflowSummary.TotalBytes) AS SUM_of_Bytes_Transferred

FROM
(NetflowSummary LEFT OUTER JOIN FlowCorrelation FlowCorrelation_Dest_FlowCorrelation ON (NetflowSummary.DestIPSort = FlowCorrelation_Dest_FlowCorrelation.IPAddressSort))  INNER JOIN FlowCorrelation FlowCorrelation_Source_FlowCorrelation ON (FlowCorrelation_Dest_FlowCorrelation.IPAddressSort = FlowCorrelation_Source_FlowCorrelation.IPAddressSort AND NetflowSummary.SourceIPSort = FlowCorrelation_Source_FlowCorrelation.IPAddressSort)

WHERE
( DateTime BETWEEN 39978.4065509259 AND 39979.4166666667 )
 AND 
(
  (FlowCorrelation_Source_FlowCorrelation.FullHostname LIKE 'florida%') AND
  (FlowCorrelation_Dest_FlowCorrelation.FullHostname LIKE 'florida%')
)

GROUP BY Convert(DateTime,Floor(Cast((DateTime) as Float)),0),
FlowCorrelation_Source_FlowCorrelation.IPAddress, FlowCorrelation_Source_FlowCorrelation.FullHostname

ORDER BY SummaryDate ASC, 3 ASC