[rrd-users] Re: Extracting usage from rrdtool

Mon Oct 17 02:06:49 MEST 2005

Hi all,

Looking at the tutorials I can see an example such as:

rrdtool fetch example.rrd AVERAGE -r 300 -s -1h

timestamp    in_bytes          in_pkts           in_flows
out_bytes         out_pkts          out_flows

1129503600:  1.3264490000e+04  4.0223333333e+01  2.1200000000e+00
4.9571450000e+04  4.6166666667e+01  1.9733333333e+00
1129503900:  1.7034996667e+04  5.3683333333e+01  2.6200000000e+00
6.8049220000e+04  6.1610000000e+01  2.3466666667e+00
1129504200:  1.7308420000e+04  5.7336666667e+01  2.4700000000e+00
7.8056026667e+04  6.9490000000e+01  2.2266666667e+00
1129504500:  1.9042873333e+04  6.4116666667e+01  2.2833333333e+00
9.6874556667e+04  8.3550000000e+01  2.1033333333e+00
1129504800:  1.7058090000e+04  4.9103333333e+01  2.0166666667e+00
6.4134973333e+04  5.8470000000e+01  1.8566666667e+00
1129505100:  1.8256980000e+04  5.1110000000e+01  2.2433333333e+00
6.8698773333e+04  6.3340000000e+01  2.0866666667e+00
1129505400:  2.1391400000e+04  8.7853333333e+01  3.0000000000e+00
1.3187141333e+05  1.1042000000e+02  2.6300000000e+00
1129505700:  4.2176340000e+04  1.0509333333e+02  2.8566666667e+00
1.4031883333e+05  1.2263000000e+02  2.5733333333e+00
1129506000:  nan  nan  nan  nan  nan  nan
1129506300:  nan  nan  nan  nan  nan  nan
1129506600:  nan  nan  nan  nan  nan  nan
1129506900:  nan  nan  nan  nan  nan  nan
1129507200:  nan  nan  nan  nan  nan  nan
1129507500:  nan  nan  nan  nan  nan  nan

Now from what I can understand, this is the 5 min average from the last
hour, is this correct ?
I'm not sure I need the averages though, is there a way to retrieve
total from the last hour ?

I basically need to extract the usage from each rrd every hour.

Thanks again !

Regards,
--
Ross

-----Original Message-----
From: rrd-users-bounce at list.ee.ethz.ch
[mailto:rrd-users-bounce at list.ee.ethz.ch] On Behalf Of Ross Tsolakidis
Sent: Wednesday, 12 October 2005 12:41 PM
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Re: Extracting usage from rrdtool

 Hi again,

Can someone give me an example or some details on how I can extract data
on a daily or hourly basis ?
http://dude.powerserve.com.au/~rosst/rrd/example.rrd
Above is an example.

I've read a bit on rrdtool but cannot get my head around how to do this.

Is it using:
Rrdtool fetch ?

Can anyone give me an example please ?

Thanks again.

Regards,
--
Ross

-----Original Message-----
From: rrd-users-bounce at list.ee.ethz.ch
[mailto:rrd-users-bounce at list.ee.ethz.ch] On Behalf Of Ross Tsolakidis
Sent: Tuesday, 4 October 2005 10:37 AM
To: rrd-users at list.ee.ethz.ch
Subject: [rrd-users] Extracting usage from rrdtool

Hi all,

We get all figures from netflow for all our customers, they all have
static IP address.
I used this guide to set it all up,
http://www.dynamicnetworks.us/netflow/index.html
My many thanks to Mr Galloway and all the software writers involved in
that project, it's absolutely awesome !  :) 

I also use the front end from http://www.netflowguide.com to extract
usage figures for each IP address.
With the influx of many more customers, it is getting quite difficult to
do this manually anymore  :)

My question is, can I extract daily figures and monthly figures using a
command line tool per IP address ?
Can anyone point me in the right direction, an example ?
I think I can use some rrdtool commands which can give me daily figures,
maybe then run them from cron daily ?
I've linked one of our rrdtool databases so you can see the structure
it's in.
http://dude.powerserve.com.au/~rosst/rrd/example.rrd
I asked the netflow list but haven't had too many responses.

Once I extract those figures I can then put them into an SQL database
for historical data tracking.

Thanks again !

Peace.
--
Ross.

--
Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://lists.ee.ethz.ch/rrd-users
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi
DISCLAIMER: 
This e-mail and any files transmitted with it may be privileged and
confidential, and are intended only for the use of the intended
recipient. If you are not the intended recipient or responsible for
delivering this e-mail to the intended recipient, any use,
dissemination, forwarding, printing or copying of this e-mail and any
attachments is strictly prohibited. 
If you have received this e-mail in error, please REPLY TO the SENDER to
advise the error AND then DELETE the e-mail from your system.
Any views expressed in this e-mail and any files transmitted with it are
those of the individual sender, except where the sender specifically
states them to be the views of our organisation.
Our organisation does not represent or warrant that the attached files
are free from computer viruses or other defects. 
The user assumes all responsibility for any loss or damage resulting
directly or indirectly from the use of the attached files. In any event,
the liability to our organisation is limited to either the resupply of
the attached files or the cost of having the attached files resupplied.

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

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