MySQL Werte löschen off-off... on-on... aber nicht on-off oder off-on

DS_Starter · 26 November 2017, 21:14:57

Hallo zusammen,

damit das Ziel/Verfahren ein bisschen griffiger wird habe ich hier mal ein Beispiel damit wir das gleiche Verständnis haben.
Wenn es für einen Tag solche Datensätze gäbe, würden die rot gekennzeichneten Daten gelöscht und die blau gekennzeichneten Daten nach der Behandlung in der Datenbank verbleiben.

Zitat
2017-11-25_00-00-05__eg.az.fridge_Pwr__power 0
2017-11-25_00-02-26__eg.az.fridge_Pwr__power 0
2017-11-25_00-04-33__eg.az.fridge_Pwr__power 0
2017-11-25_00-07-30__eg.az.fridge_Pwr__power 0
2017-11-25_00-10-12__eg.az.fridge_Pwr__power 0
2017-11-25_00-12-40__eg.az.fridge_Pwr__power 0
2017-11-25_00-14-53__eg.az.fridge_Pwr__power 0
2017-11-25_00-17-56__eg.az.fridge_Pwr__power 0
2017-11-25_00-20-44__eg.az.fridge_Pwr__power 0
2017-11-25_00-23-18__eg.az.fridge_Pwr__power 0
2017-11-25_01-06-10__eg.az.fridge_Pwr__power 0
2017-11-25_01-08-21__eg.az.fridge_Pwr__power 0
2017-11-25_01-08-59__eg.az.fridge_Pwr__power 60.32
2017-11-25_01-11-21__eg.az.fridge_Pwr__power 56.26
2017-11-25_01-14-07__eg.az.fridge_Pwr__power 53.24
2017-11-25_01-16-39__eg.az.fridge_Pwr__power 52.64
2017-11-25_01-18-56__eg.az.fridge_Pwr__power 51.75
2017-11-25_01-20-58__eg.az.fridge_Pwr__power 50.52
2017-11-25_01-23-50__eg.az.fridge_Pwr__power 49.08
2017-11-25_01-26-28__eg.az.fridge_Pwr__power 47.94
2017-11-25_01-27-54__eg.az.fridge_Pwr__power 6.19
2017-11-25_01-28-51__eg.az.fridge_Pwr__power 0
2017-11-25_01-31-00__eg.az.fridge_Pwr__power 0
2017-11-25_01-33-59__eg.az.fridge_Pwr__power 0
2017-11-25_02-35-08__eg.az.fridge_Pwr__power 0
2017-11-25_02-37-26__eg.az.fridge_Pwr__power 0
2017-11-25_02-39-29__eg.az.fridge_Pwr__power 0
2017-11-25_02-41-18__eg.az.fridge_Pwr__power 105.28
2017-11-25_02-41-26__eg.az.fridge_Pwr__power 61.52
2017-11-25_02-42-22__eg.az.fridge_Pwr__power 49.55
2017-11-25_02-45-01__eg.az.fridge_Pwr__power 53.96
2017-11-25_02-47-25__eg.az.fridge_Pwr__power 53.04
2017-11-25_02-49-35__eg.az.fridge_Pwr__power 52.35
2017-11-25_02-52-34__eg.az.fridge_Pwr__power 50.85
2017-11-25_02-55-19__eg.az.fridge_Pwr__power 49.45
2017-11-25_02-57-50__eg.az.fridge_Pwr__power 48.37
2017-11-25_03-00-06__eg.az.fridge_Pwr__power 47.46
2017-11-25_03-00-33__eg.az.fridge_Pwr__power 0
2017-11-25_03-02-07__eg.az.fridge_Pwr__power 0
2017-11-25_23-37-42__eg.az.fridge_Pwr__power 0
2017-11-25_23-40-10__eg.az.fridge_Pwr__power 0
2017-11-25_23-42-24__eg.az.fridge_Pwr__power 1
2017-11-25_23-42-24__eg.az.fridge_Pwr__power 1
2017-11-25_23-45-27__eg.az.fridge_Pwr__power 1
2017-11-25_23-47-07__eg.az.fridge_Pwr__power 0
2017-11-25_23-49-42__eg.az.fridge_Pwr__power 0
2017-11-25_23-50-10__eg.az.fridge_Pwr__power 0
2017-11-25_23-52-24__eg.az.fridge_Pwr__power 0
2017-11-25_23-55-27__eg.az.fridge_Pwr__power 0
2017-11-25_23-48-15__eg.az.fridge_Pwr__power 0
2017-11-25_23-50-21__eg.az.fridge_Pwr__power 59.1
2017-11-25_23-50-49__eg.az.fridge_Pwr__power 43.98
2017-11-25_23-53-09__eg.az.fridge_Pwr__power 54.64
2017-11-25_23-55-14__eg.az.fridge_Pwr__power 52.31
2017-11-25_23-58-09__eg.az.fridge_Pwr__power 51.73

