I've been asked to generate a report for NetFlow data, that will pull info for devices between the 16th of Month A to the 15th of Month B.
They'd like to also see weekly reports, finishing with a month end report.
This is the SQL commands for the data I am working with... the example below shows a 30 day interval, but I am not sure how it comes up with the numbers.
SELECT TOP 10000 FlowCorrelation.FullHostname AS Full_Hostname,
FlowCorrelation.IPAddress AS IP_Address,
Nodes.Caption AS NodeName,
SUM(NetflowEndpointsSummary.TotalBytesDst) AS SUM_of_Bytes_Transferred_Rx,
SUM(NetflowEndpointsSummary.TotalBytesSrc) AS SUM_of_Bytes_Transferred_Tx,
SUM(NetflowEndpointsSummary.TotalBytes) AS SUM_of_Bytes_Transferred_Total,
Nodes.NodeID AS NodeID
FROM
(NetflowEndpointsSummary LEFT OUTER JOIN FlowCorrelation ON (NetflowEndpointsSummary.IPSort = FlowCorrelation.IPAddressSort)) INNER JOIN Nodes ON (NetflowEndpointsSummary.NodeID = Nodes.NodeID)
WHERE
( DateTime BETWEEN 41553 AND 41584 )
AND
(
(FlowCorrelation.FullHostname LIKE '%mycingular.net%')
)
AND
(
(EXISTS(SELECT 1 FROM NetFlowSources WITH(nolock) WHERE NetFlowSources.InterfaceID=InterfaceID AND NetFlowSources.Enabled=1))
)
GROUP BY FlowCorrelation.FullHostname, FlowCorrelation.IPAddress, Nodes.Caption, Nodes.NodeID
ORDER BY 6 DESC