I'd like to run a report which will display %Utilization for circuits running over 90% in the past few days. In the same report i would also like to to know when (date/time) the circuit was running over 90% in the past 7 days.
You could setup a new historical interface traffic report something like this:
This will show all that were over 90% tx or rx in past 7 days summarized by the hour.
Can i filter the results to only show the nodes between 7 am - 6 pm instead of entire day for the past 7 days.
Sure you can by adding some additional filters... this is a pic from another post but fits the kind of time or day filter that you would also want to add to the report... use the Day or Week or Time of Day part of the filter... it takes a little practice but the more you work with report writer the easier it gets. It's not perfect and you can't do everything in report writer but it's improved much over the years.
One of the fields selected is the Rec Percent Utilization and i am using an Average function. How is it calculated. I would like to get the Average value for the circuit for the entire week but i am getting multiple entries for the nodes for the same day instead of just showing the node once with the Average value.