Skip navigation
1451 Views 2 Replies Latest reply: Mar 15, 2012 3:37 PM by jarredm RSS
jarredm Rank: White Belt 7 posts since
Jan 15, 2011
Currently Being Moderated

Mar 12, 2012 11:10 AM

CSV Data Extraction

I'm using zenoss to monitor edge switches at my WAN locations.  Beyond knowing if the thing goes down I really need to be able to keep the bandwidth utilization data. This way if we need to change providers in the future I will have a good record of how much each site is actually using.  I know I can see the information in the graphs but I really need the data behind the graph so I can calculate 95th percentile, averages and standard devs.


Also if I want to increase the resolution of the graphs can I simply shorten the time between polling periods?  I believe that the throughput is calculated based on the deltas of interface rx/tx octets taking into account the time since last poll.  Is there any reason I shouldn't poll more often?

  • dpetzel Rank: Brown Belt 1,141 posts since
    Oct 17, 2010
    Currently Being Moderated
    1. Mar 12, 2012 5:17 PM (in response to jarredm)
    Re: CSV Data Extraction

    The data that backs the graphs is stored in the RRD files ($ZENHOME/perf/Device/<deviceName/ip>. You have quite a few options to extract that data, but they all boild down to working with the RRD data. A google search for dumping RRD to CSV should yield more options than I could list here. You also have the ability to run custom Zenoss reports, but that is not a trivial undertaking.


    As far as the resolution, simply shortening the polling interval won't exactly work due to the way RRD leverages STEP. You'll need to also alter the default RRD Create command (found under the collector configuration) if you want that too work.

More Like This

  • Retrieving data ...


  • Correct Answers - 4 points
  • Helpful Answers - 2 points