We need to create an report of Weekly Top 2 Interfaces with High Network Utilization of our Network. We are having several sites. The scenario is explained as below:
a) Site A - 10 Switches
b) Site B - 20 Switches
c) Site C - 5 Switches.
We need to first get the top utilized interface per site Then out of that Interfaces only Top 2 Interfaces need to be listed in the Report. Could you please assist us in the sql query to get such an output.