sendTo & InfluxDB -> ??? [gelöst]
-
Irgendwie verstehe ich das Ganze nicht mehr. Ich schreibe mittels eines Blockly-Scriptes die Werte für unseren Gasverbrauch nur einmal am Tag, pro Woche, pro Monat und Jahr nach InfluxDB. Dies geschieht stets um Mitternacht. Hierzu verwende ich ..
zeit=zeit-12*3600*1000 // Vortag 12:00 Uhr mittags sendTo('influxdb.0', 'storeState', { id: ziel, state: {ts: zeit, val: wert, ack: false, from: ziel} }
Irgendwie habe ich den Eindruck, wir stochern bloß im Trüben. Hier das Ergebnis zu deinem Vorschlag ..
javascript.0 09:33:59.542 info script.js._Test.InfluxDB_auslesen: Thu, 12 Jan 2023 08:33:59 GMT Gas: 5.6194m³ javascript.0 09:33:59.542 info script.js._Test.InfluxDB_auslesen: Mon, 16 Jan 2023 22:59:00 GMT Gas: 5.6194m³ javascript.0 09:33:59.544 info script.js._Test.InfluxDB_auslesen: Wed, 25 Jan 2023 22:59:00 GMT Gas: 7.0518m³ javascript.0 09:33:59.544 info script.js._Test.InfluxDB_auslesen: Sat, 28 Jan 2023 22:59:00 GMT Gas: 7.0825m³ javascript.0 09:33:59.545 info script.js._Test.InfluxDB_auslesen: Sun, 29 Jan 2023 03:53:28 GMT Gas: 7.0825m³ javascript.0 09:33:59.545 info script.js._Test.InfluxDB_auslesen: Sun, 29 Jan 2023 04:11:59 GMT Gas: 7.0825m³ javascript.0 09:33:59.546 info script.js._Test.InfluxDB_auslesen: Fri, 03 Feb 2023 22:59:00 GMT Gas: 5.3505m³ javascript.0 09:33:59.547 info script.js._Test.InfluxDB_auslesen: Thu, 09 Feb 2023 22:59:00 GMT Gas: 8.1133m³ javascript.0 09:33:59.574 info script.js._Test.InfluxDB_auslesen: Wed, 19 Apr 2023 21:59:00 GMT Gas: 3.403m³ javascript.0 09:33:59.574 info script.js._Test.InfluxDB_auslesen: Wed, 19 Apr 2023 21:59:00 GMT Gas: 3.403m³ javascript.0 09:33:59.576 info script.js._Test.InfluxDB_auslesen: Thu, 20 Apr 2023 10:31:13 GMT Gas: 3.403m³ javascript.0 09:33:59.576 info script.js._Test.InfluxDB_auslesen: Thu, 20 Apr 2023 10:31:13 GMT Gas: 3.403m³ javascript.0 09:33:59.599 info script.js._Test.InfluxDB_auslesen: Mon, 29 May 2023 21:59:00 GMT Gas: 0.8405m³ javascript.0 09:33:59.599 info script.js._Test.InfluxDB_auslesen: Mon, 29 May 2023 21:59:00 GMT Gas: 0.8405m³ javascript.0 09:33:59.609 info script.js._Test.InfluxDB_auslesen: Wed, 14 Jun 2023 21:59:00 GMT Gas: 0.697m³ javascript.0 09:33:59.609 info script.js._Test.InfluxDB_auslesen: Wed, 14 Jun 2023 21:59:00 GMT Gas: 0.697m³ -
Mittlerweile bin ich ein gutes Stück vorangekommen.
Hierzu habe ich mich ein wenig mit der (von mir ungeliebten) Flux Abfragesprache beschäftigt und in InfluxDB eine Abfrage generiert. Hierin finde ich nun endlich die korrekten - und auch von Grafana angezeigten - Daten.
Jetzt muss ich "nur" noch das Ganze mittels sendTo hinbekommen.
PS:
Mein Vorhaben ist, mich von InfluxDB, Grafana & Co. endgültig zu verabschieden. Erst kündigen sie InfluxQL ab, zur neuen Version 3.0 ist nun wiederum Flux abgekündigt. Da funktioniert der Parameter kiosk tadellos im Zusammenspiel mit iFrame, bis sich die Entwickler mal wieder etwas Neues haben einfallen lassen und der Parameter _dash.hideTimePicker angegeben werden musste. Nach einem der letzten Updates kann ich via BackItUp kein Backup von InfluxDB mehr erstellen. Früher konnte man direkt aus InfluxDB einen CSV-Export anstoßen; die zugehörige Schaltfläche ust schon lange wieder verschwunden. Usw. .. usw. ..
Das ist für mich reinste Agrarinformatik: rein in die Kartoffeln, raus aus den Kartoffeln oder kurz und knapp Kraut&Rüben.
Ich bin diese Basteleien ein für allemal satt.
Fortan bin ich lieber meines eigenen (Un)Glückes Schmied. -
@legro sagte in sendTo & InfluxDB -> ???:
Das ist für mich reinste Agrarinformatik: rein in die Kartoffeln, raus aus den Kartoffeln oder kurz und knapp Kraut&Rüben.
Ich bin diese Basteleien ein für allemal satt.zur Klarstellung:
Das Ganze hat nichts mit ioBroker zu tun.Der influx-Adapter ist über 20.000 mal installiert.
Seine Aufgabe ist es Werte von zur Historisierung konfigurierten Datenpunkten zu speichern.Diese Aufgabe macht er anstandslos.
Weder die Manipulation von Daten, noch die Verwendung dieser Daten in Grafana ist eigentliche Aufgabe von ioBroker, sondern "high elevated" Individualprogrammierung.
Sowohl die InfluxDB, als auch Grafana sind 3rd Party Programme. -
Seit wann hat sendTo nichts mit ioBroker zu tun?
Hier geht es nicht primär um InfluxDB, Grafana & Co. sondern um die Möglichkeiten mittels sendTo von ioBroker in InfluxDB gespeicherte Daten abzufragen bzw. auszulesen.
Mittlerweile reduziert sich das Ganze auf die Frage: Wie kann ich mittels sendTo ein measurement gasTag aus InfluxDB auslesen?
-
@legro sagte in sendTo & InfluxDB -> ???:
Seit wann hat sendTo nichts mit ioBroker zu tun?
hab ich das geschrieben
? -
Nein, hast du nicht.
Du sprichst von so unsinnigem Zeug wie "high elevated Individualprogrammierung". So etwas steht doch hier gar nicht zur Debatte; hier werden bloß kleine Brötchen gebacken. Wie gesagt ist die Frage: Wie muss in dem hier vorliegenden Fall der Aufruf von sendTo gestaltet werden?Hier ein erster Lösungsansatz mittels (der ungeliebten Abfragesprache) Flux ..
sendTo('influxdb.0', 'query', 'from(bucket: "db_iobroker") |> range(start: -745d, stop: -736d) |> filter(fn: (r) => r._measurement == "gasTag") |> filter(fn: (r) => r["_field"] == "value")', function (query) { let abfrage = JSON.stringify(query.result) let qry = JSON.parse(abfrage) console.log(qry)Mal sehen, ob ich das Ganze irgendwie via JSON.parse und JSON.stringify weiterverarbeitet bekomme.
-
Mittlerweile konnte ich das Rätsel lösen. Nachdem ich mich hinsichtlich der Abfragesprache Flux leidlich angefreundet hatte, gelang es mir das Vorhaben mittels eine Abfrage (query) zu lösen. Hier der Programmcode ..
sendTo('influxdb.0', 'query', 'from(bucket: "db_iobroker") |> range(start: -737d, stop: -0d) |> filter(fn: (r) => r._measurement == "gasTag") |> filter(fn: (r) => r["_field"] == "value")', function (query) { let abfrage = JSON.stringify(query.result) let qry = JSON.parse(abfrage) //console.log(qry[0][1]) for (let i=0; i<qry[0].length; i++) { console.log('Zeit: ' + qry[0][i]._time + ' Gas: ' + qry[0][i]._value + ' m³') } });Und hier die Ausgabe ..
javascript.0 15:02:36.947 info script.js._Test.InfluxDB_SELECT: Zeit: 2023-02-03T11:00:01.036Z Gas: 5.350499999665772 m³ javascript.0 15:02:36.950 info script.js._Test.InfluxDB_SELECT: Zeit: 2023-03-04T11:00:01.061Z Gas: 7.113499999555643 m³ javascript.0 15:02:36.957 info script.js._Test.InfluxDB_SELECT: Zeit: 2023-03-29T10:00:01.04Z Gas: 4.725249999704829 m³ javascript.0 15:02:36.969 info script.js._Test.InfluxDB_SELECT: Zeit: 2023-05-19T10:00:01.035Z Gas: 0.9634999999398133 m³ javascript.0 15:02:36.973 info script.js._Test.InfluxDB_SELECT: Zeit: 2023-06-14T10:00:01.024Z Gas: 0.6969999999564607 m³ javascript.0 15:02:36.973 info script.js._Test.InfluxDB_SELECT: Zeit: 2023-06-15T10:00:01.057Z Gas: 0.7789999999513384 m³ javascript.0 15:02:37.015 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-02-10T11:00:01.041Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.016 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-02-15T11:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.016 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-02-16T11:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.016 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-02-19T11:00:01.022Z Gas: 0.07174999999551801 m³ javascript.0 15:02:37.016 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-02-20T11:00:01.045Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.016 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-02-25T11:00:01.029Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.017 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-02-29T11:00:01.054Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.017 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-02T11:00:01.028Z Gas: 0 m³ javascript.0 15:02:37.017 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-03T11:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.017 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-04T11:00:01.02Z Gas: 0.07174999999551801 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-12T11:00:01.033Z Gas: 0 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-13T11:00:01.045Z Gas: 0 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-14T11:00:01.051Z Gas: 0 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-15T11:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-16T11:00:01.076Z Gas: 0 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-17T11:00:01.03Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-18T11:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-19T11:00:01.051Z Gas: 0 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-20T11:00:01.1Z Gas: 0 m³ javascript.0 15:02:37.018 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-21T11:00:01.043Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-25T11:00:01.033Z Gas: 0.8404999999474967 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-26T11:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-27T11:00:01.063Z Gas: 0.061499999996158294 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-29T11:00:01.058Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-30T11:00:01.067Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-02T10:00:01.045Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-03T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-04T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-26T11:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-06T10:00:01.068Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-07T10:00:01.02Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-08T10:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-09T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-11T10:00:01.036Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-12T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-13T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-14T10:00:01.052Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-15T10:00:01.06Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-27T11:00:01.063Z Gas: 0.061499999996158294 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-28T11:00:01.038Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-29T11:00:01.058Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-30T11:00:01.067Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-03-31T10:00:01.106Z Gas: 0.061499999996158294 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-01T10:00:01.025Z Gas: 0.030749999998079147 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-02T10:00:01.045Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-03T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-04T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.019 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-05T10:00:01.036Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-06T10:00:01.068Z Gas: 0 m³ javascript.0 15:02:37.021 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-17T10:00:01.038Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.021 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-18T10:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-07T10:00:01.02Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-08T10:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-09T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-10T10:00:01.053Z Gas: 0.061499999996158294 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-11T10:00:01.036Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-12T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-13T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-14T10:00:01.052Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-15T10:00:01.06Z Gas: 0 m³ javascript.0 15:02:37.020 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-16T10:00:01.028Z Gas: 0 m³ javascript.0 15:02:37.021 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-17T10:00:01.038Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.021 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-18T10:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.021 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-19T10:00:01.053Z Gas: 0 m³ javascript.0 15:02:37.021 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-20T10:00:01.032Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.021 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-21T10:00:01.034Z Gas: 0.6354999999603024 m³ javascript.0 15:02:37.021 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-22T10:00:01.065Z Gas: 2.1114999998681014 m³ javascript.0 15:02:37.021 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-23T10:00:01.051Z Gas: 1.6809999998949934 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-24T10:00:01.073Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-25T10:00:01.059Z Gas: 0.08199999999487773 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-27T10:00:01.029Z Gas: 0 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-28T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-25T10:00:01.059Z Gas: 0.08199999999487773 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-26T10:00:01.023Z Gas: 0.061499999996158294 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-27T10:00:01.029Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-01T10:00:01.064Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-02T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-03T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-04T10:00:01.115Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-05T10:00:01.056Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-07T10:00:01.083Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-08T10:00:01.036Z Gas: 0 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-28T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-29T10:00:01.022Z Gas: 0.08199999999487773 m³ javascript.0 15:02:37.022 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-04-30T10:00:01.104Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-01T10:00:01.064Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-10T10:00:01.057Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-11T10:00:01.101Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-12T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-13T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-14T10:00:01.037Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-15T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-16T10:00:01.021Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-17T10:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-02T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-03T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-04T10:00:01.115Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-05T10:00:01.056Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-06T10:00:01.089Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-07T10:00:01.083Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-08T10:00:01.036Z Gas: 0 m³ javascript.0 15:02:37.023 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-09T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-10T10:00:01.057Z Gas: 0 m³ javascript.0 15:02:37.025 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-19T10:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-11T10:00:01.101Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-12T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-13T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-14T10:00:01.037Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-15T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-16T10:00:01.021Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-17T10:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.024 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-18T10:00:01.057Z Gas: 0 m³ javascript.0 15:02:37.025 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-19T10:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.026 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-21T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.025 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-20T10:00:01.033Z Gas: 0 m³ javascript.0 15:02:37.026 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-21T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.026 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-22T10:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.027 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-23T10:00:01.053Z Gas: 0.4202500088213128 m³ javascript.0 15:02:37.027 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-24T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.028 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-25T10:00:01.039Z Gas: 0 m³ javascript.0 15:02:37.028 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-26T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.028 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-27T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.028 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-25T10:00:01.039Z Gas: 0 m³ javascript.0 15:02:37.029 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-29T10:00:01.081Z Gas: 0 m³ javascript.0 15:02:37.029 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-30T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.028 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-26T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.028 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-27T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.028 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-28T10:00:01.063Z Gas: 0 m³ javascript.0 15:02:37.029 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-29T10:00:01.081Z Gas: 0 m³ javascript.0 15:02:37.030 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-01T10:00:01.058Z Gas: 0 m³ javascript.0 15:02:37.030 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-02T10:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.029 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-30T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.029 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-05-31T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.030 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-01T10:00:01.058Z Gas: 0 m³ javascript.0 15:02:37.031 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-04T10:00:01.028Z Gas: 0 m³ javascript.0 15:02:37.030 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-02T10:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.030 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-03T10:00:01.045Z Gas: 0 m³ javascript.0 15:02:37.031 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-04T10:00:01.028Z Gas: 0 m³ javascript.0 15:02:37.031 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-05T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.032 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-06T10:00:01.033Z Gas: 0 m³ javascript.0 15:02:37.033 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-07T10:00:01.051Z Gas: 0 m³ javascript.0 15:02:37.033 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-07T10:00:01.051Z Gas: 0 m³ javascript.0 15:02:37.034 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-09T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.033 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-08T10:00:01.043Z Gas: 0 m³ javascript.0 15:02:37.034 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-09T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.034 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-10T10:00:01.087Z Gas: 0 m³ javascript.0 15:02:37.035 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-11T10:00:01.041Z Gas: 0 m³ javascript.0 15:02:37.036 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-12T10:00:01.058Z Gas: 0 m³ javascript.0 15:02:37.037 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-13T10:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.037 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-14T10:00:01.067Z Gas: 0 m³ javascript.0 15:02:37.037 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-15T10:00:01.103Z Gas: 0 m³ javascript.0 15:02:37.037 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-13T10:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.038 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-17T10:00:01.104Z Gas: 0 m³ javascript.0 15:02:37.037 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-14T10:00:01.067Z Gas: 0 m³ javascript.0 15:02:37.037 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-15T10:00:01.103Z Gas: 0 m³ javascript.0 15:02:37.037 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-16T10:00:01.027Z Gas: 0 m³ javascript.0 15:02:37.038 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-17T10:00:01.104Z Gas: 0 m³ javascript.0 15:02:37.039 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-19T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.038 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-18T10:00:01.083Z Gas: 0 m³ javascript.0 15:02:37.039 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-19T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.040 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-21T10:00:01.076Z Gas: 0 m³ javascript.0 15:02:37.040 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-22T10:00:01.02Z Gas: 0 m³ javascript.0 15:02:37.040 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-23T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.040 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-24T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.039 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-20T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.040 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-21T10:00:01.076Z Gas: 0 m³ javascript.0 15:02:37.041 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-26T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.041 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-27T10:00:01.038Z Gas: 0 m³ javascript.0 15:02:37.040 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-22T10:00:01.02Z Gas: 0 m³ javascript.0 15:02:37.040 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-23T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.040 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-24T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.040 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-25T10:00:01.06Z Gas: 0 m³ javascript.0 15:02:37.041 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-26T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.042 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-29T10:00:01.081Z Gas: 0 m³ javascript.0 15:02:37.042 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-30T10:00:01.064Z Gas: 0 m³ javascript.0 15:02:37.042 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-01T10:00:01.033Z Gas: 0 m³ javascript.0 15:02:37.041 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-27T10:00:01.038Z Gas: 0 m³ javascript.0 15:02:37.041 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-28T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.042 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-29T10:00:01.081Z Gas: 0 m³ javascript.0 15:02:37.043 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-03T10:00:01.057Z Gas: 0 m³ javascript.0 15:02:37.043 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-04T10:00:01.029Z Gas: 0 m³ javascript.0 15:02:37.043 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-05T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.042 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-06-30T10:00:01.064Z Gas: 0 m³ javascript.0 15:02:37.042 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-01T10:00:01.033Z Gas: 0 m³ javascript.0 15:02:37.042 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-02T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.043 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-03T10:00:01.057Z Gas: 0 m³ javascript.0 15:02:37.044 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-07T10:00:01.131Z Gas: 0 m³ javascript.0 15:02:37.044 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-08T10:00:01.062Z Gas: 0 m³ javascript.0 15:02:37.044 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-09T10:00:01.051Z Gas: 0 m³ javascript.0 15:02:37.044 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-10T10:00:01.062Z Gas: 0 m³ javascript.0 15:02:37.043 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-04T10:00:01.029Z Gas: 0 m³ javascript.0 15:02:37.043 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-05T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.043 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-06T10:00:01.039Z Gas: 0 m³ javascript.0 15:02:37.044 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-07T10:00:01.131Z Gas: 0 m³ javascript.0 15:02:37.045 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-12T10:00:01.053Z Gas: 0 m³ javascript.0 15:02:37.045 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-13T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.045 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-14T10:00:01.097Z Gas: 0 m³ javascript.0 15:02:37.044 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-08T10:00:01.062Z Gas: 0 m³ javascript.0 15:02:37.044 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-09T10:00:01.051Z Gas: 0 m³ javascript.0 15:02:37.044 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-10T10:00:01.062Z Gas: 0 m³ javascript.0 15:02:37.044 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-11T10:00:01.118Z Gas: 0 m³ javascript.0 15:02:37.045 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-12T10:00:01.053Z Gas: 0 m³ javascript.0 15:02:37.046 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-16T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.046 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-17T10:00:01.041Z Gas: 0 m³ javascript.0 15:02:37.046 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-18T10:00:01.038Z Gas: 0 m³ javascript.0 15:02:37.045 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-13T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.045 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-14T10:00:01.097Z Gas: 0 m³ javascript.0 15:02:37.045 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-15T10:00:01.038Z Gas: 0 m³ javascript.0 15:02:37.046 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-16T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.047 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-20T10:00:01.07Z Gas: 0 m³ javascript.0 15:02:37.047 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-21T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.046 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-17T10:00:01.041Z Gas: 0 m³ javascript.0 15:02:37.046 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-18T10:00:01.038Z Gas: 0 m³ javascript.0 15:02:37.046 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-19T10:00:01.021Z Gas: 0 m³ javascript.0 15:02:37.047 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-20T10:00:01.07Z Gas: 0 m³ javascript.0 15:02:37.048 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-23T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.048 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-24T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.048 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-25T10:00:01.029Z Gas: 0 m³ javascript.0 15:02:37.048 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-26T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.047 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-21T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.047 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-22T10:00:01.036Z Gas: 0 m³ javascript.0 15:02:37.048 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-23T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.049 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-28T10:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.049 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-29T10:00:01.07Z Gas: 0 m³ javascript.0 15:02:37.049 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-30T10:00:01.036Z Gas: 0 m³ javascript.0 15:02:37.048 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-24T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.048 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-25T10:00:01.029Z Gas: 0 m³ javascript.0 15:02:37.048 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-26T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.048 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-27T10:00:01.057Z Gas: 0 m³ javascript.0 15:02:37.049 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-28T10:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.050 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-01T10:00:01.084Z Gas: 0 m³ javascript.0 15:02:37.050 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-02T10:00:01.041Z Gas: 0 m³ javascript.0 15:02:37.050 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-03T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.049 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-29T10:00:01.07Z Gas: 0 m³ javascript.0 15:02:37.049 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-30T10:00:01.036Z Gas: 0 m³ javascript.0 15:02:37.049 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-07-31T10:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.050 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-01T10:00:01.084Z Gas: 0 m³ javascript.0 15:02:37.051 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-06T10:00:01.067Z Gas: 0 m³ javascript.0 15:02:37.051 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-07T10:00:01.05Z Gas: 0 m³ javascript.0 15:02:37.051 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-08T10:00:01.063Z Gas: 0 m³ javascript.0 15:02:37.051 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-09T10:00:01.048Z Gas: 0 m³ javascript.0 15:02:37.050 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-02T10:00:01.041Z Gas: 0 m³ javascript.0 15:02:37.050 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-03T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.050 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-04T10:00:01.041Z Gas: 0 m³ javascript.0 15:02:37.051 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-06T10:00:01.067Z Gas: 0 m³ javascript.0 15:02:37.052 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-11T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.052 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-12T10:00:01.038Z Gas: 0 m³ javascript.0 15:02:37.051 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-07T10:00:01.05Z Gas: 0 m³ javascript.0 15:02:37.051 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-08T10:00:01.063Z Gas: 0 m³ javascript.0 15:02:37.051 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-09T10:00:01.048Z Gas: 0 m³ javascript.0 15:02:37.051 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-10T10:00:01.027Z Gas: 0 m³ javascript.0 15:02:37.052 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-11T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.053 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-14T10:00:01.045Z Gas: 0 m³ javascript.0 15:02:37.053 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-15T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.052 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-12T10:00:01.038Z Gas: 0 m³ javascript.0 15:02:37.052 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-13T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.053 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-14T10:00:01.045Z Gas: 0 m³ javascript.0 15:02:37.054 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-17T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.053 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-15T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.053 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-16T10:00:01.056Z Gas: 0 m³ javascript.0 15:02:37.054 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-17T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.055 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-19T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.055 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-20T10:00:01.041Z Gas: 0 m³ javascript.0 15:02:37.054 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-18T10:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.055 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-19T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.056 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-22T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.056 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-23T10:00:01.072Z Gas: 0 m³ javascript.0 15:02:37.056 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-24T10:00:01.053Z Gas: 0 m³ javascript.0 15:02:37.055 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-20T10:00:01.041Z Gas: 0 m³ javascript.0 15:02:37.055 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-21T10:00:01.038Z Gas: 0 m³ javascript.0 15:02:37.056 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-22T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.057 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-26T10:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.057 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-27T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.057 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-28T10:00:01.029Z Gas: 0 m³ javascript.0 15:02:37.056 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-23T10:00:01.072Z Gas: 0 m³ javascript.0 15:02:37.056 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-24T10:00:01.053Z Gas: 0 m³ javascript.0 15:02:37.056 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-25T10:00:01.027Z Gas: 0 m³ javascript.0 15:02:37.057 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-26T10:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.058 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-30T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.058 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-31T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.057 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-27T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.057 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-28T10:00:01.029Z Gas: 0 m³ javascript.0 15:02:37.057 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-29T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.058 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-30T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-02T10:00:01.07Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-03T10:00:01.045Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-04T10:00:01.055Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-05T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-06T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-07T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-08T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.058 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-08-31T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.058 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-01T10:00:01.043Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-02T10:00:01.07Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-03T10:00:01.045Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-04T10:00:01.055Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-05T10:00:01.032Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-06T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-07T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-08T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.059 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-09T10:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.060 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-10T10:00:01.028Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-11T10:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-12T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-13T10:00:01.052Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-14T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-15T10:00:01.033Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-16T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-17T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-18T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-19T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-20T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-11T10:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-22T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-23T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-24T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-25T10:00:01.052Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-26T10:00:01.053Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-27T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-28T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-30T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-01T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-02T10:00:01.037Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-03T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-04T10:00:01.027Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-05T10:00:01.052Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-12T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-13T10:00:01.052Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-14T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-15T10:00:01.033Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-16T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-17T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-18T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-19T10:00:01.03Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-20T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.062 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-21T10:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-22T10:00:01.044Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-07T10:00:01.028Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-08T10:00:01.066Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-09T10:00:01.033Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-11T10:00:01.053Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-12T10:00:01.077Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-13T10:00:01.018Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-14T10:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-15T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-16T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-17T10:00:01.027Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-18T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-23T10:00:01.035Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-24T10:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-25T10:00:01.052Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-26T10:00:01.053Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-27T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-28T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-09-30T10:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-01T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-02T10:00:01.037Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-03T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-04T10:00:01.027Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-05T10:00:01.052Z Gas: 0 m³ javascript.0 15:02:37.063 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-06T10:00:01.081Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-07T10:00:01.028Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-21T10:00:01.022Z Gas: 0.08199999999487773 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-22T10:00:01.019Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-24T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-25T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-26T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-27T11:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-28T11:00:01.018Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-29T11:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-30T11:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-31T11:00:01.037Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-01T11:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-08T10:00:01.066Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-09T10:00:01.033Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-10T10:00:01.07Z Gas: -0.3690000088245142 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-11T10:00:01.053Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-12T10:00:01.077Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-13T10:00:01.018Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-14T10:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-15T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-16T10:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-17T10:00:01.027Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-18T10:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-19T10:00:01.042Z Gas: 0.08199999999487773 m³ javascript.0 15:02:37.064 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-20T10:00:01.027Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-21T10:00:01.022Z Gas: 0.08199999999487773 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-22T10:00:01.019Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-23T10:00:01.048Z Gas: 0.7994999999500578 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-24T10:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-25T10:00:01.024Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-26T10:00:01.031Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-27T11:00:01.025Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-28T11:00:01.018Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-29T11:00:01.04Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-30T11:00:01.042Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-10-31T11:00:01.037Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-01T11:00:01.034Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-02T11:00:01.048Z Gas: 0 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-03T11:00:01.02Z Gas: 0.08199999999487773 m³ javascript.0 15:02:37.065 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-04T11:00:01.058Z Gas: 0.40999999997438863 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-05T11:00:01.022Z Gas: 0.4714999999705469 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-06T11:00:01.055Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-07T11:00:01.036Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-08T11:00:01.025Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-09T11:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-11T11:00:01.025Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-13T11:00:01.047Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-06T11:00:01.055Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-16T11:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-07T11:00:01.036Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-08T11:00:01.025Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-09T11:00:01.022Z Gas: 0 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-18T11:00:01.023Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-10T11:00:01.027Z Gas: 0.07174999999551801 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-11T11:00:01.025Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-12T11:00:01.017Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-13T11:00:01.047Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-14T11:00:01.034Z Gas: 0.061499999996158294 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-15T11:00:01.026Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-16T11:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.066 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-17T11:00:01.039Z Gas: 0 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-18T11:00:01.023Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-19T11:00:01.038Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-20T11:00:01.023Z Gas: 1.947499999878346 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-21T11:00:01.023Z Gas: 5.3914999996632105 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-22T11:00:01.022Z Gas: 2.921249999817519 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-23T11:00:01.021Z Gas: 0.6047499999622232 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-24T11:00:01.02Z Gas: 0 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-25T11:00:01.019Z Gas: 0 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-27T11:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-24T11:00:01.02Z Gas: 0 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-25T11:00:01.019Z Gas: 0 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-26T11:00:01.051Z Gas: 0.08199999999487773 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-27T11:00:01.023Z Gas: 0 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-28T11:00:01.046Z Gas: 0 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-29T11:00:01.024Z Gas: 1.4349999999103602 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-11-30T11:00:01.056Z Gas: 3.167249999802152 m³ javascript.0 15:02:37.067 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-01T11:00:01.039Z Gas: 2.449749999846972 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-02T11:00:01.058Z Gas: 0.08199999999487773 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-03T11:00:01.033Z Gas: 0.030749999998079147 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-03T11:00:01.033Z Gas: 0.030749999998079147 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-06T11:00:01.075Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-04T11:00:01.02Z Gas: 0.07174999999551801 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-05T11:00:01.036Z Gas: 0.030749999998079147 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-06T11:00:01.075Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-07T11:00:01.049Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-08T11:00:01.039Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-09T11:00:01.018Z Gas: 0.030749999998079147 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-10T11:00:01.024Z Gas: 0.010249999999359716 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-11T11:00:01.097Z Gas: 0.5087500101217302 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-12T11:00:01.034Z Gas: 1.1069999999308493 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-13T11:00:01.074Z Gas: 3.9154999997554114 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-14T11:00:01.025Z Gas: 3.2902499997944687 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-15T11:00:01.047Z Gas: 0.030749999998079147 m³ javascript.0 15:02:37.068 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-16T11:00:01.026Z Gas: 0 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-17T11:00:01.036Z Gas: 0.02049999999871943 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-18T11:00:01.03Z Gas: 0.09224999999423744 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-19T11:00:01.023Z Gas: 0.05124999999679858 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-20T11:00:01.049Z Gas: 0.030749999998079147 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-21T11:00:01.036Z Gas: 0.04099999999743886 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-22T11:00:01.02Z Gas: 0.11274999999295687 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-23T11:00:01.025Z Gas: 0.10249999999359716 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-24T11:00:01.036Z Gas: 0.09224999999423744 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-25T11:00:01.126Z Gas: 0.042 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-26T11:00:01.035Z Gas: 0.6662499999583815 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-27T11:00:01.027Z Gas: 4.581749999713793 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-28T11:00:01.025Z Gas: 5.637499999647844 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-29T11:00:01.025Z Gas: 5.176249999676656 m³ javascript.0 15:02:37.069 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-30T11:00:01.051Z Gas: 4.725249999704829 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2024-12-31T11:00:01.039Z Gas: 6.406249999599822 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-01T11:00:01.019Z Gas: 0.8097499999494175 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-02T11:00:01.014Z Gas: 0.18449999998847488 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-03T11:00:01.021Z Gas: 1.4247499999110005 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-04T11:00:01.017Z Gas: 2.7982499998252024 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-05T11:00:01.017Z Gas: 3.423499999786145 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-06T11:00:01.013Z Gas: 0.09224999999423744 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-07T11:00:01.013Z Gas: 0.17424999998911517 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-08T11:00:01.013Z Gas: 4.304999999731081 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-09T11:00:01.031Z Gas: 8.732999999454478 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-10T11:00:01.03Z Gas: 7.94374999950378 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-11T11:00:01.014Z Gas: 8.66124999945896 m³ javascript.0 15:02:37.070 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-12T11:00:01.011Z Gas: 5.698999999644002 m³ javascript.0 15:02:37.071 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-13T11:00:01.014Z Gas: 10.936749999316817 m³ javascript.0 15:02:37.071 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-14T11:00:01.029Z Gas: 9.880999999382766 m³ javascript.0 15:02:37.071 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-15T11:00:01.018Z Gas: 1.2914999999193242 m³ javascript.0 15:02:37.071 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-16T11:00:01.021Z Gas: 2.777749999826483 m³ javascript.0 15:02:37.071 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-17T11:00:01.013Z Gas: 8.599749999462801 m³ javascript.0 15:02:37.071 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-18T11:00:01.015Z Gas: 8.30249999948137 m³ javascript.0 15:02:37.071 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-19T11:00:01.016Z Gas: 10.372999999352032 m³ javascript.0 15:02:37.071 info script.js._Test.InfluxDB_SELECT: Zeit: 2025-01-20T11:00:01.016Z Gas: 10.1269999993674 m³ -
@legro Es müssten doch 760 Tage sein und nicht nur 480, oder?
-
Ja, wohl zu früh gefreut.
Ich habe keine Ahnung, was die Lücken hervorruft.In Grafana hingegen fehlt nichts.
Was ist das alles doch für ein Mist.
Wenigstens habe ich's nun geschafft, dass in InfluxDB wohl alle Datensätze angezeigt werden. Man musste hierzu das Aggregieren löschen.
-
Jetzt hoffe ich das Rätsel endgültig gelöst zu haben.
Es sieht ganz danach aus, dass sich ioBroker bei der Ausgabe der Datensätze schlichtweg verschluckt. Ich habe die Datensätze in 35-er Portionen ausgegeben, dabei fehlte nichts.
-
@legro Das hört sich doch gut an. Muss man erst drauf kommen. Besser ist es sowas als Array zu speichern, dann kann man auch besser nachschauen.
-
@mcu sagte in sendTo & InfluxDB -> ???:
@legro .. Besser ist es sowas als Array zu speichern, ..
Das ist auch das Ziel.
Wie ich oben schrieb, möchte ich mich von InfluxDB, Grafana & Co. lösen und stattdessen den FlexCharts-Adapter von @jrbwh verwenden. In einer ersten Stufe möchte ich die in InfluxDB gespeicherten Daten in Arrays einlesen, um sie dem FlexCharts-Adapter zur Anzeige zu übergeben.
In einer zweiten Phase werde ich alle bisher in InfluxDB gespeicherte Daten in einer eigen Datenstruktur ablegen, sodass ich InfluxDB nicht mehr benötige.
-
Mittlerweile bin ich an der Verarbeitung der Daten, die ich mittels sendTo aus InfluxDB ausgelesen habe.
Hier ein Beispiel für die gelieferten Werte ..
[ [ { result: '_result', table: 0, _start: '2023-01-16T07:25:56.533063965Z', _stop: '2023-02-15T07:25:56.533063965Z', _time: '2023-01-23T11:00:01.025Z', _value: 6.949600000079954, _field: 'value', _measurement: 'gasTag', ts: 1674471601025 }, { result: '_result', table: 0, _start: '2023-01-16T07:25:56.533063965Z', _stop: '2023-02-15T07:25:56.533063965Z', _time: '2023-01-24T11:00:01.053Z', _value: 6.713639999830775, _field: 'value', _measurement: 'gasTag', ts: 1674558001053 }, { result: '_result', table: 0, _start: '2023-01-16T07:25:56.533063965Z', _stop: '2023-02-15T07:25:56.533063965Z', _time: '2023-01-25T11:00:01.059Z', _value: 7.05180000008113, _field: 'value', _measurement: 'gasTag', ts: 1674644401059 }, ... ], [ { result: '_result', table: 1, ... }, .. ] ]Das Ergebnis ist ein zweidimensionales Array. Für jede Abfrage (s. table: 0, ..)wird ein Array erzeugt, das wiederum die einzelnen Werte als Objekte in einem (Unter)Array ablegt.
Das Ganze kommt ziemlich aufgeblasen daher. So ist es völlig redundant, stets in jedem Datensatz die Werte table, _start, _stop anzugeben. Sei's d'rum! Man muss sich halt aus dem ganze Zeug die interessierenden Felder in eine eigenes Array umpacken.
-
@legro Für jede Abfrage? Zeig mal bitte die Abfragen. Wofür sind die unterschiedlichen table?
-
@mcu sagte in sendTo & InfluxDB -> ???:
@legro Und als option
options: { end: Date.now(), count: 1000, aggregate: 'onchange' }Das dürfte mit Werten >500 momentan immer noch nicht funktionieren, da Dein PR immer noch nicht übernommen wurde.
https://github.com/ioBroker/ioBroker.influxdb/issues/391
https://github.com/ioBroker/ioBroker.influxdb/pull/392open Update main.js Change count in options #392
-
@wolfi913 Hab ich schon gar nicht mehr dran gedacht. Danke für den Hinweis.
-
@mcu sagte in sendTo & InfluxDB -> ???:
@legro .. Zeig mal bitte die Abfragen. Wofür sind die unterschiedlichen table?
Mir gelang es nur mittels flux vernünftige Ergebnisse zu erzielen. Über 'history' - anstelle von 'query' - erhielt ich nur Unsinn oder gar nichts.
sendTo('influxdb.0', 'query', 'from(bucket: "db_iobroker") |> range(start: -745d, stop: -727d) |> filter(fn: (r) => r._measurement == "gasTag") |> filter(fn: (r) => r["_field"] == "value")', function (query) { let abfrage = JSON.stringify(query.result) let qry = JSON.parse(abfrage) console.log(qry)Man kann mehrere Abfragen in einer query-Anweisung angeben. Diese werden dann in einem zweiten, dritten, .. Array abgespeichert. Die Angabe table reflektiert die jeweilige Abfrage.
Beispiele ..
qry[0][1] -> zweites Objekt {..} in der ersten Abfrage
qry[1][0] -> erstes Objekt in der zweiten Abfrage
qry[0].length -> Anzahl der Elemente in der ersten Abfrage -
@legro Dann bitte auch die Lösung schreiben. danke.
-
Die Lösung steht doch hier. Auch die möglichen Ergebnisse habe ich doch auch angegeben.
-
NACHTRAG
Die Zeitangaben können auch in der üblichen Linux-Notation erfolgen ..
sendTo('influxdb.0', 'query', //'from(bucket: "db_iobroker") |> range(start: -745d, stop: 0d) |> filter(fn: (r) => r._measurement == "gasTag") |> filter(fn: (r) => r["_field"] == "value")', 'from(bucket: "db_iobroker") |> range(start: 2023-01-24T00:00:00Z, stop: 2023-01-30T00:00:00Z) |> filter(fn: (r) => r._measurement == "gasTag") |> filter(fn: (r) => r["_field"] == "value")', function (query) { let qry = JSON.parse(JSON.stringify(query.result)) let werte = [] for (let i=0; i<qry[0].length; i++) { werte.push(qry[0][i]._value) } setState('0_userdata.0.Gaszähler.gasTag_Test', JSON.stringify(werte), true)
