Frage zur definition beim statistic-Modul

Begonnen von wowogiengen, 13 August 2025, 10:27:15

Vorheriges Thema - Nächstes Thema
Drucken
Nach unten Seiten1
Benutzer-Aktionen

wowogiengen

13 August 2025, 10:27:15
Hallo,
ich bin leider nicht so gut im Devices anlegen und managen...
Vor ein paar Tagen ist mir leider aufgefallen, dass sowohl meine SD-Karte für den raspi, als auch das Backup, welches ich eigentlich
jeden Monat mache, nicht mehr funktioniert.

Habe inzwischen beides am Laufen, und habe eine etwas ältere Sicherung einspielen müssen.

Dabei ist mir jetzt heute aufgefallen, dass das Statistik-Modul nicht mehr alle Werte berücksichtigt:

Code Auswählen
define myStatDevice statistics HzgThermostat.*|HzgAktor.*
attr myStatDevice DbLogInclude .*
attr myStatDevice durationPeriodHour 1
attr myStatDevice durationReadings level
attr myStatDevice minAvgMaxReadings measured-temp
attr myStatDevice room Büro,DbLog,System
attr myStatDevice singularReadings HzgThermostat.*:measured-temp:Avg:(Hour|Day|Month)|HzgAktor.*:level:DurationState:(Hour|Day|Month)\

