User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
grafanainfluxdb [22.02.2017 20:42]
grafanainfluxdb [16.11.2018 16:30] (current)
andreas [Initiate MQTT-DB on influxDB]
Line 47: Line 47:
 </​code>​ </​code>​
-Asking for the last two values of a - in this case via MQTT stored - power plug:+Asking for the last five values of a - in this case via MQTT stored - carbon dioxide sensor:
 <​code>​ <​code>​
-influx -execute '​SELECT * FROM "​zuhause/​haus/​433MHz/steckdose/10001/1" LIMIT 2' -database="​mqtt"​ +influx -execute '​SELECT * FROM "​zuhause/​haus/​wohnzimmer/raum/co2" ​ORDER BY time DESC LIMIT 5' -database="​mqtt" ​-precision rfc3339 
-name: zuhause/​haus/​433MHz/steckdose/10001/1 +name: zuhause/​haus/​wohnzimmer/raum/co2 
-time                value +time                     ​value 
-----                ----- +----                     ​----- 
-1487603211087000000 1 +2018-11-16T15:​23:​11.603Z 591 
-1487603214268000000 0+2018-11-16T15:​22:​11.568Z 591 
 +2018-11-16T15:​21:​11.759Z 580 
 +2018-11-16T15:​20:​11.295Z 571 
 +2018-11-16T15:​19:​11.799Z 542
 </​code>​ </​code>​
 +PS: Nice to know ''​-precision rfc3339''​ transforms the influx timestamp to a human readable date time timestamp.
 ===== Install MQTT2influxDB ===== ===== Install MQTT2influxDB =====
grafanainfluxdb.txt · Last modified: 16.11.2018 16:30 by andreas