Interface report

Question

Hi,

I´m looking for a SQL report to show me all interfaces with 95% usage during 30 minutes (last 30 days).

Thanks.

mharvey · Accepted Answer

Give this a try: Select Nodes.Caption as Node, Interfaces.Caption as Port, (InterfaceTraffic.In_Averagebps/Interfaces.InterfaceSpeed * 100) as Percent_In, (InterfaceTraffic.Out_Averagebps/Interfaces.InterfaceSpeed * 100) as Percent_Out From Interfaces JOIN Nodes on Interfaces.NodeID = Nodes.NodeID Join InterfaceTraffic on Interfaces.InterfaceID = InterfaceTraffic.InterfaceID Where ((InterfaceTraffic.In_Averagebps/Interfaces.InterfaceSpeed * 100) > 95 OR (InterfaceTraffic.Out_Averagebps/Interfaces.InterfaceSpeed * 100) > 95) AND InterfaceTraffic.DateTime < DateADD(mi, -30, Current_TimeStamp) AND Interfaces.InterfaceSpeed <> 0 Regards, Matthew Harvey Senior Sales Engineer Loop1 Systems