attr myStatDevice verbose 2
#   DEF        HzgThermostat.*|HzgAktor.*
#   DEV_REGEXP HzgThermostat.*|HzgAktor.*
#   FUUID      65ab9864-f33f-a625-db6b-b1f16d1f973052d0
#   NAME       myStatDevice
#   NOTIFYDEV  global,HzgThermostat.*|HzgAktor.*
#   NR         225
#   NTFY_ORDER 10-myStatDevice
#   PREFIX     stat
#   STATE      Updated stats for: HzgThermostatToilette
#   TYPE       statistics
#   eventCount 27511
#   READINGS:
#     2025-08-10 10:15:33   monitoredDevicesCUL_HM HzgThermostatHWR,HzgAktorBad,HzgAktorBuero,HzgAktorFlur,HzgAktorSchlafzimmer,HzgAktorToilette,HzgAktorWohnzimmer,HzgThermostatBad,HzgThermostatBad_remote,HzgThermostatBuero,HzgThermostatFlur,HzgThermostatSchlafzimmer,HzgThermostatToilette,HzgThermostatWohnzimmer
#     2025-08-10 10:15:33   monitoredDevicesnotify HzgThermostatBuero_notify_1
#     2025-08-13 09:59:55   nextPeriodChangeCalc 2025-08-13 10:59:55
#     2025-08-13 10:22:50   state           Updated stats for: HzgThermostatToilette
#   fhem:
#     modulVersion $Date: 2024-05-18 09:37:34 +0200 (Sat, 18 May 2024) $
#     nextPeriodChangeTime 1755075595
#
setstate myStatDevice Updated stats for: HzgThermostatToilette
setstate myStatDevice 2025-08-13 10:15:01 .HzgAktorBad:levelDay 100_Count: 5 0_Count: 6 100: 397 (since: 2024-03-28_16:57:23) lastTime: 1755072901 0: 36509 showDate: 0 lastState: 0
setstate myStatDevice 2025-08-13 10:15:01 .HzgAktorBad:levelHour 0: 898 showDate: 0 lastState: 0 0_Count: 2 100_Count: 1 lastTime: 1755072901 100: 8 (since: 2024-03-28_16:57:23)
setstate myStatDevice 2025-08-13 10:15:01 .HzgAktorBad:levelMonth 0_Count: 37 100_Count: 36 lastTime: 1755072901 100: 5401 (since: 2024-03-28_16:57:23) 0: 1068305 showDate: 0 lastState: 0
setstate myStatDevice 2025-08-13 10:15:01 .HzgAktorBad:levelYear lastTime: 1755072901 (since: 2024-03-28_16:57:23) 100: 1117243 0_Count: 1537 100_Count: 1537 lastState: 0 showDate: 1 0: 42314215
setstate myStatDevice 2025-08-13 10:19:02 .HzgAktorBuero:levelDay (since: 2024-03-28_16:57:42) 100: 1354 lastTime: 1755073142 100_Count: 5 0_Count: 6 lastState: 0 showDate: 0 0: 35793
setstate myStatDevice 2025-08-13 10:19:02 .HzgAktorBuero:levelHour 0_Count: 2 100_Count: 1 lastTime: 1755073142 100: 249 (since: 2024-03-28_16:57:42) 0: 898 showDate: 0 lastState: 0
setstate myStatDevice 2025-08-13 10:19:02 .HzgAktorBuero:levelMonth (since: 2024-03-28_16:57:42) 100: 8124 lastTime: 1755073142 100_Count: 37 0_Count: 38 lastState: 0 showDate: 0 0: 1065823
setstate myStatDevice 2025-08-13 10:19:02 .HzgAktorBuero:levelYear showDate: 1 0: 43241476 lastState: 0 100_Count: 1344 0_Count: 1345 (since: 2024-03-28_16:57:42) 100: 190204 lastTime: 1755073142
setstate myStatDevice 2025-08-13 10:20:02 .HzgAktorFlur:levelDay 0_Count: 6 100_Count: 5 lastTime: 1755073202 100: 896 (since: 2024-03-28_16:57:24) 0: 36311 showDate: 0 lastState: 0
setstate myStatDevice 2025-08-13 10:20:02 .HzgAktorFlur:levelHour 100_Count: 1 0_Count: 2 (since: 2024-03-28_16:57:24) 100: 308 lastTime: 1755073202 showDate: 0 0: 899 lastState: 0
setstate myStatDevice 2025-08-13 10:20:02 .HzgAktorFlur:levelMonth lastTime: 1755073202 (since: 2024-03-28_16:57:24) 100: 6242 0_Count: 36 100_Count: 35 lastState: 0 showDate: 0 0: 1067765
setstate myStatDevice 2025-08-13 10:20:02 .HzgAktorFlur:levelYear showDate: 1 0: 43197761 lastState: 0 0_Count: 1338 100_Count: 1337 lastTime: 1755073202 (since: 2024-03-28_16:57:24) 100: 233997
setstate myStatDevice 2025-08-13 10:17:01 .HzgAktorSchlafzimmer:levelDay 0: 35955 showDate: 0 lastState: 0 100_Count: 5 0_Count: 6 100: 1071 (since: 2024-03-28_16:56:20) lastTime: 1755073021
setstate myStatDevice 2025-08-13 10:17:01 .HzgAktorSchlafzimmer:levelHour lastState: 0 0: 899 showDate: 0 lastTime: 1755073021 100: 127 (since: 2024-03-28_16:56:20) 0_Count: 2 100_Count: 1
setstate myStatDevice 2025-08-13 10:17:01 .HzgAktorSchlafzimmer:levelMonth lastState: 0 showDate: 0 0: 1066986 (since: 2024-03-28_16:56:20) 100: 6840 lastTime: 1755073021 100_Count: 33 0_Count: 34
setstate myStatDevice 2025-08-13 10:17:01 .HzgAktorSchlafzimmer:levelYear 100_Count: 1330 0_Count: 1330 (since: 2024-03-28_16:56:20) 100: 287967 lastTime: 1755073021 showDate: 1 0: 43143674 lastState: 0
setstate myStatDevice 2024-03-28 16:56:20 .HzgAktorSchlafzimmer:stateDay (since: 2024-03-28_16:56:20) showDate: 1 on_Count: 1 on: 0 lastState: on lastTime: 1711641380
setstate myStatDevice 2024-03-28 16:56:20 .HzgAktorSchlafzimmer:stateHour (since: 2024-03-28_16:56:20) showDate: 1 on: 0 lastState: on on_Count: 1 lastTime: 1711641380
setstate myStatDevice 2024-03-28 16:56:20 .HzgAktorSchlafzimmer:stateMonth lastTime: 1711641380 on_Count: 1 on: 0 lastState: on (since: 2024-03-28_16:56:20) showDate: 1
setstate myStatDevice 2024-03-28 16:56:20 .HzgAktorSchlafzimmer:stateYear (since: 2024-03-28_16:56:20) showDate: 1 on_Count: 1 on: 0 lastState: on lastTime: 1711641380
setstate myStatDevice 2025-08-13 10:18:01 .HzgAktorToilette:levelDay 0: 36089 showDate: 0 lastState: 0 100_Count: 5 0_Count: 6 100: 997 (since: 2024-03-28_16:57:26) lastTime: 1755073081
setstate myStatDevice 2025-08-13 10:18:01 .HzgAktorToilette:levelHour 0: 900 showDate: 0 lastState: 0 100_Count: 1 0_Count: 2 100: 186 (since: 2024-03-28_16:57:26) lastTime: 1755073081
setstate myStatDevice 2025-08-13 10:18:01 .HzgAktorToilette:levelMonth lastState: 0 0: 1067826 showDate: 0 100: 6060 (since: 2024-03-28_16:57:26) lastTime: 1755073081 100_Count: 33 0_Count: 34
setstate myStatDevice 2025-08-13 10:18:01 .HzgAktorToilette:levelYear lastTime: 1755073081 (since: 2024-03-28_16:57:26) 100: 255203 0_Count: 1330 100_Count: 1329 lastState: 0 showDate: 1 0: 43176432
setstate myStatDevice 2025-08-13 10:16:01 .HzgAktorWohnzimmer:levelDay showDate: 0 0: 36196 lastState: 0 0_Count: 6 100_Count: 5 lastTime: 1755072961 (since: 2024-03-28_16:57:20) 100: 770
setstate myStatDevice 2025-08-13 10:16:01 .HzgAktorWohnzimmer:levelHour (since: 2024-03-28_16:57:20) 100: 66 lastTime: 1755072961 100_Count: 1 0_Count: 2 lastState: 0 showDate: 0 0: 900
setstate myStatDevice 2025-08-13 10:16:01 .HzgAktorWohnzimmer:levelMonth lastTime: 1755072961 100: 4187 (since: 2024-03-28_16:57:20) 0_Count: 39 100_Count: 38 lastState: 0 0: 1069579 showDate: 0
setstate myStatDevice 2025-08-13 10:16:01 .HzgAktorWohnzimmer:levelYear lastState: 0 0: 42375489 showDate: 1 100: 1056032 (since: 2024-03-28_16:57:20) lastTime: 1755072961 100_Count: 2040 0_Count: 2040
setstate myStatDevice 2024-03-28 16:57:20 .HzgAktorWohnzimmer:stateDay on_Count: 1 lastState: on on: 0 showDate: 1 (since: 2024-03-28_16:57:20) lastTime: 1711641440
setstate myStatDevice 2024-03-28 16:57:20 .HzgAktorWohnzimmer:stateHour lastTime: 1711641440 showDate: 1 (since: 2024-03-28_16:57:20) on_Count: 1 lastState: on on: 0
setstate myStatDevice 2024-03-28 16:57:20 .HzgAktorWohnzimmer:stateMonth (since: 2024-03-28_16:57:20) showDate: 1 on: 0 lastState: on on_Count: 1 lastTime: 1711641440
setstate myStatDevice 2024-03-28 16:57:20 .HzgAktorWohnzimmer:stateYear showDate: 1 (since: 2024-03-28_16:57:20) lastState: on on: 0 on_Count: 1 lastTime: 1711641440
setstate myStatDevice 2025-08-13 10:22:08 .HzgThermostatBad:measured-tempDay Sum: 960397.6 Time: 37333 LastValue: 25.9 LastTime: 1755073328 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:08 .HzgThermostatBad:measured-tempHour Sum: 34524.7 Time: 1333 LastValue: 25.9 LastTime: 1755073328 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:08 .HzgThermostatBad:measured-tempMonth Sum: 25965297.6 Time: 1074133 LastValue: 25.9 LastTime: 1755073328 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:08 .HzgThermostatBad:measured-tempYear Sum: 1016035417.5 Time: 43431623 LastValue: 25.9 LastTime: 1755073328 ShowDate: 1 DecPlaces: 1
setstate myStatDevice 2024-03-28 16:59:44 .HzgThermostatBad:stateDay (since: 2024-03-28_16:58:08) CMDs_processing...: 11 RESPONSE_TIMEOUT:RegisterRead: 3 ResndFail: 0 CMDs_done_Errors:1: 0 RESPONSE_TIMEOUT:RegisterRead_Count: 1 ResndFail_Count: 1 CMDs_done_Errors:1_Count: 1 CMDs_pending: 82 showDate: 1 CMDs_pending_Count: 3 lastState: CMDs_pending lastTime: 1711641584 CMDs_processing..._Count: 2
setstate myStatDevice 2024-03-28 16:59:44 .HzgThermostatBad:stateHour lastState: CMDs_pending CMDs_pending_Count: 3 showDate: 1 CMDs_processing..._Count: 2 lastTime: 1711641584 RESPONSE_TIMEOUT:RegisterRead: 3 CMDs_processing...: 11 (since: 2024-03-28_16:58:08) CMDs_pending: 82 CMDs_done_Errors:1_Count: 1 ResndFail_Count: 1 RESPONSE_TIMEOUT:RegisterRead_Count: 1 CMDs_done_Errors:1: 0 ResndFail: 0
setstate myStatDevice 2024-03-28 16:59:44 .HzgThermostatBad:stateMonth CMDs_processing..._Count: 2 lastTime: 1711641584 showDate: 1 lastState: CMDs_pending CMDs_pending_Count: 3 RESPONSE_TIMEOUT:RegisterRead_Count: 1 CMDs_done_Errors:1: 0 ResndFail: 0 CMDs_pending: 82 CMDs_done_Errors:1_Count: 1 ResndFail_Count: 1 CMDs_processing...: 11 (since: 2024-03-28_16:58:08) RESPONSE_TIMEOUT:RegisterRead: 3
setstate myStatDevice 2024-03-28 16:59:44 .HzgThermostatBad:stateYear (since: 2024-03-28_16:58:08) CMDs_processing...: 11 RESPONSE_TIMEOUT:RegisterRead: 3 ResndFail: 0 CMDs_done_Errors:1: 0 RESPONSE_TIMEOUT:RegisterRead_Count: 1 ResndFail_Count: 1 CMDs_done_Errors:1_Count: 1 CMDs_pending: 82 showDate: 1 CMDs_pending_Count: 3 lastState: CMDs_pending lastTime: 1711641584 CMDs_processing..._Count: 2
setstate myStatDevice 2025-08-13 09:59:55 .HzgThermostatBad_remote:stateDay showDate: 0 lastState: unpeered unpeered_Count: 1 unpeered: 36000 (since: 2024-03-28_16:56:25) lastTime: 1755071995
setstate myStatDevice 2025-08-13 09:59:55 .HzgThermostatBad_remote:stateHour lastTime: 1755071995 (since: 2024-03-28_16:56:25) unpeered_Count: 1 unpeered: 0 lastState: unpeered showDate: 0
setstate myStatDevice 2025-08-13 09:59:55 .HzgThermostatBad_remote:stateMonth lastState: unpeered unpeered_Count: 1 unpeered: 1072800 showDate: 0 (since: 2024-03-28_16:56:25) lastTime: 1755071995
setstate myStatDevice 2025-08-13 09:59:55 .HzgThermostatBad_remote:stateYear lastTime: 1755071995 (since: 2024-03-28_16:56:25) unpeered: 43430610 unpeered_Count: 1 lastState: unpeered showDate: 1
setstate myStatDevice 2025-08-13 10:22:06 .HzgThermostatBuero:measured-tempDay Sum: 966830.9 Time: 37331 LastValue: 26.2 LastTime: 1755073326 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:06 .HzgThermostatBuero:measured-tempHour Sum: 34759.1 Time: 1331 LastValue: 26.2 LastTime: 1755073326 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:06 .HzgThermostatBuero:measured-tempMonth Sum: 27188962.8 Time: 1074131 LastValue: 26.2 LastTime: 1755073326 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:06 .HzgThermostatBuero:measured-tempYear Sum: 1079240158.8 Time: 43430970 LastValue: 26.2 LastTime: 1755073326 ShowDate: 1 DecPlaces: 1
setstate myStatDevice 2025-08-13 09:59:55 .HzgThermostatBuero_notify_1:stateDay showDate: 0 lastState: active lastTime: 1755071995 active: 36000 (since: 2024-03-28_16:56:25) active_Count: 1
setstate myStatDevice 2025-08-13 09:59:55 .HzgThermostatBuero_notify_1:stateHour active: 0 lastTime: 1755071995 active_Count: 1 (since: 2024-03-28_16:56:25) showDate: 0 lastState: active
setstate myStatDevice 2025-08-13 09:59:55 .HzgThermostatBuero_notify_1:stateMonth showDate: 0 lastState: active lastTime: 1755071995 active: 1072800 (since: 2024-03-28_16:56:25) active_Count: 1
setstate myStatDevice 2025-08-13 09:59:55 .HzgThermostatBuero_notify_1:stateYear lastState: active showDate: 1 lastTime: 1755071995 active: 43430610 (since: 2024-03-28_16:56:25) active_Count: 1
setstate myStatDevice 2025-08-13 10:22:00 .HzgThermostatFlur:measured-tempDay Sum: 1032522.3 Time: 37325 LastValue: 27.8 LastTime: 1755073320 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:00 .HzgThermostatFlur:measured-tempHour Sum: 36779.7 Time: 1325 LastValue: 27.8 LastTime: 1755073320 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:00 .HzgThermostatFlur:measured-tempMonth Sum: 27328954.3 Time: 1074124 LastValue: 27.8 LastTime: 1755073320 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:00 .HzgThermostatFlur:measured-tempYear Sum: 1059959121.2 Time: 43431669 LastValue: 27.8 LastTime: 1755073320 ShowDate: 1 DecPlaces: 1
setstate myStatDevice 2024-03-28 16:59:04 .HzgThermostatFlur:stateDay CMDs_pending: 0 CMDs_done: 36 CMDs_processing...: 1 CMDs_done_Count: 1 (since: 2024-03-28_16:58:27) CMDs_processing..._Count: 1 lastTime: 1711641544 lastState: CMDs_done CMDs_pending_Count: 1 showDate: 1
setstate myStatDevice 2024-03-28 16:59:04 .HzgThermostatFlur:stateHour (since: 2024-03-28_16:58:27) CMDs_done_Count: 1 CMDs_processing...: 1 CMDs_done: 36 CMDs_pending: 0 showDate: 1 lastState: CMDs_done CMDs_pending_Count: 1 lastTime: 1711641544 CMDs_processing..._Count: 1
setstate myStatDevice 2024-03-28 16:59:04 .HzgThermostatFlur:stateMonth CMDs_done: 36 (since: 2024-03-28_16:58:27) CMDs_processing...: 1 CMDs_done_Count: 1 CMDs_pending: 0 CMDs_pending_Count: 1 lastState: CMDs_done showDate: 1 lastTime: 1711641544 CMDs_processing..._Count: 1
setstate myStatDevice 2024-03-28 16:59:04 .HzgThermostatFlur:stateYear CMDs_processing..._Count: 1 lastTime: 1711641544 lastState: CMDs_done CMDs_pending_Count: 1 showDate: 1 CMDs_pending: 0 CMDs_done: 36 CMDs_done_Count: 1 CMDs_processing...: 1 (since: 2024-03-28_16:58:27)
setstate myStatDevice 2025-08-13 10:21:38 .HzgThermostatHWR:measured-tempDay Sum: 1006159 Time: 37303 LastValue: 27.2 LastTime: 1755073298 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:21:38 .HzgThermostatHWR:measured-tempHour Sum: 35327.6 Time: 1303 LastValue: 27.2 LastTime: 1755073298 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:21:38 .HzgThermostatHWR:measured-tempMonth Sum: 27618631.8 Time: 1074102 LastValue: 27.2 LastTime: 1755073298 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:21:38 .HzgThermostatHWR:measured-tempYear Sum: 1094846628.2 Time: 43431203 LastValue: 27.2 LastTime: 1755073298 ShowDate: 1 DecPlaces: 1
setstate myStatDevice 2024-03-28 17:06:25 .HzgThermostatHWR:stateDay lastTime: 1711641985 CMDs_pending: 492 CMDs_processing...: 0 CMDs_processing..._Count: 1 CMDs_pending_Count: 2 showDate: 1 (since: 2024-03-28_16:58:13) lastState: CMDs_pending
setstate myStatDevice 2024-03-28 17:06:25 .HzgThermostatHWR:stateHour lastTime: 1711641985 CMDs_pending: 390 lastState: CMDs_pending CMDs_pending_Count: 1 showDate: 0 (since: 2024-03-28_16:58:13)
setstate myStatDevice 2024-03-28 17:06:25 .HzgThermostatHWR:stateMonth CMDs_pending: 492 lastTime: 1711641985 CMDs_processing..._Count: 1 CMDs_processing...: 0 (since: 2024-03-28_16:58:13) showDate: 1 CMDs_pending_Count: 2 lastState: CMDs_pending
setstate myStatDevice 2024-03-28 17:06:25 .HzgThermostatHWR:stateYear CMDs_processing...: 0 CMDs_processing..._Count: 1 lastTime: 1711641985 CMDs_pending: 492 lastState: CMDs_pending CMDs_pending_Count: 2 (since: 2024-03-28_16:58:13) showDate: 1
setstate myStatDevice 2025-08-13 10:21:48 .HzgThermostatSchlafzimmer:measured-tempDay Sum: 947098.9 Time: 37313 LastValue: 25.6 LastTime: 1755073308 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:21:48 .HzgThermostatSchlafzimmer:measured-tempHour Sum: 33573.4 Time: 1313 LastValue: 25.6 LastTime: 1755073308 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:21:48 .HzgThermostatSchlafzimmer:measured-tempMonth Sum: 26737301.6 Time: 1074112 LastValue: 25.6 LastTime: 1755073308 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:21:48 .HzgThermostatSchlafzimmer:measured-tempYear Sum: 1064935687.7 Time: 43430832 LastValue: 25.6 LastTime: 1755073308 ShowDate: 1 DecPlaces: 1
setstate myStatDevice 2024-03-28 17:12:47 .HzgThermostatSchlafzimmer:stateDay showDate: 1 (since: 2024-03-28_16:58:15) CMDs_pending_Count: 1 lastState: CMDs_done CMDs_done: 871 CMDs_pending: 0 lastTime: 1711642367 CMDs_processing..._Count: 1 CMDs_done_Count: 1 CMDs_processing...: 1
setstate myStatDevice 2024-03-28 17:12:47 .HzgThermostatSchlafzimmer:stateHour (since: 2024-03-28_16:58:15) showDate: 0 lastState: CMDs_done CMDs_done: 772 lastTime: 1711642367 CMDs_done_Count: 1
setstate myStatDevice 2024-03-28 17:12:47 .HzgThermostatSchlafzimmer:stateMonth CMDs_processing...: 1 CMDs_done_Count: 1 CMDs_processing..._Count: 1 lastTime: 1711642367 CMDs_pending: 0 CMDs_done: 871 lastState: CMDs_done CMDs_pending_Count: 1 showDate: 1 (since: 2024-03-28_16:58:15)
setstate myStatDevice 2024-03-28 17:12:47 .HzgThermostatSchlafzimmer:stateYear CMDs_done: 871 lastState: CMDs_done (since: 2024-03-28_16:58:15) showDate: 1 CMDs_pending_Count: 1 CMDs_processing..._Count: 1 CMDs_done_Count: 1 CMDs_processing...: 1 CMDs_pending: 0 lastTime: 1711642367
setstate myStatDevice 2025-08-13 10:22:50 .HzgThermostatToilette:measured-tempDay Sum: 977094.1 Time: 37374 LastValue: 26.1 LastTime: 1755073370 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:50 .HzgThermostatToilette:measured-tempHour Sum: 35887.5 Time: 1375 LastValue: 26.1 LastTime: 1755073370 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:50 .HzgThermostatToilette:measured-tempMonth Sum: 25705779.8 Time: 1074174 LastValue: 26.1 LastTime: 1755073370 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:22:50 .HzgThermostatToilette:measured-tempYear Sum: 1014460219 Time: 43412117 LastValue: 26.1 LastTime: 1755073370 ShowDate: 1 DecPlaces: 1
setstate myStatDevice 2024-03-28 22:25:55 .HzgThermostatToilette:stateDay CMDs_done: 60 lastTime: 1711661155 RESPONSE_TIMEOUT:RegisterRead: 4 CMDs_done_Count: 1 CMDs_done_Errors:1: 0 (since: 2024-03-28_16:58:16) CMDs_pending: 19556 ResndFail_Count: 1 CMDs_processing...: 39 RESPONSE_TIMEOUT:RegisterRead_Count: 1 showDate: 1 CMDs_pending_Count: 3 ResndFail: 0 lastState: CMDs_done CMDs_done_Errors:1_Count: 1 CMDs_processing..._Count: 3
setstate myStatDevice 2024-03-28 22:25:55 .HzgThermostatToilette:stateHour CMDs_processing..._Count: 1 lastState: CMDs_done CMDs_pending_Count: 1 showDate: 0 CMDs_processing...: 25 CMDs_pending: 1475 (since: 2024-03-28_16:58:16) CMDs_done_Count: 1 lastTime: 1711661155 CMDs_done: 60
setstate myStatDevice 2024-03-28 22:25:55 .HzgThermostatToilette:stateMonth (since: 2024-03-28_16:58:16) CMDs_done_Count: 1 RESPONSE_TIMEOUT:RegisterRead: 4 CMDs_done_Errors:1: 0 lastTime: 1711661155 CMDs_done: 60 lastState: CMDs_done CMDs_done_Errors:1_Count: 1 CMDs_processing..._Count: 3 CMDs_pending_Count: 3 ResndFail: 0 showDate: 1 CMDs_pending: 19556 ResndFail_Count: 1 RESPONSE_TIMEOUT:RegisterRead_Count: 1 CMDs_processing...: 39
setstate myStatDevice 2024-03-28 22:25:55 .HzgThermostatToilette:stateYear lastTime: 1711661155 CMDs_done: 60 (since: 2024-03-28_16:58:16) CMDs_done_Errors:1: 0 RESPONSE_TIMEOUT:RegisterRead: 4 CMDs_done_Count: 1 showDate: 1 CMDs_processing...: 39 RESPONSE_TIMEOUT:RegisterRead_Count: 1 CMDs_pending: 19556 ResndFail_Count: 1 CMDs_processing..._Count: 3 lastState: CMDs_done CMDs_done_Errors:1_Count: 1 ResndFail: 0 CMDs_pending_Count: 3
setstate myStatDevice 2025-08-13 10:21:03 .HzgThermostatWohnzimmer:measured-tempDay Sum: 964311.8 Time: 37268 LastValue: 26.6 LastTime: 1755073263 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:21:03 .HzgThermostatWohnzimmer:measured-tempHour Sum: 33660.3 Time: 1268 LastValue: 26.6 LastTime: 1755073263 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:21:03 .HzgThermostatWohnzimmer:measured-tempMonth Sum: 27845834.3 Time: 1074067 LastValue: 26.6 LastTime: 1755073263 ShowDate: 0 DecPlaces: 1
setstate myStatDevice 2025-08-13 10:21:03 .HzgThermostatWohnzimmer:measured-tempYear Sum: 1114316918.4 Time: 43429857 LastValue: 26.6 LastTime: 1755073263 ShowDate: 1 DecPlaces: 1
setstate myStatDevice 2024-03-28 17:28:15 .HzgThermostatWohnzimmer:stateDay CMDs_done_Errors:1_Count: 1 ResndFail_Count: 1 showDate: 1 CMDs_pending_Count: 3 lastState: CMDs_pending (since: 2024-03-28_16:58:17) CMDs_processing..._Count: 2 lastTime: 1711643295 CMDs_done_Errors:1: 0 RESPONSE_TIMEOUT:PeerList: 1 ResndFail: 0 RESPONSE_TIMEOUT:PeerList_Count: 1 CMDs_processing...: 13 CMDs_pending: 1784
setstate myStatDevice 2024-03-28 17:28:15 .HzgThermostatWohnzimmer:stateHour CMDs_pending: 1700 lastTime: 1711643295 (since: 2024-03-28_16:58:17) showDate: 0 CMDs_pending_Count: 1 lastState: CMDs_pending
setstate myStatDevice 2024-03-28 17:28:15 .HzgThermostatWohnzimmer:stateMonth (since: 2024-03-28_16:58:17) lastState: CMDs_pending CMDs_pending_Count: 3 showDate: 1 ResndFail_Count: 1 CMDs_done_Errors:1_Count: 1 CMDs_processing...: 13 CMDs_pending: 1784 RESPONSE_TIMEOUT:PeerList_Count: 1 ResndFail: 0 RESPONSE_TIMEOUT:PeerList: 1 lastTime: 1711643295 CMDs_done_Errors:1: 0 CMDs_processing..._Count: 2
setstate myStatDevice 2024-03-28 17:28:15 .HzgThermostatWohnzimmer:stateYear CMDs_pending: 1784 CMDs_processing...: 13 RESPONSE_TIMEOUT:PeerList_Count: 1 ResndFail: 0 RESPONSE_TIMEOUT:PeerList: 1 CMDs_done_Errors:1: 0 lastTime: 1711643295 CMDs_processing..._Count: 2 (since: 2024-03-28_16:58:17) lastState: CMDs_pending showDate: 1 CMDs_pending_Count: 3 ResndFail_Count: 1 CMDs_done_Errors:1_Count: 1
setstate myStatDevice 2025-08-10 10:15:33 monitoredDevicesCUL_HM HzgThermostatHWR,HzgAktorBad,HzgAktorBuero,HzgAktorFlur,HzgAktorSchlafzimmer,HzgAktorToilette,HzgAktorWohnzimmer,HzgThermostatBad,HzgThermostatBad_remote,HzgThermostatBuero,HzgThermostatFlur,HzgThermostatSchlafzimmer,HzgThermostatToilette,HzgThermostatWohnzimmer
setstate myStatDevice 2025-08-10 10:15:33 monitoredDevicesnotify HzgThermostatBuero_notify_1
setstate myStatDevice 2025-08-13 09:59:55 nextPeriodChangeCalc 2025-08-13 10:59:55
setstate myStatDevice 2025-08-13 10:22:50 state Updated stats for: HzgThermostatToilette


