Hello,
Currently we are running weekly and monthly reports showing average bandwidth utilization per interface. Those reports are generated authomatically and are stored as .pdf files.
I was asked if we could use our current MSSQL server, which stores all Netflow data, to run queries against. For example, my manager would like to run a query for a specific device for a specific timeframe. He would like to see what router "A" serial interface S0/0 utilization was for the first week of August, then for the second week, third week and so on. Then he'd like it to possibly being displayed in some form of a file or a spreadsheet or a diagram so he could integrate all the information into a single report.
Is that doable? Are there any MSSQL specific tables that need to be selected for the required information?
thanks a lot!
-Joanna