My requirement is in the Title. The goal is to let the lead Engineer see when his interfaces are at their lowest so he can apply IOS upgrades. If he can see them all in one bunch, he might synergize from that. I hate that word but nothing comes to mind.
I'm doing a SQL query hitting the InterfaceTrafficHourly. These tables have the date as a suffix to the name, so one days' statistics are in these tables. The hourly table does have 24 entries per node it or interface. At first I was seeing only one entry per interface, that was the view in the Preview area. My bad. Also, it appears these tables don't get updated until 30 days have past.
So, my big question is: where is today's stats being stored for an interface by hour? inBPS and outBPS Which table is that? It isn't InterfaceTraffic_Statistics_Daily. This has three timeframes in it with percentages. I need this mysterious table.
