Historical Report for Interfaces with High Percent Utlization

Hi All,

I am trying to create a report for list of interfaces with High Percent Utilization. Currently it is scheduled to run multiple times in a day however I want a single report which runs everyday just once which can bring historical data for the interfaces. For eg. The report runs on Monday morning 9 AM and brings list of interfaces which were having high percent utilization yesterday at 1 PM. Any help would be appreciatedl

Find more posts tagged with

Accepted answers

All comments

taylor.crowley

I think you may find this article very useful - thwack.solarwinds.com/.../detailed-historical-interface-utilization-report

SumitPatil

Thanks @taylor.crowley. I went through the above however it doesn't fulfill my requirement. All I am looking for is a query to show me the list of interfaces with high percent utilization at specific time yesterday.

taylor.crowley

Apologies if I misunderstood your request

on our website we actually have an article about how to define time ranges within reports

you can find that here - https://prosperon.co.uk/insights/how-use-time-filters-solarwinds-reports/

Please let me know if this helps

SumitPatil

I had tried the above earlier, but it tries to return data for the entire 24 hrs timeframe. It doesn't provide me with a specific time period. To simplify, I am trying to build a query that sounds like "select all interfaces from XYZ table where in percent or out percent utilization is above 80% and DateTime is yesterday 2 AM"