I am very much a newbie to Solarwinds and Orion. I have been tasked with building a report for to include all of our WAN interfaces that will show receive and transmit bps ever 5 minutes for the last day. We are looking to export this information on a daily basis with the idea of building a dashboard in Tableau to include with other metrics outside of Solarwinds.
I see Average receive and average transmit as well as peak and min, but hoping to take the raw data out to have min/max calculated in the dashboard.
I'm even struggling to match up what somebody has already built on a dashboard, that I can export to csv show up in a similar report fashion.
Any help would be appreciated. Attached is a sample extract from the dashboard for last 7 days, every 15 minutes (I'm just trying to do the last day every 5 minutes) that I would like to replicate in report form within Orion.
Any help would be greatly appreciated.
If you got that data by Exporting a chart to Excel, then just change the chart to Sample Interval to 5 minutes and it will break out the data. The kicker here is default polling interval for interfaces is every 9 minutes, so unless you are polling these specific interfaces every 5 minutes there will not be enough data to fulfill your requirement. Also, make sure your device is configured to show you data on that same timeline. Some devices are not set for a 5-minute interval by default and if you only adjust the polling interval within Orion you may see the same data polled twice. In addition, if you are not already polling all interfaces on a 5-minute interval, only change the interfaces you need this from (edit these specific interfaces to change the polling interval), as a global change from 9 to 5 minutes for Detailed Interface Statistics will almost double your data table size.
Loop1 Systems: SolarWinds Training and Professional Services
Hi. Thanks for your feedback. Just a point of clarification, I don't have a chart built. There is a dashboard that has this information. I don't have access to modify the dashboard and presume there isn't a way to convert to a report. Should I just start by building the details in a chart?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.