This report shows some WAN ckts > 45% use for a 5 min period. See pic. I have that working, but want to make it more readable by either doing a COUNT on the number of times the >45% hits or rolling those results into a link for the serial interface (some have hundreds of rows) or just showing the top 10 hits for a given interface.
Any thoughts. I'm pretty new at SQL, but pick things up quickly. I just can't find any examples of how to do this with the nested selects or inner joins... THANKS!
Hi i hope this meets your requirements
http://thwack.com/files/folders/orion_custom_reports/entry36603.aspx