D.h. gleiche Datensätze würden nur dann gelöscht wenn sie aufeinanderfolgen, aber nicht vor oder nach einem Wertewechsel und nicht der erste bzw. letzte Wert eines Tages.

Diese Datenbehandlung sehe ich universal, also unabhängig von der Verwendung von Plots, weil man ja z.B. auch Einschaltzeiten/Ausschaltzeiten ermitteln möchte o.ä.
Unsicher bin ich mir noch ob man aufeinander folgende gebrochene Zahlen, z.B. 6 x aufeinander folgende 52.31 löschen sollte. Es könnte ja sein dass zufällig ein solcher Differenzwert aufgezeichnet wurde, der für Auswertungen wichtig wäre.

Grüße
Heiko

supergrobi · 27 November 2017, 08:00:12

Hallo Heiko,

genau so wäre das klasse!

lg
Thomas

DS_Starter · 29 November 2017, 18:34:11

Hallo zusammen,

so, anbei ist eine DbRep-Testversion 6.1.0. (nach 93_DbRep umbenennen)
Es gibt ein neues Kommando:

Code Auswählen

set <name> delSeqDoublets [adviceRemain | adviceDelete | delete]

adviceRemain: mit dieser Option werden die in der DB VERBLEIBENDEN Datensätze als Readings angezeigt (es wird nichts gelöscht !)
adviceRemain: mit dieser Option werden die zur Löschung vorgesehenen Datensätze als Readings angezeigt (es wird nichts gelöscht !)
delete: Damit werden dann die zur Löschungs vorgesehenen Datensätze tatsächlich gelöscht. Das kommt aber erst später und ist noch NICHT implementiert

"delSeqDoublets" steht für löschen sequentieller Doubletten.

Ihr könnt erstmal mit dieser Version nach Herzenslust spielen und probieren.
Je nach verwendeter Option zeigt das Reading "number_fetched_rows" die Anzahl der verbleibenden bzw. die Anzahl der zu löschenden Datensätze an.

Hier ein Beispiel für eine Raw-Definition des DbRep-Devices (die Arbeitsweise von DbRep sollte bekannt sein):

Code Auswählen


defmod Rep.LogDB.delSeqDoublets DbRep LogDB
attr Rep.LogDB.delSeqDoublets allowDeletion 0
attr Rep.LogDB.delSeqDoublets devStateIcon connected:10px-kreis-gelb .*disconnect:10px-kreis-rot .*done:10px-kreis-gruen
attr Rep.LogDB.delSeqDoublets device SMA_Energymeter
attr Rep.LogDB.delSeqDoublets event-on-update-reading state
attr Rep.LogDB.delSeqDoublets reading Einspeisung_Wirkleistung
attr Rep.LogDB.delSeqDoublets room DbLog
attr Rep.LogDB.delSeqDoublets showproctime 1
attr Rep.LogDB.delSeqDoublets timestamp_begin current_week_begin
attr Rep.LogDB.delSeqDoublets timestamp_end previous_day_end
attr Rep.LogDB.delSeqDoublets verbose 4

