How to export munin raw data to CSV?

Solution 1:

Did you try googling? I searched "rrd2csv" (thinking that it'd probably be named thusly, if it existed), and found:

https://code.google.com/p/rrd2csv/

Alternatively, there's https://github.com/mscoutermarsh/RRD-to-CSV

and in Python => https://gist.github.com/afternoon/947301

As it's Perl, and Open Source, you can customise it to meet your exact requirements.

Solution 2:

If you want convert munin rdd data to SQL or CSV, you can inspire on this script

https://gist.github.com/raelga/5926594

To export to CSV:

sed -n "s@.*-- \(.* CEST\).*<v>\(.*\)</v></row>@\'$host\',\'$data\',\'\2\',\'\1\'@p" $rrd.xml >> munin.csv; 

Else ways you must adapt the regular expressions to your data

host=`echo $rrd | sed 's/\(.*\)_\(.*\)\.rrd/\1/'`;
data=`echo $rrd | sed 's/\(.*\)_\(.*\)\.rrd/\2/'`;