[smokeping-users] Re: Smokeping Data Base Export

[Dan McGinn-Combs]

While I was researching tSmoke, I came across several items which I
think might help. However, none of them were a panacea. The each
required some additional coding...

1) RRDTool distributions include PERL bindings (RRDs.ppm) which can be
used to script functions like rrdfetch (to get data over a span of time
from an RRD). Check the old website for documentation:
http://people.ee.ethz.ch/~oetiker/webtools/rrdtool-1.0.x/perlbind/index.
html


2) RRDTool includes a feature called rrddump which dumps the information
directly to an XML file. Excel will eat an XML file... your mileage on
how useful this is may vary. Check the new website for documentation:
http://oss.oetiker.ch/rrdtool/doc/rrddump.en.html

3) CPAN has a PERL module that will write out an Excel spreadsheet
directly, Spreadsheet::WriteExcel and Spreadsheet:SimpleExcel:
http://search.cpan.org/search?m=all&q=excel&s=11

In the end, I realized that I had access to the data in the PERL
bindings and that PERL could add and subtract as well as Excel. So I
used PERL to do the calculations and create an HTML file with an
embedded table.

Dan

-----Original Message-----
From: smokeping-users-bounce at list.ee.ethz.ch
[mailto:smokeping-users-bounce at list.ee.ethz.ch] On Behalf Of Stickler,
Mark G (Mark)
Sent: Tuesday, July 11, 2006 10:15 AM
To: smokeping-users at list.ee.ethz.ch
Subject: [smokeping-users] Smokeping Data Base Export

All,

I believe that the SmokePing database is a "round robin DB" (.rrd),
correct? I know there are some RRD Tools, but I don't think they do what
I want to do. Namely, export SmokePing Data to something like an Excel
Spreadsheet. Any ideas if this is possible and, if so, how it can be
done?

--
Unsubscribe mailto:smokeping-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:smokeping-users-request at list.ee.ethz.ch?subject=help
Archive     http://lists.ee.ethz.ch/smokeping-users
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi