Rrdtool info - Revision history

Chubbard: /* Convert fetch to csv */

2024-09-26T18:34:10Z

Convert fetch to csv

@@ Line 143: / Line 143: @@
 Wed 20 Sep 2023 05:15:00 PM UTC,31
 Wed 20 Sep 2023 05:20:00 PM UTC,31
 </pre>
 [[Category:rrd]]

Chubbard: /* last */

2024-02-18T00:36:40Z

last

← Older revision		Revision as of 17:36, 17 February 2024
Line 78:		Line 78:

	1685745404: 16 103 36 6291456		1685745404: 16 103 36 6291456
	<.pre>		</pre>
	== fetch ==		== fetch ==
	<pre>		<pre>

Chubbard: /* Convert fetch to csv */

2023-09-20T17:41:44Z

Convert fetch to csv

@@ Line 106: / Line 106: @@
 </pre>
 == Convert  fetch to csv ==
 <pre>
 IFS=$'\n'; for x in $(rrdtool fetch ../rrd/guyver-office.iwillfearnoevil.com/snmp/lm-sensors/temp.temp1_32.rrd AVERAGE -s "-1h" -e "now" -r 300| grep ': '| grep -v 'nan'); do w=$(echo "$x" | awk -F ':' '{print $1}') ; y=$(echo "$x" | awk -F ':' '{print $2}') ; echo $w,$(printf "%.0f\n" $y) ; done

Chubbard: /* Convert scientific to decimal */

2023-09-20T17:26:41Z

Convert scientific to decimal

@@ Line 104: / Line 104: @@
 printf "%.0f\n" 3.0207707653e+01
 </pre>
 [[Category:rrd]]

Chubbard: /* Landing point for RRD commands and examples */

2023-09-20T17:02:12Z

Landing point for RRD commands and examples

@@ Line 3: / Line 3: @@
 * Looks like a cheap way to get last values from the database possibly to store for status dashboard without the graph generation
 * This should be easily parsed in both bash and PHP for <b>ds[NAME].last_ds</b>
 <pre>
 rrdtool info /opt/nmsApi/rrd/database.rrd
@@ Line 56: / Line 57: @@
 </pre>
-Another option:
+== lastupdate ==
 <pre>
 rrdtool lastupdate ../../rrd/database.rrd
@@ Line 64: / Line 65: @@
 </pre>
-Find out when the last metric was received
+== last ==
 <pre>
 rrdtool last ../../rrd/database.rrd
@@ Line 77: / Line 79: @@
 1685745404: 16 103 36 6291456
 <.pre>
 [[Category:rrd]]

Chubbard at 23:07, 2 June 2023

2023-06-02T23:07:11Z

← Older revision		Revision as of 16:07, 2 June 2023
Line 70:		Line 70:
	</pre>		</pre>

			Retrieve last set of metrics insrted
			<pre>
			rrdtool lastupdate snmp/snmp-300.rrd
			Monitors Devices Time Memory

			1685745404: 16 103 36 6291456
			<.pre>
	[[Category:rrd]]		[[Category:rrd]]

Chubbard at 02:58, 29 May 2023

2023-05-29T02:58:57Z

← Older revision		Revision as of 19:58, 28 May 2023
Line 62:		Line 62:

	1685328961: 31 65		1685328961: 31 65
			</pre>

			Find out when the last metric was received
			<pre>
			rrdtool last ../../rrd/database.rrd
			1685328961
	</pre>		</pre>

	[[Category:rrd]]		[[Category:rrd]]

Chubbard: /* Landing point for RRD commands and examples */

2023-05-29T02:57:24Z

Landing point for RRD commands and examples

← Older revision		Revision as of 19:57, 28 May 2023
Line 55:		Line 55:

	</pre>		</pre>

			Another option:
			<pre>
			rrdtool lastupdate ../../rrd/database.rrd
			temperature humidity

			1685328961: 31 65

			</pre>

	[[Category:rrd]]		[[Category:rrd]]

Chubbard: Chubbard moved page Rrdtool to Rrdtool info

2023-05-29T02:18:21Z

Chubbard moved page Rrdtool to Rrdtool info

← Older revision

Revision as of 19:18, 28 May 2023

Chubbard: Created page with "=== Landing point for RRD commands and examples === print the base info from an RRD database * Looks like a cheap way to get last values from the database possibly to store for status dashboard without the graph generation * This should be easily parsed in both bash and PHP for ds[NAME].last_ds

 rrdtool info /opt/nmsApi/rrd/database.rrd filename = "/opt/nmsApi/rrd/database.rrd" rrd_version = "0003" step = 1 last_update = 1685326405 header_size = 1472 ds[tempe..."

2023-05-29T02:17:41Z

Created page with "=== Landing point for RRD commands and examples === print the base info from an RRD database * Looks like a cheap way to get last values from the database possibly to store for status dashboard without the graph generation * This should be easily parsed in both bash and PHP for <b>ds[NAME].last_ds</b> <pre> rrdtool info /opt/nmsApi/rrd/database.rrd filename = "/opt/nmsApi/rrd/database.rrd" rrd_version = "0003" step = 1 last_update = 1685326405 header_size = 1472 ds[tempe..."

New page

=== Landing point for RRD commands and examples ===
print the base info from an RRD database
* Looks like a cheap way to get last values from the database possibly to store for status dashboard without the graph generation
* This should be easily parsed in both bash and PHP for <b>ds[NAME].last_ds</b>
<pre>
rrdtool info /opt/nmsApi/rrd/database.rrd
filename = "/opt/nmsApi/rrd/database.rrd"
rrd_version = "0003"
step = 1
last_update = 1685326405
header_size = 1472
ds[temperature].index = 0
ds[temperature].type = "GAUGE"
ds[temperature].minimal_heartbeat = 600
ds[temperature].min = 0.0000000000e+00
ds[temperature].max = 1.0000000000e+02
ds[temperature].last_ds = "31"
ds[temperature].value = 1.4787341000e+01
ds[temperature].unknown_sec = 0
ds[humidity].index = 1
ds[humidity].type = "GAUGE"
ds[humidity].minimal_heartbeat = 600
ds[humidity].min = 0.0000000000e+00
ds[humidity].max = 1.0000000000e+02
ds[humidity].last_ds = "65"
ds[humidity].value = 3.1005715000e+01
ds[humidity].unknown_sec = 0
rra[0].cf = "AVERAGE"
rra[0].rows = 3600
rra[0].cur_row = 3151
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-01
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[0].cdp_prep[1].value = NaN
rra[0].cdp_prep[1].unknown_datapoints = 0
rra[1].cf = "AVERAGE"
rra[1].rows = 720
rra[1].cur_row = 501
rra[1].pdp_per_row = 60
rra[1].xff = 5.0000000000e-01
rra[1].cdp_prep[0].value = 7.7500000000e+02
rra[1].cdp_prep[0].unknown_datapoints = 0
rra[1].cdp_prep[1].value = 1.6250000000e+03
rra[1].cdp_prep[1].unknown_datapoints = 0
rra[2].cf = "AVERAGE"
rra[2].rows = 24
rra[2].cur_row = 8
rra[2].pdp_per_row = 3600
rra[2].xff = 5.0000000000e-01
rra[2].cdp_prep[0].value = 2.4260961332e+04
rra[2].cdp_prep[0].unknown_datapoints = 0
rra[2].cdp_prep[1].value = 5.2791045244e+04
rra[2].cdp_prep[1].unknown_datapoints = 0

</pre>
[[Category:rrd]]