oder vielleicht liegts auch am DBLog-Modul?

Code Auswählen
define mySQLDB DbLog ./mySQLDB.conf HzgThermostat.*:statMeasured-temp.*AvgLast|HzgAktor.*:statLevel.*Last
attr mySQLDB .* 1
attr mySQLDB DbLogSelectionMode Exclude/Include
attr mySQLDB DbLogType Current/History
attr mySQLDB asyncMode 1
attr mySQLDB cacheLimit 1500
attr mySQLDB event-on-change-reading CacheUsage
attr mySQLDB insertMode 1
attr mySQLDB room Büro,DbLog,LogFiles,System
attr mySQLDB showNotifyTime 0
attr mySQLDB showproctime 1
attr mySQLDB stateFormat {\
"Cache: ".ReadingsVal($name,"CacheUsage",0)."<br> NextSync:".ReadingsVal($name,"NextSync",0)\
}
attr mySQLDB syncInterval 240
attr mySQLDB verbose 5
attr mySQLDB webCmd listCache:commitCache
#   COLUMNS    field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
#   CONFIGURATION ./mySQLDB.conf
#   DEF        ./mySQLDB.conf HzgThermostat.*:statMeasured-temp.*AvgLast|HzgAktor.*:statLevel.*Last
#   FD         4
#   FUUID      5ed93474-f33f-a625-5c2b-b4f6628ef5ffc1ff
#   FVERSION   93_DbLog.pm:v5.11.0-s29401/2024-12-05
#   MODE       asynchronous
#   MODEL      MYSQL
#   NAME       mySQLDB
#   NOTIFYDEV  HzgAktor.*,HzgThermostat.*
#   NR         2
#   NTFY_ORDER 50-mySQLDB
#   PID        43921
#   REGEXP     HzgThermostat.*:statMeasured-temp.*AvgLast|HzgAktor.*:statLevel.*Last
#   SBP_PID    43934
#   SBP_STATE  running
#   STATE      Cache: 0<br> NextSync:2025-08-13 10:27:29 or when CacheUsage 1500 is reached
#   TYPE       DbLog
#   dbconn     mysql:database=fhem;host=192.168.188.6;port=3307
#   dbuser     fhemdbuser
#   eventCount 2
#   HELPER:
#     COLSET     1
#     DEVICECOL  64
#     EVENTCOL   512
#     OLDSTATE   connected
#     PACKAGE    main
#     READINGCOL 64
#     TC         current
#     TH         history
#     TYPECOL    64
#     UNITCOL    32
#     VALUECOL   128
#     VERSION    5.11.0
#   OLDREADINGS:
#   READINGS:
#     2025-08-13 10:03:29   CacheOverflowLastNum 0
#     2024-03-28 17:00:16   CacheOverflowLastState normal
#     2025-08-13 10:23:29   CacheUsage      0
#     2025-08-13 10:23:29   NextSync        2025-08-13 10:27:29 or when CacheUsage 1500 is reached
#     2025-08-13 10:03:29   background_processing_time 0.1972
#     2025-08-13 10:03:29   sql_processing_time 0.1924
#     2025-08-13 10:23:29   state           connected
#
setstate mySQLDB Cache: 0<br> NextSync:2025-08-13 10:27:29 or when CacheUsage 1500 is reached
setstate mySQLDB 2025-08-13 10:03:29 CacheOverflowLastNum 0
setstate mySQLDB 2024-03-28 17:00:16 CacheOverflowLastState normal
setstate mySQLDB 2025-08-13 10:23:29 CacheUsage 0
setstate mySQLDB 2025-08-13 10:23:29 NextSync 2025-08-13 10:27:29 or when CacheUsage 1500 is reached
setstate mySQLDB 2025-08-13 10:03:29 background_processing_time 0.1972
setstate mySQLDB 2025-08-13 10:03:29 sql_processing_time 0.1924
setstate mySQLDB 2025-08-13 10:23:29 state connected


