Alright thanks a bunch, using the shell script you provided me I think I'll be able to grab this myself. You rock!
-----Original Message----- From: Stevens, Weston J Sent: Tuesday, July 27, 2010 1:57 PM To: 'Jesse Becker' Cc: [email protected] Subject: RE: [Ganglia-general] Parsing rrdtool dump output using Perl Correct, I want to be able to grab the last CDP timestamp of any RRA inside an RRD. All the best, ***************************** Weston J. Stevens Intern - Student Engineer Boeing Research & Technology Enterprise Strategic Growth W#: (253) 657-8689 C#: (253) 432-0560 ***************************** -----Original Message----- From: Jesse Becker [mailto:[email protected]] Sent: Tuesday, July 27, 2010 1:55 PM To: Stevens, Weston J Cc: [email protected] Subject: Re: [Ganglia-general] Parsing rrdtool dump output using Perl The last_update command stores a timestamp when the rrdfile was modified (so it should be very similar to the mtime of the file, under normal circumstances). But you don't want this, you want the timestamp of the last "slot" in the RRA, right? How about this: #!/bin/sh FILE=$1 DURATION=$2 T=/tmp/rrd.$$ rrdtool info $FILE > $T LAST=`awk '/last_update/{print $3}' $T` ROWS=`awk '/rra.3..rows/{print $3}' $T` PDP=`awk '/rra.3..pdp/{print $3}' $T` STEP=`awk '/step/{print $3}' $T` LENGTH=`echo "$PDP * $ROWS * $STEP" | bc ` #echo $LAST $ROWS $PDP rrdtool fetch $FILE AVERAGE -s -$LENGTH | tail -n +3 > $T FIRST=`head -n 1 $T | sed 's/:.*//'` LAST=`tail -n 1 $T | sed 's/:.*//'` echo $FIRST $LAST rm $T On Tue, Jul 27, 2010 at 16:14, Stevens, Weston J <[email protected]> wrote: > But say the last recorded CDP in the month RRA was a day ago, the last_update > and the last timestamp would be separated by a day using that method. > > -----Original Message----- > From: Jesse Becker [mailto:[email protected]] > Sent: Tuesday, July 27, 2010 12:57 PM > To: Stevens, Weston J > Cc: [email protected] > Subject: Re: [Ganglia-general] Parsing rrdtool dump output using Perl > > You could instead use rrdinfo to get the last_update timestamp. The starting > timestamp for the "month" RRA can then be computed. Using the default RRA > definitions, it should be something like: > > last_updated - 2459520 (=15*244*672) > > > On Tue, Jul 27, 2010 at 15:32, Stevens, Weston J > <[email protected]> wrote: >> Say for default Ganglia for example I wanted to grab the first and last >> timestamps for the month RRA so I can run a bounds check on begin/end time >> inputs. Ideally I'd like to get all this information by simply specifying >> the RRD granularity in seconds, without having to also specify the length of >> the RRD to get the last timestamp in a command line. Using rrdtool dump, >> what would be a good regex or anything else like Perl XML support that could >> do this for me? Or a completely different and better way to do it? >> >> >> >> --------------------------------------------------------------------- >> - >> -------- The Palm PDK Hot Apps Program offers developers who use the >> Plug-In Development Kit to bring their C/C++ apps to Palm for a share >> of $1 Million in cash or HP Products. Visit us here for more details: >> http://ad.doubleclick.net/clk;226879339;13503038;l? >> http://clk.atdmt.com/CRS/go/247765532/direct/01/ >> _______________________________________________ >> Ganglia-general mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/ganglia-general >> > > > > -- > Jesse Becker > Every cloud has a silver lining, except for the mushroom-shaped ones, which > come lined with strontium-90. > -- Jesse Becker Every cloud has a silver lining, except for the mushroom-shaped ones, which come lined with strontium-90. ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://ad.doubleclick.net/clk;226879339;13503038;l? http://clk.atdmt.com/CRS/go/247765532/direct/01/ _______________________________________________ Ganglia-general mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ganglia-general
