Beyond that, no other changes are necessary, our query can be copied and pasted into the Custom SQL UI in the Web Based Report Writer and you can then configure your report columns as desired to achieve the finished result.
Here is a complete query which returns "Top 10 Interfaces by Transmit bps for the last 7 days, during business hours."
SELECT TOP 10 Nodes.NodeID AS NodeID, Interfaces.InterfaceID AS InterfaceID, Nodes.Caption AS NodeName, Nodes.VendorIcon AS Vendor_Icon, Interfaces.Caption AS Interface_Caption, Interfaces.InterfaceIcon AS Interface_Icon, AVG(InterfaceTraffic.In_Averagebps) AS AVERAGE_of_Average_Receive_bps, AVG(InterfaceTraffic.Out_Averagebps) AS AVERAGE_of_Average_Transmit_bps
FROM (Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)) INNER JOIN InterfaceTraffic ON (Interfaces.InterfaceID = InterfaceTraffic.InterfaceID AND InterfaceTraffic.NodeID = Nodes.NodeID)
WHERE ( DateTime BETWEEN (DateAdd(dd,-7,GetDate())) AND GetDate()) AND ( (DATEPART(weekday, DateTime) >= 2) AND (DATEPART(weekday, DateTime) <= 6) AND (DatePart(Hour,DateTime) >= 7) AND (DatePart(Hour,DateTime) <= 18) )
GROUP BY Nodes.NodeID, Interfaces.InterfaceID, Nodes.Caption, Nodes.VendorIcon, Interfaces.Caption, Interfaces.InterfaceIcon
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.