Generating specific reports using MSSQL

Generating specific reports using MSSQL

 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 

 

                New to ADSelfService Plus?