Along the same lines (sort of) one thing that I would REALLY, REALLY like is an interface into the RRD data in textual format.

A screen that lets you pick a host, an RRD, a start/end time, etc.. and then gives you either a text, or csv, etc... file.

I've tried "rrdtool dump" to dump into xml format, and never had much luck getting excel to read it correctly.

"rrdtool xport" seems to be the way to go, and that's a pain to setup by hand each time (and still havn't had too much luck getting excel to read it in perfectly). I've been doing the "rrdtool xport" and piping it to a perl program to convert the file to a .csv file which I have had a lot of success with (with excel) I've pasted the program below for anyone interested.

-Jeff

cat xport_to_csv.pl

#!/usr/bin/perl

use strict;
use warnings;
use XML::Simple;

my $xml_doc;
{
    local $/;
    $xml_doc = <STDIN>;
}

my $xml = XMLin( $xml_doc );

print join(",", 'timestamp', @{ $xml->{meta}{legend}{entry} } ), "\n";

foreach my $row ( @{ $xml->{data}{row} } ) {
    print join(",", $row->{t}, @{$row->{v}}), "\n";
}

exit(0);

On 4/12/06, Marco Avvisano <marco.avvisano at regione.toscana.it> wrote:

Hi Enrik,

what you think about the possibility to generate a sla report in text format for specific column/services? It will be great to have specific reports for specific groups of servers/services.

thanks for your great work

M.