Ich weiß nicht, wo ich suchen soll, die Werte für die HzgAktor.*- Devices fehlen in der Datenbank, seit ich die Sicherung eingespielt habe... :-(

Vielleicht kann mir hier jemand schnell helfen?

Viele Grüße
Wolfgang


wowogiengen

#1
13 August 2025, 11:26:06
Hallo,
ich habe es jetzt wohl geschafft, dass einige Werte wieder in die DB kommen:

Code Auswählen
define mySQLDB DbLog ./mySQLDB.conf HzgThermostat.*:statMeasured-temp.*AvgLast|HzgAktor.*:statLevel.*Last.*|HzgThermostat.*:.*measured-temp.*
aber die Werte mit _0 und _100 fehlen mir trotzdem:

heute:
Code Auswählen
18284314 2025-08-13 10:59:55.000 HzgAktorWohnzimmer CUL_HM statLevelHourLast: 0: 00:58:54 0_Count: 2 100: 00:01:06 100_Count: 1 statLevelHourLast 0: 00:58:54 0_Count: 2 100: 00:01:06 100_Count: 1
18284313 2025-08-13 10:59:55.000 HzgAktorToilette CUL_HM statLevelHourLast: 0: 00:56:54 0_Count: 2 100: 00:03:06 100_Count: 1 statLevelHourLast 0: 00:56:54 0_Count: 2 100: 00:03:06 100_Count: 1
18284312 2025-08-13 10:59:55.000 HzgAktorSchlafzimmer CUL_HM statLevelHourLast: 0: 00:57:53 0_Count: 2 100: 00:02:07 100_Count: 1 statLevelHourLast 0: 00:57:53 0_Count: 2 100: 00:02:07 100_Count: 1
18284311 2025-08-13 10:59:55.000 HzgAktorFlur CUL_HM statLevelHourLast: 0: 00:54:52 0_Count: 2 100: 00:05:08 100_Count: 1 statLevelHourLast 0: 00:54:52 0_Count: 2 100: 00:05:08 100_Count: 1
18284310 2025-08-13 10:59:55.000 HzgAktorBuero CUL_HM statLevelHourLast: 0: 00:55:44 0_Count: 9 100: 00:04:16 100_Count: 8 statLevelHourLast 0: 00:55:44 0_Count: 9 100: 00:04:16 100_Count: 8
18284309 2025-08-13 10:59:55.000 HzgAktorBad CUL_HM statLevelHourLast: 0: 00:58:40 0_Count: 12 100: 00:01:20 100_Count: 11 statLevelHourLast 0: 00:58:40 0_Count: 12 100: 00:01:20 100_Count: 11

vor dem neu aufsetzen:
Code Auswählen
18256710 2025-08-08 22:59:55.000 HzgAktorWohnzimmer CUL_HM statLevelHourLast_100: 0 statLevelHourLast_100 0
18256709 2025-08-08 22:59:55.000 HzgAktorWohnzimmer CUL_HM statLevelHourLast_0: 3600 statLevelHourLast_0 3600
18256708 2025-08-08 22:59:55.000 HzgAktorWohnzimmer CUL_HM statLevelHourLast: 0: 01:00:00 0_Count: 1 statLevelHourLast 0: 01:00:00 0_Count: 1
18256707 2025-08-08 22:59:55.000 HzgAktorToilette CUL_HM statLevelHourLast_100: 0 statLevelHourLast_100 0
18256706 2025-08-08 22:59:55.000 HzgAktorToilette CUL_HM statLevelHourLast_0: 3600 statLevelHourLast_0 3600
18256705 2025-08-08 22:59:55.000 HzgAktorToilette CUL_HM statLevelHourLast: 0: 01:00:00 0_Count: 1 statLevelHourLast 0: 01:00:00 0_Count: 1
Drucken
Nach oben Seiten1
Benutzer-Aktionen