Natürlich DEF und die Attribute device/reading oder auch "timestamp*" entsprechend eurer Umgebung anpassen.
fhem restart ist wahrscheinlich nötig. Ich hab's noch nicht probiert, aber es sollte auch für SQLite und PostgreSQL funktionieren.

Probierts mal aus und dann schauen wir ob es bei euch auch so reibungslos klappt wie bei mir.
Wenn wir mit diesen Tests durch sind und die Selektionslogik allen verständlich ist und passt, mache ich mich an die delete-Funktion.

EDIT: Passt auf dass ihr nicht zu viele Datensätze im Browser zeigen wollte, könnte ihn lahmlegen.

Grüße
Heiko

DS_Starter · 30 November 2017, 21:41:30

Zur Info, habe die fertig gestellte DbRep-Version hier zur Verfügung gestellt:
https://forum.fhem.de/index.php/topic,53584.0.html

Grüße
Heiko

supergrobi · 03 Dezember 2017, 20:03:02

Besten Dank,
ich werde es mir mal anschauen...

Edit:
nach dem reload 93_DbRep.pm kam das...

Too many arguments for main::createSelectSql at ./FHEM/93_DbRep.pm line 1708, near "'')"
Too many arguments for main::createSelectSql at ./FHEM/93_DbRep.pm line 1710, near "'')"
Too many arguments for main::createSelectSql at ./FHEM/93_DbRep.pm line 1735, near "'')"
BEGIN not safe after errors--compilation aborted at ./FHEM/93_DbRep.pm line 1814.

ist das normal ?

Sascha_F · 09 Dezember 2017, 11:57:18

Hallo zusammen,

wollte gerade die neue Funktion testen.

- beide "advice" funktionieren
- bei delete bekomme ich folgenden Error:
DBD::mysql::st execute failed: called with 2 bind variables when 0 are needed at ./FHEM/93_DbRep.pm line 3954.

Habe folgende Attribute:

- aggregation day
- reading /notifications/Error-01
- timestamp_begin current_year_begin
- timestamp_end current_month_end

Oder funktioniert es mit bestimmten ATTR-Kombinationen nicht?

Nur noch einmal zur Sicherheit: Es bezieht sich immer auf das Reading aus "reading". Wenn ich dieses lösche = alle Datensätze (für sich natürlich, nicht übergreifend^^)?

Danke und viele Grüße
Sascha

DS_Starter · 09 Dezember 2017, 13:47:53

Hallo Sascha,

habe es mal bei mir mit den gleichen Attributen aufgerufen und funktioniert bei mir einwandfrei.
Stelle mal bitte ein verbose 4 Log von dieser Aktion zur Verfügung.

ZitatNur noch einmal zur Sicherheit: Es bezieht sich immer auf das Reading aus "reading". Wenn ich dieses lösche = alle Datensätze (für sich natürlich, nicht übergreifend^^)?

Ja, so ist es.
"Wenn ich dieses lösche = alle Datensätze" -> heißt es werden die jeweils aufeinanderfolgenden Datensätze verglichen. Es werden vorab alle DS selektiert, d.h. keine Einschränkung durch ein Attr reading.

Grüße
Heiko

DS_Starter · 10 Dezember 2017, 11:22:22

@Supergrobi,

sorry hatte ich erst jetzt gesehen:

ZitatEdit:
nach dem reload 93_DbRep.pm kam das...

Too many arguments for main::createSelectSql at ./FHEM/93_DbRep.pm line 1708, near "'')"
Too many arguments for main::createSelectSql at ./FHEM/93_DbRep.pm line 1710, near "'')"
Too many arguments for main::createSelectSql at ./FHEM/93_DbRep.pm line 1735, near "'')"
BEGIN not safe after errors--compilation aborted at ./FHEM/93_DbRep.pm line 1814.

ist das normal ?

Ja, restart wird benötigt !

Grüße
Heiko

Sascha_F · 14 Dezember 2017, 19:35:46

Hallo Heiko,

