This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Historical Interface Utilization Report??

I can view a history (last 30 days) of average Recv and Xmit utilization on my WAN interface for a single router, I'm trying to generate a report that will give me this data for all of my WAN routers and I can't figure it out!  I don't want to go through the pain of looking at the chart below on 150 router interfaces manually emoticons_cry.png, but all I'm able to find is current utilization, not historical.  Even trying to create one from scratch, I'm not getting the option for historical utilization on interfaces.  I know this data exists because it's on my summary page for the interface!  Can anyone help?

9-12-2012 1-01-44 PM.jpg

  • cfry,

    Probably the easiest way to generate a report like that would be to use custom properties to help you filter the interfaces you want included in the report.  It will take a little bit of work to get the custom property assigned to the appropriate interfaces but once you have that set up, that should get you the report you want. Custom properties can be assigned to nodes, interfaces or volumes.  There are several predefined properties that you can utilize or you have the ability to create your own from scratch.

    custom properties.JPG

    On your Orion server, go to your start button | All Programs | SolarWinds Orion | Grouping and Access Control | Custom Property Editor. When the custom property editor opens, you can click the Edit Interfaces option. This will list all of the interfaces in your NPM inventory.  In my example, I used one of the default custom properties "Comments" and assigned a property called WAN. 


    Once you have the custom property assigned to the appropriate WAN interfaces, you can use that custom property in report writer to filter the interfaces included in the report.  One of the out of the box reports under Historical Traffic Reports is Average and Peak Traffic Rates - Last Month.  As you probably already know, that included every interface in your inventory.  With the WAN custom property assigned to your WAN interfaces, you can now edit this report to only include the interfaces where the Comments custom property equals WAN.  Open the report in report writer and click the Filter Results tab.  Click the box with the three periods in it and select "Add a new elementary condition."  Click the first asterisk and select Interfaces | Custom Properties | Comments (or whatever custom property you set up.) Click the second asterisk and type in the value that's equal to your custom property you assigned to your WAN interfaces (in my example, WAN.) 

    custom properties.JPG

    With that filter applied, if you preview the report you should only see the interfaces which have the custom property assigned.

    custom properties.JPG

    If you opened the default report, you can now select File and Save As to save this as a new report.  Hope this helps!

  • Thank you for responding!  I actually have done exactly what you suggested, but the problem is that this doesn't give me the 95th percentile average utilization in percentage...emoticons_confused.png