I am looking to create a report that gives the following information per Interface for a given set of devices over a two week period.
MaxAvgRecbps, MaxAvgTXbps, PeakRecbps. PeakTXbps. MaxRec%Util, MaxTX%Util and the time when the peaks and Maxs were reached.
I am having trouble wrapping my head around the best way to do this. I am pretty sure there is no way to do it with the built in report writer however I think creating 6 different selects and using joins to make them one table may be the best way to do it. Not sure....
Any insight or help on this would be much appreciated. This is a time sensitive matter.