erst einmal vielen Dank für Deine schnelle Antwort! War auf Dienstreise - aber jetzt kann ich mich wieder 'kümmern'^^

Habe jetzt nur die timestamp geändert (und natürlich Verbose 4).

timestamp_begin "current_year_begin"
timestamp_end "previous_month_end"

Hier das Log:

[code]2017.12.14 19:30:32 4: DbRep DBrep - -------- New selection ---------
2017.12.14 19:30:32 4: DbRep DBrep - Aggregation: day
2017.12.14 19:30:32 4: DbRep DBrep - Command: delSeqDoublets
2017.12.14 19:30:32 4: DbRep DBrep - Timestamp begin human readable: 2017-01-01 00:00:00
2017.12.14 19:30:32 4: DbRep DBrep - Timestamp end human readable: 2017-11-30 23:59:59
2017.12.14 19:30:32 4: DbRep DBrep -> Start BlockingCall delseqdoubl_DoParse
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-01 00:00:00' AND TIMESTAMP < '2017-01-02' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-02' AND TIMESTAMP < '2017-01-03' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-03' AND TIMESTAMP < '2017-01-04' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-04' AND TIMESTAMP < '2017-01-05' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-05' AND TIMESTAMP < '2017-01-06' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-06' AND TIMESTAMP < '2017-01-07' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-07' AND TIMESTAMP < '2017-01-08' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-08' AND TIMESTAMP < '2017-01-09' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-09' AND TIMESTAMP < '2017-01-10' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-10' AND TIMESTAMP < '2017-01-11' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-11' AND TIMESTAMP < '2017-01-12' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-12' AND TIMESTAMP < '2017-01-13' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-13' AND TIMESTAMP < '2017-01-14' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-14' AND TIMESTAMP < '2017-01-15' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-15' AND TIMESTAMP < '2017-01-16' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-16' AND TIMESTAMP < '2017-01-17' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-17' AND TIMESTAMP < '2017-01-18' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-18' AND TIMESTAMP < '2017-01-19' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-19' AND TIMESTAMP < '2017-01-20' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-20' AND TIMESTAMP < '2017-01-21' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-21' AND TIMESTAMP < '2017-01-22' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-22' AND TIMESTAMP < '2017-01-23' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-23' AND TIMESTAMP < '2017-01-24' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-24' AND TIMESTAMP < '2017-01-25' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-25' AND TIMESTAMP < '2017-01-26' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-26' AND TIMESTAMP < '2017-01-27' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-27' AND TIMESTAMP < '2017-01-28' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-28' AND TIMESTAMP < '2017-01-29' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-29' AND TIMESTAMP < '2017-01-30' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-30' AND TIMESTAMP < '2017-01-31' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-01-31' AND TIMESTAMP < '2017-02-01' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-01' AND TIMESTAMP < '2017-02-02' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-02' AND TIMESTAMP < '2017-02-03' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-03' AND TIMESTAMP < '2017-02-04' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-04' AND TIMESTAMP < '2017-02-05' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-05' AND TIMESTAMP < '2017-02-06' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-06' AND TIMESTAMP < '2017-02-07' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-07' AND TIMESTAMP < '2017-02-08' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-08' AND TIMESTAMP < '2017-02-09' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-09' AND TIMESTAMP < '2017-02-10' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-10' AND TIMESTAMP < '2017-02-11' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-11' AND TIMESTAMP < '2017-02-12' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-12' AND TIMESTAMP < '2017-02-13' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-13' AND TIMESTAMP < '2017-02-14' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-14' AND TIMESTAMP < '2017-02-15' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-15' AND TIMESTAMP < '2017-02-16' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-16' AND TIMESTAMP < '2017-02-17' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-17' AND TIMESTAMP < '2017-02-18' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-18' AND TIMESTAMP < '2017-02-19' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-19' AND TIMESTAMP < '2017-02-20' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-20' AND TIMESTAMP < '2017-02-21' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-21' AND TIMESTAMP < '2017-02-22' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-22' AND TIMESTAMP < '2017-02-23' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-23' AND TIMESTAMP < '2017-02-24' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-24' AND TIMESTAMP < '2017-02-25' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-25' AND TIMESTAMP < '2017-02-26' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-26' AND TIMESTAMP < '2017-02-27' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-27' AND TIMESTAMP < '2017-02-28' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-02-28' AND TIMESTAMP < '2017-03-01' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-01' AND TIMESTAMP < '2017-03-02' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-02' AND TIMESTAMP < '2017-03-03' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-03' AND TIMESTAMP < '2017-03-04' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-04' AND TIMESTAMP < '2017-03-05' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-05' AND TIMESTAMP < '2017-03-06' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-06' AND TIMESTAMP < '2017-03-07' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-07' AND TIMESTAMP < '2017-03-08' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-08' AND TIMESTAMP < '2017-03-09' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-09' AND TIMESTAMP < '2017-03-10' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-10' AND TIMESTAMP < '2017-03-11' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-11' AND TIMESTAMP < '2017-03-12' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-12' AND TIMESTAMP < '2017-03-13' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-13' AND TIMESTAMP < '2017-03-14' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-14' AND TIMESTAMP < '2017-03-15' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-15' AND TIMESTAMP < '2017-03-16' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-16' AND TIMESTAMP < '2017-03-17' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-17' AND TIMESTAMP < '2017-03-18' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-18' AND TIMESTAMP < '2017-03-19' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-19' AND TIMESTAMP < '2017-03-20' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-20' AND TIMESTAMP < '2017-03-21' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-21' AND TIMESTAMP < '2017-03-22' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-22' AND TIMESTAMP < '2017-03-23' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-23' AND TIMESTAMP < '2017-03-24' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-24' AND TIMESTAMP < '2017-03-25' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-25' AND TIMESTAMP < '2017-03-26' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-26' AND TIMESTAMP < '2017-03-27' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-27' AND TIMESTAMP < '2017-03-28' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-28' AND TIMESTAMP < '2017-03-29' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-29' AND TIMESTAMP < '2017-03-30' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-30' AND TIMESTAMP < '2017-03-31' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-03-31' AND TIMESTAMP < '2017-04-01' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-01' AND TIMESTAMP < '2017-04-02' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-02' AND TIMESTAMP < '2017-04-03' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-03' AND TIMESTAMP < '2017-04-04' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-04' AND TIMESTAMP < '2017-04-05' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-05' AND TIMESTAMP < '2017-04-06' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-06' AND TIMESTAMP < '2017-04-07' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-07' AND TIMESTAMP < '2017-04-08' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-08' AND TIMESTAMP < '2017-04-09' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-09' AND TIMESTAMP < '2017-04-10' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-10' AND TIMESTAMP < '2017-04-11' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-11' AND TIMESTAMP < '2017-04-12' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-12' AND TIMESTAMP < '2017-04-13' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-13' AND TIMESTAMP < '2017-04-14' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-14' AND TIMESTAMP < '2017-04-15' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-15' AND TIMESTAMP < '2017-04-16' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-16' AND TIMESTAMP < '2017-04-17' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-17' AND TIMESTAMP < '2017-04-18' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-18' AND TIMESTAMP < '2017-04-19' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-19' AND TIMESTAMP < '2017-04-20' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-20' AND TIMESTAMP < '2017-04-21' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-21' AND TIMESTAMP < '2017-04-22' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-22' AND TIMESTAMP < '2017-04-23' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-23' AND TIMESTAMP < '2017-04-24' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-24' AND TIMESTAMP < '2017-04-25' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-25' AND TIMESTAMP < '2017-04-26' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-26' AND TIMESTAMP < '2017-04-27' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-27' AND TIMESTAMP < '2017-04-28' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-28' AND TIMESTAMP < '2017-04-29' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-29' AND TIMESTAMP < '2017-04-30' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-04-30' AND TIMESTAMP < '2017-05-01' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-01' AND TIMESTAMP < '2017-05-02' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-02' AND TIMESTAMP < '2017-05-03' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-03' AND TIMESTAMP < '2017-05-04' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-04' AND TIMESTAMP < '2017-05-05' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-05' AND TIMESTAMP < '2017-05-06' ;
2017.12.14 19:30:32 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-06' AND TIMESTAMP < '2017-05-07' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-07' AND TIMESTAMP < '2017-05-08' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-08' AND TIMESTAMP < '2017-05-09' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-09' AND TIMESTAMP < '2017-05-10' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-10' AND TIMESTAMP < '2017-05-11' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-11' AND TIMESTAMP < '2017-05-12' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-12' AND TIMESTAMP < '2017-05-13' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-13' AND TIMESTAMP < '2017-05-14' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-14' AND TIMESTAMP < '2017-05-15' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-15' AND TIMESTAMP < '2017-05-16' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-16' AND TIMESTAMP < '2017-05-17' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-17' AND TIMESTAMP < '2017-05-18' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-18' AND TIMESTAMP < '2017-05-19' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-19' AND TIMESTAMP < '2017-05-20' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-20' AND TIMESTAMP < '2017-05-21' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-21' AND TIMESTAMP < '2017-05-22' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-22' AND TIMESTAMP < '2017-05-23' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-23' AND TIMESTAMP < '2017-05-24' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-24' AND TIMESTAMP < '2017-05-25' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-25' AND TIMESTAMP < '2017-05-26' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-26' AND TIMESTAMP < '2017-05-27' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-27' AND TIMESTAMP < '2017-05-28' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-28' AND TIMESTAMP < '2017-05-29' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-29' AND TIMESTAMP < '2017-05-30' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-30' AND TIMESTAMP < '2017-05-31' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-05-31' AND TIMESTAMP < '2017-06-01' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-01' AND TIMESTAMP < '2017-06-02' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-02' AND TIMESTAMP < '2017-06-03' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-03' AND TIMESTAMP < '2017-06-04' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-04' AND TIMESTAMP < '2017-06-05' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-05' AND TIMESTAMP < '2017-06-06' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-06' AND TIMESTAMP < '2017-06-07' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-07' AND TIMESTAMP < '2017-06-08' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-08' AND TIMESTAMP < '2017-06-09' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-09' AND TIMESTAMP < '2017-06-10' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-10' AND TIMESTAMP < '2017-06-11' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-11' AND TIMESTAMP < '2017-06-12' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-12' AND TIMESTAMP < '2017-06-13' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-13' AND TIMESTAMP < '2017-06-14' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-14' AND TIMESTAMP < '2017-06-15' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-15' AND TIMESTAMP < '2017-06-16' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-16' AND TIMESTAMP < '2017-06-17' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-17' AND TIMESTAMP < '2017-06-18' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-18' AND TIMESTAMP < '2017-06-19' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-19' AND TIMESTAMP < '2017-06-20' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-20' AND TIMESTAMP < '2017-06-21' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-21' AND TIMESTAMP < '2017-06-22' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-22' AND TIMESTAMP < '2017-06-23' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-23' AND TIMESTAMP < '2017-06-24' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-24' AND TIMESTAMP < '2017-06-25' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-25' AND TIMESTAMP < '2017-06-26' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-26' AND TIMESTAMP < '2017-06-27' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-27' AND TIMESTAMP < '2017-06-28' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-28' AND TIMESTAMP < '2017-06-29' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-29' AND TIMESTAMP < '2017-06-30' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-06-30' AND TIMESTAMP < '2017-07-01' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-01' AND TIMESTAMP < '2017-07-02' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-02' AND TIMESTAMP < '2017-07-03' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-03' AND TIMESTAMP < '2017-07-04' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-04' AND TIMESTAMP < '2017-07-05' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-05' AND TIMESTAMP < '2017-07-06' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-06' AND TIMESTAMP < '2017-07-07' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-07' AND TIMESTAMP < '2017-07-08' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-08' AND TIMESTAMP < '2017-07-09' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-09' AND TIMESTAMP < '2017-07-10' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-10' AND TIMESTAMP < '2017-07-11' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-11' AND TIMESTAMP < '2017-07-12' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-12' AND TIMESTAMP < '2017-07-13' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-13' AND TIMESTAMP < '2017-07-14' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-14' AND TIMESTAMP < '2017-07-15' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-15' AND TIMESTAMP < '2017-07-16' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-16' AND TIMESTAMP < '2017-07-17' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-17' AND TIMESTAMP < '2017-07-18' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-18' AND TIMESTAMP < '2017-07-19' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-19' AND TIMESTAMP < '2017-07-20' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-20' AND TIMESTAMP < '2017-07-21' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-21' AND TIMESTAMP < '2017-07-22' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-22' AND TIMESTAMP < '2017-07-23' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-23' AND TIMESTAMP < '2017-07-24' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-24' AND TIMESTAMP < '2017-07-25' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-25' AND TIMESTAMP < '2017-07-26' ;
2017.12.14 19:30:33 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-26' AND TIMESTAMP < '2017-07-27' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-27' AND TIMESTAMP < '2017-07-28' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-28' AND TIMESTAMP < '2017-07-29' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-29' AND TIMESTAMP < '2017-07-30' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-30' AND TIMESTAMP < '2017-07-31' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-07-31' AND TIMESTAMP < '2017-08-01' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-01' AND TIMESTAMP < '2017-08-02' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-02' AND TIMESTAMP < '2017-08-03' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-03' AND TIMESTAMP < '2017-08-04' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-04' AND TIMESTAMP < '2017-08-05' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-05' AND TIMESTAMP < '2017-08-06' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-06' AND TIMESTAMP < '2017-08-07' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-07' AND TIMESTAMP < '2017-08-08' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-08' AND TIMESTAMP < '2017-08-09' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-09' AND TIMESTAMP < '2017-08-10' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-10' AND TIMESTAMP < '2017-08-11' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-11' AND TIMESTAMP < '2017-08-12' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-12' AND TIMESTAMP < '2017-08-13' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-13' AND TIMESTAMP < '2017-08-14' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-14' AND TIMESTAMP < '2017-08-15' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-15' AND TIMESTAMP < '2017-08-16' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-16' AND TIMESTAMP < '2017-08-17' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-17' AND TIMESTAMP < '2017-08-18' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-18' AND TIMESTAMP < '2017-08-19' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-19' AND TIMESTAMP < '2017-08-20' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications/Error-01' AND TIMESTAMP >= '2017-08-20' AND TIMESTAMP < '2017-08-21' ;
2017.12.14 19:30:34 4: DbRep DBrep - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'Buderus' AND READING = '/notifications

DS_Starter · 14 Dezember 2017, 23:05:38

Hallo Sascha,

an dem Log ist jetzt nichts negatives bzw. sachdienliches zu sehen.
Aber es gibt ein ähnlich gelagertes Problem was wir gerade hier:

https://forum.fhem.de/index.php/topic,53584.msg731293.html#msg731293

diskutieren und was ich momentan noch nicht einordnen kann.
Diese Problematiken kriege ich bei mir bisher nicht nachgestellt und meine Vermutung geht zunächst in Richtung Memory bzw. Hardware Abhängigkeit.
Vielleicht klinkst du dich in dem angegeben Thread mit ein.

Grüße
Heiko

DS_Starter · 15 Dezember 2017, 11:57:47

Hallo Sascha,

habe eine Lösung gefunden:
https://forum.fhem.de/index.php/topic,53584.msg731720.html#msg731720

Grüße
Heiko

Sascha_F · 15 Dezember 2017, 17:40:10

Hallo Heiko,

super, besten Dank! Den Gedanken hatte ich auch schon (rpi3), da ich auch schon mal Probleme bei reducelognbl hatte -> aber dann verworfen, da ich das Problem "damals" mit einem größeren Swap-File beheben konnte...

Viele Grüße
Sascha