RRDTool - Revision history

Stuart: /* Print out the data in the database */

2016-04-17T09:36:37Z

‎Print out the data in the database

2016-01-05T15:55:04Z

‎Export a part of the data in the RRA in XML or JSON format

2016-01-05T15:52:27Z

‎Export a part of the data in the RRA in XML or JSON format

2016-01-05T15:37:59Z

‎Print out the data in the database

2015-09-21T08:29:40Z

‎References

2015-09-21T08:29:20Z

‎References

2014-02-20T14:59:09Z

‎Delete entry in rrd database

2014-02-20T14:47:34Z

‎Delete entry in rrd database

2014-02-20T14:44:41Z

‎Delete entry in rrd database

2014-02-20T14:34:45Z

‎Delete entry in rrd database

@@ Line 184: / Line 184: @@
 </pre>
 ===Print out the data in the database===
 <pre>
@@ Line 190: / Line 196: @@
 rrdtool fetch export_duration_wdcrhbp05_ARISPPMP.rrd AVERAGE --start now-100000
 </pre>
 ===Export a part of the data in the RRA in JSON or XML format===
 Most of these parameters are the same as those used to graph the data

@@ Line 190: / Line 190: @@
 rrdtool fetch export_duration_wdcrhbp05_ARISPPMP.rrd AVERAGE --start now-100000
 </pre>
-===Export a part of the data in the RRA in XML or JSON format===
+===Export a part of the data in the RRA in JSON or XML format===
 Most of these parameters are the same as those used to graph the data
 <pre>
-rrdtool xport -s now-1month DEF:rmantime=dbamon_rman-duration_SOL_solax025_BI4REFP.rrd:rmantime:MAX CDEF:mins=rmantime,60,/ XPORT:mins
+rrdtool xport --json -s now-1month DEF:rmantime=dbamon_rman-duration_SOL_solax025_BI4REFP.rrd:rmantime:MAX CDEF:mins=rmantime,60,/ XPORT:mins
 </pre>
 or
 <pre>
-rrdtool xport --json -s now-1month DEF:rmantime=dbamon_rman-duration_SOL_solax025_BI4REFP.rrd:rmantime:MAX CDEF:mins=rmantime,60,/ XPORT:mins
+rrdtool xport -s now-1month DEF:rmantime=dbamon_rman-duration_SOL_solax025_BI4REFP.rrd:rmantime:MAX CDEF:mins=rmantime,60,/ XPORT:mins > xport.xml
 </pre>
-and trim the resulting data to bare data
+and trim the results to bare data
 <pre>
-rrdtool xport -s now-1month DEF:rmantime=dbamon_rman-duration_SOL_solax025_BI4REFP.rrd:rmantime:MAX CDEF:mins=rmantime,60,/ XPORT:mins|grep '<row>'|grep -v NaN|sed -e 's/ //g' -e 's/<row><t>//' -e 's/<\/t><v>/ /' -e 's/<\/v><\/row>//'
+cat xport.xml | grep '<row>' | grep -v NaN | sed -e 's/ //g' -e 's/<row><t>//' -e 's/<\/t><v>/ /' -e 's/<\/v><\/row>//'
 </pre>

@@ Line 198: / Line 198: @@
 <pre>
 rrdtool xport --json -s now-1month DEF:rmantime=dbamon_rman-duration_SOL_solax025_BI4REFP.rrd:rmantime:MAX CDEF:mins=rmantime,60,/ XPORT:mins
 </pre>

@@ Line 190: / Line 190: @@
 rrdtool fetch export_duration_wdcrhbp05_ARISPPMP.rrd AVERAGE --start now-100000
 </pre>
 ===Delete entry in rrd database===
 This function is not (yet) available and so the best work-around is:

@@ Line 209: / Line 209: @@
 ===References===
-[http://oss.oetiker.ch/rrdtool/ http://oss.oetiker.ch/rrdtool/]
+* [http://oss.oetiker.ch/rrdtool/ http://oss.oetiker.ch/rrdtool/]
-[http://khmel.org/?p=236 Original page]
+* [http://khmel.org/?p=236 Original page]
-[http://cuddletech.com/articles/rrd/ar01s02.html Creating an initial RRD]
+* [http://cuddletech.com/articles/rrd/ar01s02.html Creating an initial RRD]
-[http://apfelboymchen.net/gnu/rrd/create/ Better explanations of RRA]
+* [http://apfelboymchen.net/gnu/rrd/create/ Better explanations of RRA]

@@ Line 203: / Line 203: @@
 and
 <pre>
-rrdtool restore filename.xml filename.rrd [--range-check|-r]
+rrdtool restore filename.xml filename.rrd [--range-check|-r] [--force|-f]
 eg:
-rrdtool restore dumped.xml export_duration_wdcrhbp05_ARISPPMP.rrd
+rrdtool restore dumped.xml export_duration_wdcrhbp05_ARISPPMP.rrd -f
 </pre>

@@ Line 199: / Line 199: @@
 rrdtool dump filename.rrd [filename.xml] [--header|-h {none,xsd,dtd}] [--no-header] [--daemon address] > filename.xml
 eg:
-rrdtool dump export_duration_wdcrhbp05_ARISPPMP.rrd
+rrdtool dump export_duration_wdcrhbp05_ARISPPMP.rrd dumped.xml
 </pre>

@@ Line 195: / Line 195: @@
 * Open the XML file, find and edit the bad data
 * Restore the RRD file using RRDTool Restore
 ====References====
 [http://khmel.org/?p=236 Original page]