[rrd-users] Need help to extract data from existing rdd database

Patrick ZINSOU PZinsou at slb.com
Thu Apr 29 16:29:11 CEST 2010


I performed the following cmd file:

echo off
rem // Extract the data from the RRD file
"c:\Program Files\FineConnection\Monitor one\rrdtool.exe" fetch Myanmar_VSAT_D5_RxEbNo_hist_1.rrd AVERAGE --start 01/01/2009 --end 01/01/2010> Myanmar_VSAT_D5_RxEbNo_hist_Export.txt  >Myanmar_VSAT_D5_RxEbNo_hist_Export.txt
rem // Convert the values in the export file to more user friendly strings
"c:\Program Files\FineConnection\Monitor one\MCnvrt.exe" Myanmar_VSAT_D5_RxEbNo_hist_Export.txt /DTF /NULL /VST
rem // Read the new formatted export file into notepad to see the results
notepad Myanmar_VSAT_D5_RxEbNo_hist_Export.txt

The problem that I have is that the result presents me the average of every day between 01/01/2009 and 01/01/2010. 
Could you help to modify the "cmd file" to get every 5 min average for each day between 01/01/2009 and 01/01/2010?

Thanks for your help.


-----Original Message-----
From: rrd-users-bounces+pzinsou=slb.com at lists.oetiker.ch [mailto:rrd-users-bounces+pzinsou=slb.com at lists.oetiker.ch] On Behalf Of pzinsou
Sent: jeudi 29 avril 2010 16:00
To: rrd-users at lists.oetiker.ch
Subject: [rrd-users] Need help to extract data from existing rdd database

Hi, I use Monitor One software with RRD tool. My monitor One software is
monitoring modem for 3 links (2 modem per link so 6 links) I'm trying to
extract all the data (every polling of each day) for devices…. When issuing
the fetch via GUI command you can choose: • Name • Date/Time interval The
command that will be launch is: “fetch Modem_VSAT_D0_RxEbNo_hist_1.rrd
AVERAGE --start -1day >Exportfilename.txt” But this is an average right?
What I would like to get is to extract not the average but all the data for
all the day each time the polling has been done by the software. Do you know
what the frequency of the polling of the software is? Is it possible to
change the fetch command parameters  to get all these data? How? Coudl you
let me know the command that I need to launch? What I would like is to get
all the last 365 days polling software Ebno values for each days (not the
average). Are these data can be retrieve to be extracted on worksheet?
thanks for your support

View this message in context: http://old.nabble.com/Need-help-to-extract-data-from-existing-rdd-database-tp28400928p28400928.html
Sent from the RRDTool - User mailing list archive at Nabble.com.

rrd-users mailing list
rrd-users at lists.oetiker.ch

More information about the rrd-users mailing list