Top 10 Flapping Routes

mjonathan

Greetings to the community,

Where can I find the data in the database for the flap field generated by the Top 10 Flapping Routes widget?

I was looking at the Orion.Routing.RoutingTableFlap table, and it doesn't show the flaps, just a FlapID.

In what other table could this Flap field be referenced? Thank you for your collaboration.

ahawkins72

Hey @mjonathan 

I may be on a different version than you, as I don't have that widget.  I peeked around and couldn't seem to find the table either.  What you CAN do, is enable Hubble.  (This is done via Log Adjuster on your Platform server)  When Hubble is active, you can load the page with the widget in question, and it will display the queries being executed on the back end for that page.  (as well as the query time, if you're into that).  I have used that to reverse engineer a lot of widgets in the past.  It can still take a couple of minutes to parse through all the noise, but you should be able to find it.  Usually closer to the bottom of the Hubble report in my experience.  Hope this helps!