Netflow Reporting for data usage

Hello Pvaldes, How frequently do you want to run the report?

In the interim the short answer is:  “Not at this time”, we don't know of any 3^rd party tool that would do what you are looking for.

Long-ish answer: After talking with a few folks over here perhaps the best solution for you would be to create a SQL job that runs every hour to grab the data for you that can then run a report on OR look at modifying the “top 100 conversations including applications” report. By default that report uses data from the summary tables, it is possible to modify the SQL view dbo.NetflowSummary so that it will also return the detailed data. This data is used only for reports so it wont impact anything else. The impact on the SQL DB performance could be significant, but only at the time when the report is being generated.

Hope that helps,

-Jacob

Hi,

Thanks for the reply...

Any chance of someone showing me how to setup a SQL script to getting a report generated from netflow that will look like the attached PDF report?

5 columns

Internal Address (Inside Local NAT Address) | Date | Download | Upload | TOTAL (Download/Upload)