I've been searching through Thwack to see if anyone else has asked this question and gotten an actual response. Obviously I haven't fond any answers, so here I am.
I already have the Errors & Discards widget(s), reports, and even a more custom one I did a few years back, but now I'm being asked to provide the total amount of packets sent or received on any interface and divide the errors or discards by the total to get a percentage.
I know this sounds like some next level advanced stuff here, but apparently SolarWinds can't do it. This question has been asked and feature requests have been published for this very thing all to no avail.
Does anyone have a SQL or SWQL query that can pull that interface errors and discards as a percentage of the total packets sent in any given time period?
Currently the widgets we have do it by 'Last Hour' or by 'Lat Day'. I assume their use of 'Last Day' to represent the last 24 hours. I was going to just add in the additional info into my SQL query, only to find I'm having trouble with the 24 hour sliding window that would follow the same time range used by the existing error and discard widgets and reports.
