SQL queries for network statistics

Discussion created by mfournier on Nov 18, 2011
Latest reply on Nov 22, 2011 by ntimm



We are in the process of writing up a network based report that we can generate automatically via iReport each month.  The report should be able to include monthly averages for bandwidth utilization, error packets, and discarded packets.  We would also like to be able to pull top 10 interfaces by each of these statistics.  We have configured this for CPU, memory, and disk without issue, however interface statistics seem to be written much differently, spread across multiple tables and linked by table IDs. 


Does anyone have something like this in place today, or would know of a good direction to take?  The report tab in Dynamic Views in the UMP does a pretty good job of this, but only for individual systems/interfaces, no top 10, and is not easily exportable.  Any assistance would be greatly appreciated.