I'm using this simple query, hoping to find out the daily max usage of any given device in the network.
I'm going by this PDF: www.cisco.com/.../routerperformance.pdf as a reference for estimated packets per second and Mbps.
The returned PPS and my perceived performance don't seem to match up.
What I'm trying to do is add up the InBps, OutBps, packets per second, packet sizes, etc, and add all of the interfaces on the device for a general "Throughput" report.
One of my problems here is that I can't seem to find a database field for a peak packets per second in a day, even in InterfaceTraffic.
This report is named "Capacity Report" and I'm afraid it's not completely accurate enough to make upgrade assessments.
Can I ask someone to create a custom orion sql report and run this query and see if it adds up to what they think it should look like?
select i.NodeID, n.Caption, ROUND(SUM(InPps + OutPps),0) as TotalPps, ROUND(SUM(InPktSize+ OutPktSize),0) AS TotalPktSize, ROUND(SUM(MaxInBpsToday + MaxOutBpsToday),0) AS TotalMaxBpsToday, ROUND(SUM(InDiscardsToday + InErrorsToday + OutDiscardsToday + OutErrorsToday),0) AS TotalErrors
FROM Interfaces i
INNER JOIN Nodes n
ON i.NodeID = n.NodeID
WHERE i.InterfaceSpeed != 0
GROUP BY i.NodeID,n.Caption
