API tools faq
paste
Advertisement
doreinie

Untitled

doreinie
May 1st, 2023
21
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 88.79 KB | None | 0 0
raw download clone embed print report
  1. 21:59:53:884 Bind response success for 0x086bd7fffe532bf5 ep: 0x01 cluster: 0x0006
  2. 21:59:53:986 ZCL configure reporting rsp seq: 15 0x086BD7FFFE532BF5 for ep: 0x01 cluster: 0x0006 attr: 0x0000 status: 0x00
  3. 21:59:54:104 Bind response success for 0x086bd7fffe532bf5 ep: 0x01 cluster: 0x0008
  4. 21:59:54:217 ZCL configure reporting rsp seq: 16 0x086BD7FFFE532BF5 for ep: 0x01 cluster: 0x0008 attr: 0x0000 status: 0x00
  5. 21:59:54:922 poll node cc:cc:cc:ff:fe:b1:9d:d3-01
  6. 21:59:54:923 Poll light node Schlafzimmer Schrank links
  7. 21:59:54:973 read attributes of 0xCCCCCCFFFEB19DD3 cluster: 0x0006: [
  8. 21:59:54:974 0x0000
  9. 21:59:54:974 ]
  10. 21:59:54:975 add task 118 type 19 to 0xCCCCCCFFFEB19DD3 cluster 0x0006 req.id 216
  11. 21:59:54:975 Poll APS request 216 to 0xCCCCCCFFFEB19DD3 cluster: 0x0006
  12. 21:59:55:045 Poll APS confirm 216 status: 0x00
  13. 21:59:55:046 Erase task req-id: 216, type: 19 zcl seqno: 17 send time 0, profileId: 0x0104, clusterId: 0x0006
  14. 21:59:55:088 Node data 0xccccccfffeb19dd3 profileId: 0x0104, clusterId: 0x0006
  15. 21:59:55:089 0xCCCCCCFFFEB19DD3: update ZCL value 0x01/0x0006/0x0000 after 0 s
  16. 21:59:55:423 Wait 4s till query finished
  17. 21:59:55:922 poll node cc:cc:cc:ff:fe:b3:e2:08-01
  18. 21:59:55:923 Poll light node Büro Schrank rechts
  19. 21:59:55:972 read attributes of 0xCCCCCCFFFEB3E208 cluster: 0x0006: [
  20. 21:59:55:973 0x0000
  21. 21:59:55:973 ]
  22. 21:59:55:973 add task 123 type 19 to 0xCCCCCCFFFEB3E208 cluster 0x0006 req.id 226
  23. 21:59:55:973 Poll APS request 226 to 0xCCCCCCFFFEB3E208 cluster: 0x0006
  24. 21:59:56:050 Poll APS confirm 226 status: 0x00
  25. 21:59:56:051 Erase task req-id: 226, type: 19 zcl seqno: 19 send time 0, profileId: 0x0104, clusterId: 0x0006
  26. 21:59:56:063 Node data 0xccccccfffeb3e208 profileId: 0x0104, clusterId: 0x0006
  27. 21:59:56:065 0xCCCCCCFFFEB3E208: update ZCL value 0x01/0x0006/0x0000 after 0 s
  28. 21:59:56:250 read attributes of 0xCCCCCCFFFEB3E208 cluster: 0x0008: [
  29. 21:59:56:250 0x0000
  30. 21:59:56:251 ]
  31. 21:59:56:251 add task 125 type 19 to 0xCCCCCCFFFEB3E208 cluster 0x0008 req.id 229
  32. 21:59:56:252 Poll APS request 229 to 0xCCCCCCFFFEB3E208 cluster: 0x0008
  33. 21:59:56:345 Poll APS confirm 229 status: 0x00
  34. 21:59:56:346 Erase task req-id: 229, type: 19 zcl seqno: 20 send time 0, profileId: 0x0104, clusterId: 0x0008
  35. 21:59:56:363 Node data 0xccccccfffeb3e208 profileId: 0x0104, clusterId: 0x0008
  36. 21:59:56:364 0xCCCCCCFFFEB3E208: update ZCL value 0x01/0x0008/0x0000 after 0 s
  37. 21:59:56:423 Wait 3s till query finished
  38. 21:59:56:922 poll node d0:cf:5e:ff:fe:da:67:32-01
  39. 21:59:56:923 Poll light node Schlafzimmer Schrank rechts
  40. 21:59:56:972 read attributes of 0xD0CF5EFFFEDA6732 cluster: 0x0006: [
  41. 21:59:56:972 0x0000
  42. 21:59:56:973 ]
  43. 21:59:56:973 add task 129 type 19 to 0xD0CF5EFFFEDA6732 cluster 0x0006 req.id 234
  44. 21:59:56:973 Poll APS request 234 to 0xD0CF5EFFFEDA6732 cluster: 0x0006
  45. 21:59:57:055 Poll APS confirm 234 status: 0x00
  46. 21:59:57:057 Erase task req-id: 234, type: 19 zcl seqno: 21 send time 0, profileId: 0x0104, clusterId: 0x0006
  47. 21:59:57:124 Node data 0xd0cf5efffeda6732 profileId: 0x0104, clusterId: 0x0006
  48. 21:59:57:126 0xD0CF5EFFFEDA6732: update ZCL value 0x01/0x0006/0x0000 after 0 s
  49. 21:59:57:423 Wait 2s till query finished
  50. 21:59:57:989 poll node 08:6b:d7:ff:fe:53:2b:f5-01
  51. 21:59:57:989 Poll light node Büro Schrank links
  52. 21:59:58:037 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0006 dropped, values are fresh enough
  53. 21:59:58:325 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0008 dropped, values are fresh enough
  54. 21:59:58:423 Wait 1s till query finished
  55. 21:59:58:669 Websocket 192.168.178.38:46604 send message: {"attr":{"id":"53","lastannounced":null,"lastseen":"2023-05-01T19:59Z","manufacturername":"Konke","modelid":"3AFE280100510001","name":"Switch 53","swversion":null,"type":"ZHASwitch","uniqueid":"14:b4:57:ff:fe:07:59:64-01-0006"},"e":"changed","id":"53","r":"sensors","t":"event","uniqueid":"14:b4:57:ff:fe:07:59:64-01-0006"} (ret = -1098623944)
  56. 21:59:58:694 APS-DATA.indication from child 0xD3F6
  57. 21:59:58:696 expression: Item.val=(ZclFrame.at(3)-121)*1000+2 --> 7002
  58. 21:59:58:697 [INFO] - No button map for: 3AFE280100510001, unicast to: 0x0000, endpoint: 0x01, cluster: ONOFF (0x0006), command: ATTRIBUTE_REPORT (0x0A), payload: 00001080, zclSeq: 37
  59. 21:59:58:698 ZCL attribute report 0x14B457FFFE075964 for cluster: 0x0006, ep: 0x01, frame control: 0x08, mfcode: 0x0000
  60. 21:59:58:698 payload: 00001080
  61. 21:59:58:700 Websocket 192.168.178.38:46604 send message: {"e":"changed","id":"53","r":"sensors","state":{"buttonevent":7002,"lastupdated":"2023-05-01T19:59:58.696"},"t":"event","uniqueid":"14:b4:57:ff:fe:07:59:64-01-0006"} (ret = -1098625096)
  62. 21:59:58:997 poll node cc:cc:cc:ff:fe:b1:9d:d3-01
  63. 21:59:58:998 Poll light node Schlafzimmer Schrank links
  64. 21:59:59:050 read attributes of 0xCCCCCCFFFEB19DD3 cluster: 0x0006: [
  65. 21:59:59:052 0x0000
  66. 21:59:59:053 ]
  67. 21:59:59:054 add task 136 type 19 to 0xCCCCCCFFFEB19DD3 cluster 0x0006 req.id 246
  68. 21:59:59:054 Poll APS request 246 to 0xCCCCCCFFFEB19DD3 cluster: 0x0006
  69. 21:59:59:145 Poll APS confirm 246 status: 0x00
  70. 21:59:59:146 Erase task req-id: 246, type: 19 zcl seqno: 23 send time 0, profileId: 0x0104, clusterId: 0x0006
  71. 21:59:59:177 Node data 0xccccccfffeb19dd3 profileId: 0x0104, clusterId: 0x0006
  72. 21:59:59:178 0xCCCCCCFFFEB19DD3: update ZCL value 0x01/0x0006/0x0000 after 0 s
  73. 21:59:59:422 Idle timer triggered
  74. 21:59:59:423 create binding for attribute reporting of cluster 0x0000
  75. 21:59:59:423 queue binding task for 0xCCCCCCFFFEB3E208, cluster 0x0000
  76. 21:59:59:424 update ddf TRADFRI Driver 10W index 226
  77. 21:59:59:425 create binding for attribute reporting of cluster 0x0006
  78. 21:59:59:425 queue binding task for 0xCCCCCCFFFEB3E208, cluster 0x0006
  79. 21:59:59:426 update ddf TRADFRI Driver 10W index 226
  80. 21:59:59:427 create binding for attribute reporting of cluster 0x0008
  81. 21:59:59:428 queue binding task for 0xCCCCCCFFFEB3E208, cluster 0x0008
  82. 21:59:59:429 update ddf TRADFRI Driver 10W index 226
  83. 21:59:59:430 Force binding of attribute reporting for node Büro Schrank rechts
  84. 21:59:59:430 Force read attributes for ZHAOpenClose SensorNode Bad Balkontür unten
  85. 22:00:00:068 poll node cc:cc:cc:ff:fe:b3:e2:08-01
  86. 22:00:00:069 Poll light node Büro Schrank rechts
  87. 22:00:00:120 read attributes of 0xCCCCCCFFFEB3E208 cluster: 0x0006: [
  88. 22:00:00:121 0x0000
  89. 22:00:00:121 ]
  90. 22:00:00:122 add task 138 type 19 to 0xCCCCCCFFFEB3E208 cluster 0x0006 req.id 249
  91. 22:00:00:122 Poll APS request 249 to 0xCCCCCCFFFEB3E208 cluster: 0x0006
  92. 22:00:00:174 Poll APS confirm 249 status: 0x00
  93. 22:00:00:175 Erase task req-id: 249, type: 19 zcl seqno: 24 send time 0, profileId: 0x0104, clusterId: 0x0006
  94. 22:00:00:210 Node data 0xccccccfffeb3e208 profileId: 0x0104, clusterId: 0x0006
  95. 22:00:00:212 0xCCCCCCFFFEB3E208: update ZCL value 0x01/0x0006/0x0000 after 0 s
  96. 22:00:00:416 read attributes of 0xCCCCCCFFFEB3E208 cluster: 0x0008: [
  97. 22:00:00:417 0x0000
  98. 22:00:00:418 ]
  99. 22:00:00:419 add task 139 type 19 to 0xCCCCCCFFFEB3E208 cluster 0x0008 req.id 251
  100. 22:00:00:419 Poll APS request 251 to 0xCCCCCCFFFEB3E208 cluster: 0x0008
  101. 22:00:00:449 Wait 3s till query finished
  102. 22:00:00:502 Poll APS confirm 251 status: 0x00
  103. 22:00:00:502 Erase task req-id: 251, type: 19 zcl seqno: 25 send time 0, profileId: 0x0104, clusterId: 0x0008
  104. 22:00:00:521 Node data 0xccccccfffeb3e208 profileId: 0x0104, clusterId: 0x0008
  105. 22:00:00:522 0xCCCCCCFFFEB3E208: update ZCL value 0x01/0x0008/0x0000 after 0 s
  106. 22:00:00:709 APS-DATA.indication from child 0xD3F6
  107. 22:00:01:093 poll node d0:cf:5e:ff:fe:da:67:32-01
  108. 22:00:01:093 Poll light node Schlafzimmer Schrank rechts
  109. 22:00:01:142 read attributes of 0xD0CF5EFFFEDA6732 cluster: 0x0006: [
  110. 22:00:01:142 0x0000
  111. 22:00:01:143 ]
  112. 22:00:01:143 add task 143 type 19 to 0xD0CF5EFFFEDA6732 cluster 0x0006 req.id 2
  113. 22:00:01:144 Poll APS request 2 to 0xD0CF5EFFFEDA6732 cluster: 0x0006
  114. 22:00:01:422 Wait 2s till query finished
  115. 22:00:01:723 Poll APS confirm 2 status: 0x00
  116. 22:00:01:724 Erase task req-id: 2, type: 19 zcl seqno: 27 send time 1, profileId: 0x0104, clusterId: 0x0006
  117. 22:00:01:724 APS-DATA.indication from child 0xD3F6
  118. 22:00:01:773 APS-DATA.indication from child 0xD3F6
  119. 22:00:01:775 expression: Item.val=(ZclFrame.at(3)-121)*1000+2 --> 8002
  120. 22:00:01:776 [INFO] - No button map for: 3AFE280100510001, unicast to: 0x0000, endpoint: 0x01, cluster: ONOFF (0x0006), command: ATTRIBUTE_REPORT (0x0A), payload: 00001081, zclSeq: 38
  121. 22:00:01:777 ZCL attribute report 0x14B457FFFE075964 for cluster: 0x0006, ep: 0x01, frame control: 0x08, mfcode: 0x0000
  122. 22:00:01:778 payload: 00001081
  123. 22:00:01:780 Websocket 192.168.178.38:46604 send message: {"e":"changed","id":"53","r":"sensors","state":{"buttonevent":8002,"lastupdated":"2023-05-01T20:00:01.774"},"t":"event","uniqueid":"14:b4:57:ff:fe:07:59:64-01-0006"} (ret = -1098625096)
  124. 22:00:01:813 Node data 0xd0cf5efffeda6732 profileId: 0x0104, clusterId: 0x0006
  125. 22:00:01:815 0xD0CF5EFFFEDA6732: update ZCL value 0x01/0x0006/0x0000 after 0 s
  126. 22:00:02:423 Wait 1s till query finished
  127. 22:00:02:598 poll node 08:6b:d7:ff:fe:53:2b:f5-01
  128. 22:00:02:599 Poll light node Büro Schrank links
  129. 22:00:02:650 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0006 dropped, values are fresh enough
  130. 22:00:02:722 APS-DATA.indication from child 0xD3F6
  131. 22:00:02:937 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0008 dropped, values are fresh enough
  132. 22:00:03:423 poll node cc:cc:cc:ff:fe:b1:9d:d3-01
  133. 22:00:03:424 Poll light node Schlafzimmer Schrank links
  134. 22:00:03:425 Idle timer triggered
  135. 22:00:03:426 create binding for attribute reporting of cluster 0x0000
  136. 22:00:03:427 queue binding task for 0xD0CF5EFFFEDA6732, cluster 0x0000
  137. 22:00:03:428 update ddf TRADFRI Driver 30W index 225
  138. 22:00:03:429 create binding for attribute reporting of cluster 0x0006
  139. 22:00:03:430 queue binding task for 0xD0CF5EFFFEDA6732, cluster 0x0006
  140. 22:00:03:431 update ddf TRADFRI Driver 30W index 225
  141. 22:00:03:433 binding for cluster 0x0008 of 0xD0CF5EFFFEDA6732 exists (verified by reporting)
  142. 22:00:03:434 update ddf TRADFRI Driver 30W index 225
  143. 22:00:03:436 skip configure report for cluster: 0x0008 attr: 0x0000 of node 0xD0CF5EFFFEDA6732 (seems to be active)
  144. 22:00:03:437 Force binding of attribute reporting for node Schlafzimmer Schrank rechts
  145. 22:00:03:438 Force read attributes for ZHAOpenClose SensorNode Window / Door Sensor Spare
  146. 22:00:03:657 read attributes of 0xCCCCCCFFFEB19DD3 cluster: 0x0006: [
  147. 22:00:03:658 0x0000
  148. 22:00:03:658 ]
  149. 22:00:03:659 add task 152 type 19 to 0xCCCCCCFFFEB19DD3 cluster 0x0006 req.id 20
  150. 22:00:03:660 Poll APS request 20 to 0xCCCCCCFFFEB19DD3 cluster: 0x0006
  151. 22:00:03:728 APS-DATA.indication from child 0xD3F6
  152. 22:00:03:754 Poll APS confirm 20 status: 0x00
  153. 22:00:03:755 Erase task req-id: 20, type: 19 zcl seqno: 32 send time 0, profileId: 0x0104, clusterId: 0x0006
  154. 22:00:03:785 Node data 0xccccccfffeb19dd3 profileId: 0x0104, clusterId: 0x0006
  155. 22:00:03:786 0xCCCCCCFFFEB19DD3: update ZCL value 0x01/0x0006/0x0000 after 0 s
  156. 22:00:04:422 Daylight now: nauticalDusk, status: 220, daylight: 0, dark: 1
  157. 22:00:04:424 Wait 3s till query finished
  158. 22:00:04:620 poll node cc:cc:cc:ff:fe:b3:e2:08-01
  159. 22:00:04:621 Poll light node Büro Schrank rechts
  160. 22:00:04:673 read attributes of 0xCCCCCCFFFEB3E208 cluster: 0x0006: [
  161. 22:00:04:674 0x0000
  162. 22:00:04:675 ]
  163. 22:00:04:675 add task 157 type 19 to 0xCCCCCCFFFEB3E208 cluster 0x0006 req.id 30
  164. 22:00:04:676 Poll APS request 30 to 0xCCCCCCFFFEB3E208 cluster: 0x0006
  165. 22:00:04:749 APS-DATA.indication from child 0xD3F6
  166. 22:00:04:783 Poll APS confirm 30 status: 0x00
  167. 22:00:04:784 Erase task req-id: 30, type: 19 zcl seqno: 34 send time 0, profileId: 0x0104, clusterId: 0x0006
  168. 22:00:04:791 Node data 0xccccccfffeb3e208 profileId: 0x0104, clusterId: 0x0006
  169. 22:00:04:794 0xCCCCCCFFFEB3E208: update ZCL value 0x01/0x0006/0x0000 after 0 s
  170. 22:00:04:010 read attributes of 0xCCCCCCFFFEB3E208 cluster: 0x0008: [
  171. 22:00:04:010 0x0000
  172. 22:00:04:011 ]
  173. 22:00:04:012 add task 159 type 19 to 0xCCCCCCFFFEB3E208 cluster 0x0008 req.id 35
  174. 22:00:05:012 Poll APS request 35 to 0xCCCCCCFFFEB3E208 cluster: 0x0008
  175. 22:00:05:064 Poll APS confirm 35 status: 0x00
  176. 22:00:05:065 Erase task req-id: 35, type: 19 zcl seqno: 36 send time 0, profileId: 0x0104, clusterId: 0x0008
  177. 22:00:05:082 Node data 0xccccccfffeb3e208 profileId: 0x0104, clusterId: 0x0008
  178. 22:00:05:084 0xCCCCCCFFFEB3E208: update ZCL value 0x01/0x0008/0x0000 after 0 s
  179. 22:00:05:422 Wait 2s till query finished
  180. 22:00:05:707 poll node d0:cf:5e:ff:fe:da:67:32-01
  181. 22:00:05:708 Poll light node Schlafzimmer Schrank rechts
  182. 22:00:05:746 APS-DATA.indication from child 0xD3F6
  183. 22:00:05:761 read attributes of 0xD0CF5EFFFEDA6732 cluster: 0x0006: [
  184. 22:00:05:764 0x0000
  185. 22:00:05:766 ]
  186. 22:00:05:766 add task 163 type 19 to 0xD0CF5EFFFEDA6732 cluster 0x0006 req.id 42
  187. 22:00:05:767 Poll APS request 42 to 0xD0CF5EFFFEDA6732 cluster: 0x0006
  188. 22:00:05:864 Poll APS confirm 42 status: 0x00
  189. 22:00:05:865 Erase task req-id: 42, type: 19 zcl seqno: 37 send time 0, profileId: 0x0104, clusterId: 0x0006
  190. 22:00:05:933 Node data 0xd0cf5efffeda6732 profileId: 0x0104, clusterId: 0x0006
  191. 22:00:05:934 0xD0CF5EFFFEDA6732: update ZCL value 0x01/0x0006/0x0000 after 0 s
  192. 22:00:06:423 Wait 1s till query finished
  193. 22:00:06:747 APS-DATA.indication from child 0xD3F6
  194. 22:00:06:821 poll node 08:6b:d7:ff:fe:53:2b:f5-01
  195. 22:00:06:822 Poll light node Büro Schrank links
  196. 22:00:06:873 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0006 dropped, values are fresh enough
  197. 22:00:07:189 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0008 dropped, values are fresh enough
  198. 22:00:07:422 Wait 0s till query finished
  199. 22:00:07:923 poll node d0:cf:5e:ff:fe:da:67:32-01
  200. 22:00:07:923 Poll light node Schlafzimmer Schrank rechts
  201. 22:00:07:972 read attributes of 0xD0CF5EFFFEDA6732 cluster: 0x0006: [
  202. 22:00:07:973 0x0000
  203. 22:00:07:974 ]
  204. 22:00:07:975 add task 173 type 19 to 0xD0CF5EFFFEDA6732 cluster 0x0006 req.id 57
  205. 22:00:07:975 Poll APS request 57 to 0xD0CF5EFFFEDA6732 cluster: 0x0006
  206. 22:00:08:053 Poll APS confirm 57 status: 0x00
  207. 22:00:08:055 Erase task req-id: 57, type: 19 zcl seqno: 39 send time 0, profileId: 0x0104, clusterId: 0x0006
  208. 22:00:08:120 Node data 0xd0cf5efffeda6732 profileId: 0x0104, clusterId: 0x0006
  209. 22:00:08:121 0xD0CF5EFFFEDA6732: update ZCL value 0x01/0x0006/0x0000 after 0 s
  210. 22:00:08:422 poll node 08:6b:d7:ff:fe:53:2b:f5-01
  211. 22:00:08:423 Poll light node Büro Schrank links
  212. 22:00:08:424 Idle timer triggered
  213. 22:00:08:424 create binding for attribute reporting of cluster 0x0000
  214. 22:00:08:425 queue binding task for 0xCCCCCCFFFEB19DD3, cluster 0x0000
  215. 22:00:08:426 update ddf TRADFRI Driver 30W index 225
  216. 22:00:08:427 create binding for attribute reporting of cluster 0x0006
  217. 22:00:08:427 queue binding task for 0xCCCCCCFFFEB19DD3, cluster 0x0006
  218. 22:00:08:428 update ddf TRADFRI Driver 30W index 225
  219. 22:00:08:429 binding for cluster 0x0008 of 0xCCCCCCFFFEB19DD3 exists (verified by reporting)
  220. 22:00:08:430 update ddf TRADFRI Driver 30W index 225
  221. 22:00:08:432 skip configure report for cluster: 0x0008 attr: 0x0000 of node 0xCCCCCCFFFEB19DD3 (seems to be active)
  222. 22:00:08:432 Force binding of attribute reporting for node Schlafzimmer Schrank links
  223. 22:00:08:433 Force read attributes for ZHAOpenClose SensorNode Bad Balkontür oben
  224. 22:00:08:486 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0006 dropped, values are fresh enough
  225. 22:00:08:781 APS-DATA.indication from child 0xD3F6
  226. 22:00:08:782 expression: Item.val=(ZclFrame.at(3)-121)*1000+2 --> 7002
  227. 22:00:08:784 [INFO] - No button map for: 3AFE280100510001, unicast to: 0x0000, endpoint: 0x01, cluster: ONOFF (0x0006), command: ATTRIBUTE_REPORT (0x0A), payload: 00001080, zclSeq: 41
  228. 22:00:08:785 ZCL attribute report 0x14B457FFFE075964 for cluster: 0x0006, ep: 0x01, frame control: 0x08, mfcode: 0x0000
  229. 22:00:08:785 payload: 00001080
  230. 22:00:08:786 Websocket 192.168.178.38:46604 send message: {"e":"changed","id":"53","r":"sensors","state":{"buttonevent":7002,"lastupdated":"2023-05-01T20:00:08.782"},"t":"event","uniqueid":"14:b4:57:ff:fe:07:59:64-01-0006"} (ret = -1098625096)
  231. 22:00:08:809 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0008 dropped, values are fresh enough
  232. 22:00:09:423 Wait 3s till query finished
  233. 22:00:09:496 poll node cc:cc:cc:ff:fe:b1:9d:d3-01
  234. 22:00:09:497 Poll light node Schlafzimmer Schrank links
  235. 22:00:09:545 read attributes of 0xCCCCCCFFFEB19DD3 cluster: 0x0006: [
  236. 22:00:09:546 0x0000
  237. 22:00:09:546 ]
  238. 22:00:09:547 add task 180 type 19 to 0xCCCCCCFFFEB19DD3 cluster 0x0006 req.id 67
  239. 22:00:09:548 Poll APS request 67 to 0xCCCCCCFFFEB19DD3 cluster: 0x0006
  240. 22:00:09:651 Poll APS confirm 67 status: 0x00
  241. 22:00:09:652 Erase task req-id: 67, type: 19 zcl seqno: 41 send time 0, profileId: 0x0104, clusterId: 0x0006
  242. 22:00:09:685 Node data 0xccccccfffeb19dd3 profileId: 0x0104, clusterId: 0x0006
  243. 22:00:09:686 0xCCCCCCFFFEB19DD3: update ZCL value 0x01/0x0006/0x0000 after 0 s
  244. 22:00:09:777 APS-DATA.indication from child 0xD3F6
  245. 22:00:10:422 Wait 2s till query finished
  246. 22:00:10:526 poll node cc:cc:cc:ff:fe:b3:e2:08-01
  247. 22:00:10:527 Poll light node Büro Schrank rechts
  248. 22:00:10:574 read attributes of 0xCCCCCCFFFEB3E208 cluster: 0x0006: [
  249. 22:00:10:576 0x0000
  250. 22:00:10:576 ]
  251. 22:00:10:577 add task 185 type 19 to 0xCCCCCCFFFEB3E208 cluster 0x0006 req.id 76
  252. 22:00:10:578 Poll APS request 76 to 0xCCCCCCFFFEB3E208 cluster: 0x0006
  253. 22:00:10:653 Poll APS confirm 76 status: 0x00
  254. 22:00:10:654 Erase task req-id: 76, type: 19 zcl seqno: 42 send time 0, profileId: 0x0104, clusterId: 0x0006
  255. 22:00:10:675 Node data 0xccccccfffeb3e208 profileId: 0x0104, clusterId: 0x0006
  256. 22:00:10:677 0xCCCCCCFFFEB3E208: update ZCL value 0x01/0x0006/0x0000 after 0 s
  257. 22:00:10:860 read attributes of 0xCCCCCCFFFEB3E208 cluster: 0x0008: [
  258. 22:00:10:861 0x0000
  259. 22:00:10:861 ]
  260. 22:00:10:862 add task 187 type 19 to 0xCCCCCCFFFEB3E208 cluster 0x0008 req.id 80
  261. 22:00:10:862 Poll APS request 80 to 0xCCCCCCFFFEB3E208 cluster: 0x0008
  262. 22:00:10:951 Poll APS confirm 80 status: 0x00
  263. 22:00:10:952 Erase task req-id: 80, type: 19 zcl seqno: 44 send time 0, profileId: 0x0104, clusterId: 0x0008
  264. 22:00:10:966 Node data 0xccccccfffeb3e208 profileId: 0x0104, clusterId: 0x0008
  265. 22:00:10:967 0xCCCCCCFFFEB3E208: update ZCL value 0x01/0x0008/0x0000 after 0 s
  266. 22:00:11:422 Wait 1s till query finished
  267. 22:00:11:538 poll node d0:cf:5e:ff:fe:da:67:32-01
  268. 22:00:11:539 Poll light node Schlafzimmer Schrank rechts
  269. 22:00:11:586 read attributes of 0xD0CF5EFFFEDA6732 cluster: 0x0006: [
  270. 22:00:11:587 0x0000
  271. 22:00:11:588 ]
  272. 22:00:11:589 add task 191 type 19 to 0xD0CF5EFFFEDA6732 cluster 0x0006 req.id 85
  273. 22:00:11:590 Poll APS request 85 to 0xD0CF5EFFFEDA6732 cluster: 0x0006
  274. 22:00:11:650 Poll APS confirm 85 status: 0x00
  275. 22:00:11:651 Erase task req-id: 85, type: 19 zcl seqno: 45 send time 0, profileId: 0x0104, clusterId: 0x0006
  276. 22:00:11:719 Node data 0xd0cf5efffeda6732 profileId: 0x0104, clusterId: 0x0006
  277. 22:00:11:720 0xD0CF5EFFFEDA6732: update ZCL value 0x01/0x0006/0x0000 after 0 s
  278. 22:00:11:806 APS-DATA.indication from child 0xD3F6
  279. 22:00:11:807 expression: Item.val=(ZclFrame.at(3)-121)*1000+2 --> 7002
  280. 22:00:11:808 [INFO] - No button map for: 3AFE280100510001, unicast to: 0x0000, endpoint: 0x01, cluster: ONOFF (0x0006), command: ATTRIBUTE_REPORT (0x0A), payload: 00001080, zclSeq: 42
  281. 22:00:11:809 ZCL attribute report 0x14B457FFFE075964 for cluster: 0x0006, ep: 0x01, frame control: 0x08, mfcode: 0x0000
  282. 22:00:11:810 payload: 00001080
  283. 22:00:11:811 Websocket 192.168.178.38:46604 send message: {"e":"changed","id":"53","r":"sensors","state":{"buttonevent":7002,"lastupdated":"2023-05-01T20:00:11.807"},"t":"event","uniqueid":"14:b4:57:ff:fe:07:59:64-01-0006"} (ret = -1098625096)
  284. 22:00:12:423 binding/unbinding timeout srcAddr: 0x086BD7FFFE532BF5, retry
  285. 22:00:12:424 poll node 08:6b:d7:ff:fe:53:2b:f5-01
  286. 22:00:12:425 Poll light node Büro Schrank links
  287. 22:00:12:426 Idle timer triggered
  288. 22:00:12:426 Force read attributes for ZHAPresence SensorNode Motion Sensor Bad gross 3
  289. 22:00:12:573 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0006 dropped, values are fresh enough
  290. 22:00:12:811 APS-DATA.indication from child 0xD3F6
  291. 22:00:12:889 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0008 dropped, values are fresh enough
  292. 22:00:13:423 Wait 1s till query finished
  293. 22:00:13:529 Bind response success for 0x086bd7fffe532bf5 ep: 0x01 cluster: 0x0000
  294. 22:00:13:575 poll node cc:cc:cc:ff:fe:b1:9d:d3-01
  295. 22:00:13:576 Poll light node Schlafzimmer Schrank links
  296. 22:00:13:638 read attributes of 0xCCCCCCFFFEB19DD3 cluster: 0x0006: [
  297. 22:00:13:640 0x0000
  298. 22:00:13:642 ]
  299. 22:00:13:643 add task 200 type 19 to 0xCCCCCCFFFEB19DD3 cluster 0x0006 req.id 101
  300. 22:00:13:644 Poll APS request 101 to 0xCCCCCCFFFEB19DD3 cluster: 0x0006
  301. 22:00:13:747 Poll APS confirm 101 status: 0x00
  302. 22:00:13:748 Erase task req-id: 101, type: 19 zcl seqno: 46 send time 0, profileId: 0x0104, clusterId: 0x0006
  303. 22:00:13:783 Node data 0xccccccfffeb19dd3 profileId: 0x0104, clusterId: 0x0006
  304. 22:00:13:784 0xCCCCCCFFFEB19DD3: update ZCL value 0x01/0x0006/0x0000 after 0 s
  305. 22:00:14:092 Bind response success for 0xccccccfffeb3e208 ep: 0x01 cluster: 0x0000
  306. 22:00:14:093 update ddf TRADFRI Driver 10W index 226
  307. 22:00:14:095 configure reporting rq seq 48 for 0xCCCCCCFFFEB3E208, attribute 0x0000/0x4000
  308. 22:00:14:172 ZCL configure reporting rsp seq: 48 0xCCCCCCFFFEB3E208 for ep: 0x01 cluster: 0x0000 attr: 0x4000 status: 0x00
  309. 22:00:14:173 binding/unbinding timeout srcAddr: 0x086BD7FFFE532BF5, retry
  310. 22:00:14:249 Bind response success for 0xccccccfffeb3e208 ep: 0x01 cluster: 0x0006
  311. 22:00:14:252 update ddf TRADFRI Driver 10W index 226
  312. 22:00:14:254 configure reporting rq seq 49 for 0xCCCCCCFFFEB3E208, attribute 0x0006/0x0000
  313. 22:00:14:302 ZCL configure reporting rsp seq: 49 0xCCCCCCFFFEB3E208 for ep: 0x01 cluster: 0x0006 attr: 0x0000 status: 0x00
  314. 22:00:14:423 Daylight now: nauticalDusk, status: 220, daylight: 0, dark: 1
  315. 22:00:14:424 Wait 2s till query finished
  316. 22:00:14:452 Bind response success for 0x086bd7fffe532bf5 ep: 0x01 cluster: 0x0006
  317. 22:00:14:454 update ddf TRADFRI Driver 30W index 225
  318. 22:00:14:455 skip configure report for cluster: 0x0006 attr: 0x0000 of node 0x086BD7FFFE532BF5 (seems to be active)
  319. 22:00:14:618 poll node cc:cc:cc:ff:fe:b3:e2:08-01
  320. 22:00:14:619 Poll light node Büro Schrank rechts
  321. 22:00:14:671 Poll APS request to 0xCCCCCCFFFEB3E208 cluster: 0x0006 dropped, values are fresh enough
  322. 22:00:14:957 read attributes of 0xCCCCCCFFFEB3E208 cluster: 0x0008: [
  323. 22:00:14:958 0x0000
  324. 22:00:14:958 ]
  325. 22:00:14:959 add task 207 type 19 to 0xCCCCCCFFFEB3E208 cluster 0x0008 req.id 121
  326. 22:00:14:960 Poll APS request 121 to 0xCCCCCCFFFEB3E208 cluster: 0x0008
  327. 22:00:15:053 Poll APS confirm 121 status: 0x00
  328. 22:00:15:054 Erase task req-id: 121, type: 19 zcl seqno: 51 send time 0, profileId: 0x0104, clusterId: 0x0008
  329. 22:00:15:070 Node data 0xccccccfffeb3e208 profileId: 0x0104, clusterId: 0x0008
  330. 22:00:15:073 0xCCCCCCFFFEB3E208: update ZCL value 0x01/0x0008/0x0000 after 0 s
  331. 22:00:15:422 Wait 1s till query finished
  332. 22:00:15:439 binding/unbinding timeout srcAddr: 0x086BD7FFFE532BF5, retry
  333. 22:00:15:508 Bind response success for 0xccccccfffeb3e208 ep: 0x01 cluster: 0x0008
  334. 22:00:15:509 update ddf TRADFRI Driver 10W index 226
  335. 22:00:15:511 configure reporting rq seq 52 for 0xCCCCCCFFFEB3E208, attribute 0x0008/0x0000
  336. 22:00:15:579 ZCL configure reporting rsp seq: 52 0xCCCCCCFFFEB3E208 for ep: 0x01 cluster: 0x0008 attr: 0x0000 status: 0x00
  337. 22:00:15:635 poll node d0:cf:5e:ff:fe:da:67:32-01
  338. 22:00:15:636 Poll light node Schlafzimmer Schrank rechts
  339. 22:00:15:684 read attributes of 0xD0CF5EFFFEDA6732 cluster: 0x0006: [
  340. 22:00:15:685 0x0000
  341. 22:00:15:686 ]
  342. 22:00:15:687 add task 211 type 19 to 0xD0CF5EFFFEDA6732 cluster 0x0006 req.id 132
  343. 22:00:15:688 Poll APS request 132 to 0xD0CF5EFFFEDA6732 cluster: 0x0006
  344. 22:00:15:757 Poll APS confirm 132 status: 0x00
  345. 22:00:15:758 Erase task req-id: 132, type: 19 zcl seqno: 53 send time 0, profileId: 0x0104, clusterId: 0x0006
  346. 22:00:15:759 Bind response success for 0x086bd7fffe532bf5 ep: 0x01 cluster: 0x0008
  347. 22:00:15:760 skip configure report for cluster: 0x0008 attr: 0x0000 of node 0x086BD7FFFE532BF5 (seems to be active)
  348. 22:00:15:812 Node data 0xd0cf5efffeda6732 profileId: 0x0104, clusterId: 0x0006
  349. 22:00:15:813 0xD0CF5EFFFEDA6732: update ZCL value 0x01/0x0006/0x0000 after 0 s
  350. 22:00:15:839 APS-DATA.indication from child 0xD3F6
  351. 22:00:16:424 Wait 1s till query finished
  352. 22:00:16:724 poll node 08:6b:d7:ff:fe:53:2b:f5-01
  353. 22:00:16:725 Poll light node Büro Schrank links
  354. 22:00:16:773 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0006 dropped, values are fresh enough
  355. 22:00:16:852 APS-DATA.indication from child 0xD3F6
  356. 22:00:16:853 expression: Item.val=(ZclFrame.at(3)-121)*1000+2 --> 7002
  357. 22:00:16:855 [INFO] - No button map for: 3AFE280100510001, unicast to: 0x0000, endpoint: 0x01, cluster: ONOFF (0x0006), command: ATTRIBUTE_REPORT (0x0A), payload: 00001080, zclSeq: 43
  358. 22:00:16:855 ZCL attribute report 0x14B457FFFE075964 for cluster: 0x0006, ep: 0x01, frame control: 0x08, mfcode: 0x0000
  359. 22:00:16:856 payload: 00001080
  360. 22:00:16:857 Websocket 192.168.178.38:46604 send message: {"e":"changed","id":"53","r":"sensors","state":{"buttonevent":7002,"lastupdated":"2023-05-01T20:00:16.853"},"t":"event","uniqueid":"14:b4:57:ff:fe:07:59:64-01-0006"} (ret = -1098625096)
  361. 22:00:17:095 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0008 dropped, values are fresh enough
  362. 22:00:17:422 Wait 0s till query finished
  363. 22:00:17:831 poll node d0:cf:5e:ff:fe:da:67:32-01
  364. 22:00:17:833 Poll light node Schlafzimmer Schrank rechts
  365. 22:00:17:879 read attributes of 0xD0CF5EFFFEDA6732 cluster: 0x0006: [
  366. 22:00:17:880 0x0000
  367. 22:00:17:881 ]
  368. 22:00:17:881 add task 220 type 19 to 0xD0CF5EFFFEDA6732 cluster 0x0006 req.id 148
  369. 22:00:17:882 Poll APS request 148 to 0xD0CF5EFFFEDA6732 cluster: 0x0006
  370. 22:00:17:946 Poll APS confirm 148 status: 0x00
  371. 22:00:17:947 Erase task req-id: 148, type: 19 zcl seqno: 56 send time 0, profileId: 0x0104, clusterId: 0x0006
  372. 22:00:18:013 Node data 0xd0cf5efffeda6732 profileId: 0x0104, clusterId: 0x0006
  373. 22:00:18:014 0xD0CF5EFFFEDA6732: update ZCL value 0x01/0x0006/0x0000 after 0 s
  374. 22:00:18:423 poll node 08:6b:d7:ff:fe:53:2b:f5-01
  375. 22:00:18:424 Poll light node Büro Schrank links
  376. 22:00:18:425 Idle timer triggered
  377. 22:00:18:426 Force read attributes for ZHAOpenClose SensorNode Kühlschrank Tür oben
  378. 22:00:18:861 APS-DATA.indication from child 0xD3F6
  379. 22:00:18:982 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0006 dropped, values are fresh enough
  380. 22:00:19:300 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0008 dropped, values are fresh enough
  381. 22:00:19:423 Wait 1s till query finished
  382. 22:00:19:557 New websocket 192.168.178.40:50460 (state: 3)
  383. 22:00:19:986 poll node cc:cc:cc:ff:fe:b1:9d:d3-01
  384. 22:00:19:988 Poll light node Schlafzimmer Schrank links
  385. 22:00:20:043 read attributes of 0xCCCCCCFFFEB19DD3 cluster: 0x0006: [
  386. 22:00:20:044 0x0000
  387. 22:00:20:045 ]
  388. 22:00:20:046 add task 230 type 19 to 0xCCCCCCFFFEB19DD3 cluster 0x0006 req.id 162
  389. 22:00:20:046 Poll APS request 162 to 0xCCCCCCFFFEB19DD3 cluster: 0x0006
  390. 22:00:20:144 Poll APS confirm 162 status: 0x00
  391. 22:00:20:145 Erase task req-id: 162, type: 19 zcl seqno: 59 send time 0, profileId: 0x0104, clusterId: 0x0006
  392. 22:00:20:182 Node data 0xccccccfffeb19dd3 profileId: 0x0104, clusterId: 0x0006
  393. 22:00:20:183 0xCCCCCCFFFEB19DD3: update ZCL value 0x01/0x0006/0x0000 after 0 s
  394. 22:00:20:423 Idle timer triggered
  395. 22:00:20:424 Force read attributes for ZHAOpenClose SensorNode Fenster Büro oben
  396. 22:00:21:027 poll node cc:cc:cc:ff:fe:b3:e2:08-01
  397. 22:00:21:030 Poll light node Büro Schrank rechts
  398. 22:00:21:075 Poll APS request to 0xCCCCCCFFFEB3E208 cluster: 0x0006 dropped, values are fresh enough
  399. 22:00:21:393 Poll APS request to 0xCCCCCCFFFEB3E208 cluster: 0x0008 dropped, values are fresh enough
  400. 22:00:21:422 Wait 1s till query finished
  401. 22:00:21:889 APS-DATA.indication from child 0xD3F6
  402. 22:00:22:102 poll node d0:cf:5e:ff:fe:da:67:32-01
  403. 22:00:22:103 Poll light node Schlafzimmer Schrank rechts
  404. 22:00:22:155 read attributes of 0xD0CF5EFFFEDA6732 cluster: 0x0006: [
  405. 22:00:22:157 0x0000
  406. 22:00:22:159 ]
  407. 22:00:22:161 add task 239 type 19 to 0xD0CF5EFFFEDA6732 cluster 0x0006 req.id 173
  408. 22:00:22:161 Poll APS request 173 to 0xD0CF5EFFFEDA6732 cluster: 0x0006
  409. 22:00:22:244 Poll APS confirm 173 status: 0x00
  410. 22:00:22:245 Erase task req-id: 173, type: 19 zcl seqno: 60 send time 0, profileId: 0x0104, clusterId: 0x0006
  411. 22:00:22:313 Node data 0xd0cf5efffeda6732 profileId: 0x0104, clusterId: 0x0006
  412. 22:00:22:314 0xD0CF5EFFFEDA6732: update ZCL value 0x01/0x0006/0x0000 after 0 s
  413. 22:00:22:422 Wait 0s till query finished
  414. 22:00:23:114 poll node 08:6b:d7:ff:fe:53:2b:f5-01
  415. 22:00:23:115 Poll light node Büro Schrank links
  416. 22:00:23:165 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0006 dropped, values are fresh enough
  417. 22:00:23:422 Idle timer triggered
  418. 22:00:23:424 Force read attributes for ZHAOpenClose SensorNode Küche Balkontür links unten
  419. 22:00:23:451 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0008 dropped, values are fresh enough
  420. 22:00:23:525 [Master] read param with arg 0x19
  421. 22:00:24:119 poll node cc:cc:cc:ff:fe:b1:9d:d3-01
  422. 22:00:24:120 Poll light node Schlafzimmer Schrank links
  423. 22:00:24:172 read attributes of 0xCCCCCCFFFEB19DD3 cluster: 0x0006: [
  424. 22:00:24:173 0x0000
  425. 22:00:24:174 ]
  426. 22:00:24:175 add task 248 type 19 to 0xCCCCCCFFFEB19DD3 cluster 0x0006 req.id 184
  427. 22:00:24:176 Poll APS request 184 to 0xCCCCCCFFFEB19DD3 cluster: 0x0006
  428. 22:00:24:253 Poll APS confirm 184 status: 0x00
  429. 22:00:24:254 Erase task req-id: 184, type: 19 zcl seqno: 62 send time 0, profileId: 0x0104, clusterId: 0x0006
  430. 22:00:24:283 Node data 0xccccccfffeb19dd3 profileId: 0x0104, clusterId: 0x0006
  431. 22:00:24:285 0xCCCCCCFFFEB19DD3: update ZCL value 0x01/0x0006/0x0000 after 0 s
  432. 22:00:24:422 DB save zll database items 0x00000087
  433. 22:00:24:423 DB sql exec REPLACE INTO auth (apikey, devicetype, createdate, lastusedate, useragent) VALUES ('6946A23722', 'Phoscon#B1920x916', '2023-05-01T19:46:28', '2023-05-01T20:00:19', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36')
  434. 22:00:24:428 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0xFFF0', 'All', 'normal', '', '', '', 'false', 'LightGroup', 'Other', '')
  435. 22:00:24:431 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0x0002', 'Büro', 'normal', '', '', '', 'false', 'LightGroup', 'Other', '')
  436. 22:00:24:433 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0x0003', 'Schlafzimmer', 'normal', '', '', '', 'false', 'LightGroup', 'Other', '')
  437. 22:00:24:438 DB sql exec DELETE FROM scenes WHERE gid='0x0001'
  438. 22:00:24:440 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0x0001', 'TRADFRI on/off switch', 'deleted', '', '', '', 'false', 'LightGroup', 'Other', '14:b4:57:ff:fe:5e:33:b3')
  439. 22:00:24:441 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0x0004', 'Küche', 'normal', '', '', '', 'false', 'LightGroup', 'Other', '')
  440. 22:00:24:446 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0x0005', 'Wohnzimmer', 'normal', '', '', '', 'false', 'LightGroup', 'Other', '')
  441. 22:00:24:448 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0x0006', 'Bad klein', 'normal', '', '', '', 'false', 'LightGroup', 'Other', '')
  442. 22:00:24:449 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0x0007', 'Bad groß', 'normal', '', '', '', 'false', 'LightGroup', 'Other', '')
  443. 22:00:24:451 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0x0008', 'Vorrat', 'normal', '', '', '', 'false', 'LightGroup', 'Other', '')
  444. 22:00:24:453 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0x0009', 'TRADFRI on/off switch 2', 'normal', '', '2', '', 'false', 'LightGroup', 'Other', '14:b4:57:ff:fe:5e:33:b3')
  445. 22:00:24:458 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1664985749 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0405'
  446. 22:00:24:462 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682968673 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0405'
  447. 22:00:24:466 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0405'
  448. 22:00:24:468 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0405'
  449. 22:00:24:471 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1682058868 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0405'
  450. 22:00:24:475 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0405'
  451. 22:00:24:479 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('12', 'Temperatur Sensor Büro', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:04:7b:a9:c4-01-0405', '20191205', '{"humidity":4720,"lastupdated":"2023-05-01T19:04:41.142"}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  452. 22:00:24:486 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1664985749 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0402'
  453. 22:00:24:492 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682968673 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0402'
  454. 22:00:24:494 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0402'
  455. 22:00:24:497 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0402'
  456. 22:00:24:500 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1682058868 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0402'
  457. 22:00:24:502 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0402'
  458. 22:00:24:505 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('11', 'Temperatur Sensor Büro', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:04:7b:a9:c4-01-0402', '20191205', '{"lastupdated":"2023-05-01T19:04:41.108","temperature":2431}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  459. 22:00:24:510 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1664985749 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0403'
  460. 22:00:24:513 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682968673 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0403'
  461. 22:00:24:515 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0403'
  462. 22:00:24:517 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0403'
  463. 22:00:24:519 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1682058868 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0403'
  464. 22:00:24:521 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:7b:a9:c4-01-0403'
  465. 22:00:24:525 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('13', 'Temperatur Sensor Büro', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:04:7b:a9:c4-01-0403', '20191205', '{"lastupdated":"2023-05-01T19:04:41.151","pressure":958}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  466. 22:00:24:530 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971125 FROM sub_devices WHERE uniqueid = '14:b4:57:ff:fe:09:7c:cf-01-0006'
  467. 22:00:24:532 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1682891858 FROM sub_devices WHERE uniqueid = '14:b4:57:ff:fe:09:7c:cf-01-0006'
  468. 22:00:24:534 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'true', 'dev', 1682969035 FROM sub_devices WHERE uniqueid = '14:b4:57:ff:fe:09:7c:cf-01-0006'
  469. 22:00:24:538 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1682899130 FROM sub_devices WHERE uniqueid = '14:b4:57:ff:fe:09:7c:cf-01-0006'
  470. 22:00:24:540 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('54', 'Switch 54', 'ZHASwitch', '3AFE280100510001', 'Konke', '14:b4:57:ff:fe:09:7c:cf-01-0006', '', '{"buttonevent":7002,"lastupdated":"2023-05-01T19:54:41.889"}', '{"battery":100,"on":true,"reachable":true}', '', 'normal', '1', '2023-05-01T19:59Z', '')
  471. 22:00:24:547 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1674674087 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0406'
  472. 22:00:24:551 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682970131 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0406'
  473. 22:00:24:553 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0406'
  474. 22:00:24:555 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0406'
  475. 22:00:24:557 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0406'
  476. 22:00:24:559 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/duration', '90', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0406'
  477. 22:00:24:561 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/temperature', '2600', 'dev', 1682966830 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0406'
  478. 22:00:24:564 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('10', 'Bewegungsmelder Schlafzimmer', 'ZHAPresence', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:61:cd:cf-01-0406', '3000-0001', '{"lastupdated":"2023-05-01T13:43:03.425","presence":false}', '{"battery":100,"duration":90,"on":true,"reachable":false,"temperature":2600}', '{"d":263,"ep":1,"in":[1030],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  479. 22:00:24:571 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1674674087 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0400'
  480. 22:00:24:574 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682970131 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0400'
  481. 22:00:24:576 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0400'
  482. 22:00:24:578 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0400'
  483. 22:00:24:581 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0400'
  484. 22:00:24:583 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholddark', '12000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0400'
  485. 22:00:24:585 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholdoffset', '7000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:cd:cf-01-0400'
  486. 22:00:24:588 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('9', 'Bewegungsmelder Schlafzimmer', 'ZHALightLevel', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:61:cd:cf-01-0400', '3000-0001', '{"dark":false,"daylight":true,"lastupdated":"2023-05-01T13:43:02.879","lightlevel":21073,"lux":128}', '{"battery":100,"on":true,"reachable":false,"tholddark":12000,"tholdoffset":7000}', '{"d":263,"ep":1,"in":[1024],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  487. 22:00:24:593 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1657068841 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0405'
  488. 22:00:24:596 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682970614 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0405'
  489. 22:00:24:598 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0405'
  490. 22:00:24:601 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0405'
  491. 22:00:24:603 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1682967564 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0405'
  492. 22:00:24:606 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0405'
  493. 22:00:24:608 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('15', 'Temperatur Sensor Bad klein', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:04:5b:d3:78-01-0405', '20191205', '{"humidity":4948,"lastupdated":"2023-05-01T19:12:13.881"}', '{"battery":95,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  494. 22:00:24:615 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1657068841 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0402'
  495. 22:00:24:617 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682970614 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0402'
  496. 22:00:24:619 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0402'
  497. 22:00:24:621 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0402'
  498. 22:00:24:624 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1682967564 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0402'
  499. 22:00:24:626 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0402'
  500. 22:00:24:629 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('14', 'Temperatur Sensor Bad klein', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:04:5b:d3:78-01-0402', '20191205', '{"lastupdated":"2023-05-01T19:12:13.871","temperature":2356}', '{"battery":95,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  501. 22:00:24:634 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1657068841 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0403'
  502. 22:00:24:637 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682970614 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0403'
  503. 22:00:24:639 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0403'
  504. 22:00:24:641 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0403'
  505. 22:00:24:644 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1682967564 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0403'
  506. 22:00:24:646 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5b:d3:78-01-0403'
  507. 22:00:24:648 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('16', 'Temperatur Sensor Bad klein', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:04:5b:d3:78-01-0403', '20191205', '{"lastupdated":"2023-05-01T19:12:13.895","pressure":955}', '{"battery":95,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  508. 22:00:24:654 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1682049267 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0406'
  509. 22:00:24:657 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682968673 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0406'
  510. 22:00:24:660 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0406'
  511. 22:00:24:662 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0406'
  512. 22:00:24:664 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1682850204 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0406'
  513. 22:00:24:667 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/duration', '90', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0406'
  514. 22:00:24:668 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/temperature', '1700', 'dev', 1682968673 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0406'
  515. 22:00:24:671 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('33', 'Motion Sensor Küche Balkon', 'ZHAPresence', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:60:ba:08-01-0406', '3000-0001', '{"lastupdated":"2023-05-01T14:36:21.937","presence":false}', '{"battery":95,"duration":90,"on":true,"reachable":false,"temperature":1700}', '{"d":263,"ep":1,"in":[1030],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  516. 22:00:24:677 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1682049267 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0400'
  517. 22:00:24:679 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682968674 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0400'
  518. 22:00:24:681 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0400'
  519. 22:00:24:683 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0400'
  520. 22:00:24:686 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1682850204 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0400'
  521. 22:00:24:687 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholddark', '12000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0400'
  522. 22:00:24:690 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholdoffset', '7000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:60:ba:08-01-0400'
  523. 22:00:24:694 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('32', 'Motion Sensor Küche Balkon', 'ZHALightLevel', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:60:ba:08-01-0400', '3000-0001', '{"dark":false,"daylight":true,"lastupdated":"2023-05-01T14:36:21.915","lightlevel":28894,"lux":775}', '{"battery":95,"on":true,"reachable":false,"tholddark":12000,"tholdoffset":7000}', '{"d":263,"ep":1,"in":[1024],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  524. 22:00:24:699 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1675182323 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0405'
  525. 22:00:24:702 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971080 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0405'
  526. 22:00:24:704 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0405'
  527. 22:00:24:706 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682971166 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0405'
  528. 22:00:24:709 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1673248985 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0405'
  529. 22:00:24:711 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0405'
  530. 22:00:24:714 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('7', 'Temperatur Sensor Bad groß', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:04:5d:a1:a6-01-0405', '20191205', '{"humidity":4828,"lastupdated":"2023-05-01T19:58:00.963"}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  531. 22:00:24:719 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1675182323 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0402'
  532. 22:00:24:722 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971080 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0402'
  533. 22:00:24:723 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0402'
  534. 22:00:24:725 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682971166 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0402'
  535. 22:00:24:728 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1673248985 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0402'
  536. 22:00:24:730 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0402'
  537. 22:00:24:733 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('6', 'Temperatur Sensor Bad groß', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:04:5d:a1:a6-01-0402', '20191205', '{"lastupdated":"2023-05-01T19:58:00.954","temperature":2456}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  538. 22:00:24:739 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1675182323 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0403'
  539. 22:00:24:741 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971080 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0403'
  540. 22:00:24:743 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0403'
  541. 22:00:24:745 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682971166 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0403'
  542. 22:00:24:748 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1673248985 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0403'
  543. 22:00:24:750 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5d:a1:a6-01-0403'
  544. 22:00:24:752 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('8', 'Temperatur Sensor Bad groß', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:04:5d:a1:a6-01-0403', '20191205', '{"lastupdated":"2023-05-01T19:58:00.992","pressure":955}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  545. 22:00:24:758 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1674741370 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0405'
  546. 22:00:24:760 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682967967 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0405'
  547. 22:00:24:762 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0405'
  548. 22:00:24:764 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0405'
  549. 22:00:24:767 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1682904425 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0405'
  550. 22:00:24:769 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0405'
  551. 22:00:24:772 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('4', 'Schlafzimmer Temp Sensor', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:04:85:9f:f3-01-0405', '20191205', '{"humidity":5315,"lastupdated":"2023-05-01T19:06:07.846"}', '{"battery":95,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  552. 22:00:24:778 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1674741370 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0402'
  553. 22:00:24:780 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682967967 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0402'
  554. 22:00:24:783 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0402'
  555. 22:00:24:785 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0402'
  556. 22:00:24:788 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1682904425 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0402'
  557. 22:00:24:790 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0402'
  558. 22:00:24:793 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('3', 'Schlafzimmer Temp Sensor', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:04:85:9f:f3-01-0402', '20191205', '{"lastupdated":"2023-05-01T19:06:07.833","temperature":2209}', '{"battery":95,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  559. 22:00:24:799 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1674741370 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0403'
  560. 22:00:24:801 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682967967 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0403'
  561. 22:00:24:804 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1653129748 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0403'
  562. 22:00:24:806 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0403'
  563. 22:00:24:809 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1682904425 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0403'
  564. 22:00:24:811 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1653718210 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:85:9f:f3-01-0403'
  565. 22:00:24:824 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('5', 'Schlafzimmer Temp Sensor', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:04:85:9f:f3-01-0403', '20191205', '{"lastupdated":"2023-05-01T19:06:07.865","pressure":953}', '{"battery":95,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  566. 22:00:24:830 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1680952687 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0406'
  567. 22:00:24:833 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971181 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0406'
  568. 22:00:24:835 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0406'
  569. 22:00:24:838 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'true', 'dev', 1682971181 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0406'
  570. 22:00:24:840 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1679101181 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0406'
  571. 22:00:24:842 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/duration', '5', 'dev', 1665337312 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0406'
  572. 22:00:24:845 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/temperature', '3000', 'dev', 1682965473 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0406'
  573. 22:00:24:848 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('45', 'Motion Sensor Bad klein1', 'ZHAPresence', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:51:e2:78-01-0406', '3000-0001', '{"lastupdated":"2023-05-01T18:24:27.863","presence":false}', '{"battery":100,"duration":5,"on":true,"reachable":true,"temperature":3000}', '{"d":263,"ep":1,"in":[1030],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  574. 22:00:24:854 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1680952687 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0400'
  575. 22:00:24:857 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971181 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0400'
  576. 22:00:24:859 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0400'
  577. 22:00:24:861 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'true', 'dev', 1682971181 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0400'
  578. 22:00:24:864 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1679101181 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0400'
  579. 22:00:24:866 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholddark', '12000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0400'
  580. 22:00:24:869 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholdoffset', '7000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:51:e2:78-01-0400'
  581. 22:00:24:873 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('44', 'Motion Sensor Bad klein1', 'ZHALightLevel', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:51:e2:78-01-0400', '3000-0001', '{"dark":false,"daylight":false,"lastupdated":"2023-05-01T18:25:16.218","lightlevel":4772,"lux":3}', '{"battery":100,"on":true,"reachable":true,"tholddark":12000,"tholdoffset":7000}', '{"d":263,"ep":1,"in":[1024],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  582. 22:00:24:881 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1680959683 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0406'
  583. 22:00:24:883 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682180606 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0406'
  584. 22:00:24:885 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0406'
  585. 22:00:24:888 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0406'
  586. 22:00:24:890 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0406'
  587. 22:00:24:893 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/duration', '10', 'dev', 1667070814 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0406'
  588. 22:00:24:895 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/temperature', '2700', 'dev', 1682153533 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0406'
  589. 22:00:24:897 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('41', 'Motion Sensor Bad gross 1', 'ZHAPresence', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:66:ac:cd-01-0406', '3000-0001', '{"lastupdated":"2023-04-22T16:21:23.513","presence":false}', '{"battery":100,"duration":10,"on":true,"reachable":false,"temperature":2700}', '{"d":263,"ep":1,"in":[1030],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  590. 22:00:24:903 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1680959683 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0400'
  591. 22:00:24:906 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682179143 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0400'
  592. 22:00:24:909 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0400'
  593. 22:00:24:911 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0400'
  594. 22:00:24:914 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0400'
  595. 22:00:24:916 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholddark', '12000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0400'
  596. 22:00:24:919 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholdoffset', '7000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:66:ac:cd-01-0400'
  597. 22:00:24:923 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('40', 'Motion Sensor Bad gross 1', 'ZHALightLevel', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:66:ac:cd-01-0400', '3000-0001', '{"dark":false,"daylight":true,"lastupdated":"2023-04-22T15:40:47.498","lightlevel":13803,"lux":24}', '{"battery":100,"on":true,"reachable":false,"tholddark":12000,"tholdoffset":7000}', '{"d":263,"ep":1,"in":[1024],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  598. 22:00:24:929 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1680953107 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0406'
  599. 22:00:24:932 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971071 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0406'
  600. 22:00:24:934 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0406'
  601. 22:00:24:937 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682971166 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0406'
  602. 22:00:24:940 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1679395924 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0406'
  603. 22:00:24:942 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/duration', '90', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0406'
  604. 22:00:24:945 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/temperature', '3200', 'dev', 1682909518 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0406'
  605. 22:00:24:948 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('22', 'Motion Sensor Wohnzimmer 1', 'ZHAPresence', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:5e:b7:aa-01-0406', '3000-0001', '{"lastupdated":"2023-05-01T19:53:30.292","presence":false}', '{"battery":95,"duration":90,"on":true,"reachable":false,"temperature":3200}', '{"d":263,"ep":1,"in":[1030],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  606. 22:00:24:954 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1680953107 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0400'
  607. 22:00:24:956 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971071 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0400'
  608. 22:00:24:958 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0400'
  609. 22:00:24:961 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682971166 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0400'
  610. 22:00:24:964 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1679395924 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0400'
  611. 22:00:24:966 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholddark', '12000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0400'
  612. 22:00:24:969 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholdoffset', '7000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5e:b7:aa-01-0400'
  613. 22:00:24:973 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('23', 'Motion Sensor Wohnzimmer 1', 'ZHALightLevel', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:5e:b7:aa-01-0400', '3000-0001', '{"dark":true,"daylight":false,"lastupdated":"2023-05-01T19:53:30.269","lightlevel":0,"lux":0}', '{"battery":95,"on":true,"reachable":false,"tholddark":12000,"tholdoffset":7000}', '{"d":263,"ep":1,"in":[1024],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  614. 22:00:24:978 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971198 FROM sub_devices WHERE uniqueid = '14:b4:57:ff:fe:07:59:64-01-0006'
  615. 22:00:24:981 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1682891721 FROM sub_devices WHERE uniqueid = '14:b4:57:ff:fe:07:59:64-01-0006'
  616. 22:00:24:983 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'true', 'dev', 1682969035 FROM sub_devices WHERE uniqueid = '14:b4:57:ff:fe:07:59:64-01-0006'
  617. 22:00:24:986 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1682898144 FROM sub_devices WHERE uniqueid = '14:b4:57:ff:fe:07:59:64-01-0006'
  618. 22:00:24:989 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('53', 'Switch 53', 'ZHASwitch', '3AFE280100510001', 'Konke', '14:b4:57:ff:fe:07:59:64-01-0006', '', '{"buttonevent":7002,"lastupdated":"2023-05-01T20:00:16.853"}', '{"battery":100,"on":true,"reachable":true}', '', 'normal', '1', '2023-05-01T19:59Z', '')
  619. 22:00:24:994 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1680951547 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0406'
  620. 22:00:24:996 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682970473 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0406'
  621. 22:00:24:998 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0406'
  622. 22:00:24:000 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0406'
  623. 22:00:24:003 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0406'
  624. 22:00:24:005 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/duration', '90', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0406'
  625. 22:00:24:007 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/temperature', '2700', 'dev', 1682970473 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0406'
  626. 22:00:24:010 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('20', 'Motion Sensor Küche Vorrat', 'ZHAPresence', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:5f:b7:ea-01-0406', '3000-0001', '{"lastupdated":"2023-05-01T14:34:44.965","presence":false}', '{"battery":100,"duration":90,"on":true,"reachable":false,"temperature":2700}', '{"d":263,"ep":1,"in":[1030],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  627. 22:00:25:015 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1680951547 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0400'
  628. 22:00:25:018 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682970473 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0400'
  629. 22:00:25:020 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0400'
  630. 22:00:25:022 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0400'
  631. 22:00:25:025 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0400'
  632. 22:00:25:027 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholddark', '12000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0400'
  633. 22:00:25:029 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholdoffset', '7000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:5f:b7:ea-01-0400'
  634. 22:00:25:033 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('19', 'Motion Sensor Küche Vorrat', 'ZHALightLevel', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:5f:b7:ea-01-0400', '3000-0001', '{"dark":false,"daylight":false,"lastupdated":"2023-05-01T14:41:02.582","lightlevel":9032,"lux":8}', '{"battery":100,"on":true,"reachable":false,"tholddark":12000,"tholdoffset":7000}', '{"d":263,"ep":1,"in":[1024],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  635. 22:00:25:039 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1678942014 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0406'
  636. 22:00:25:041 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682969355 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0406'
  637. 22:00:25:044 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0406'
  638. 22:00:25:046 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0406'
  639. 22:00:25:049 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0406'
  640. 22:00:25:051 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/duration', '10', 'dev', 1667070831 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0406'
  641. 22:00:25:053 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/temperature', '2900', 'dev', 1682964731 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0406'
  642. 22:00:25:056 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('43', 'Motion Sensor Bad gross 2', 'ZHAPresence', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:64:c2:ae-01-0406', '3000-0001', '{"lastupdated":"2023-05-01T19:23:21.722","presence":false}', '{"battery":100,"duration":10,"on":true,"reachable":false,"temperature":2900}', '{"d":263,"ep":1,"in":[1030],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  643. 22:00:25:061 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1678942014 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0400'
  644. 22:00:25:064 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682969355 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0400'
  645. 22:00:25:066 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0400'
  646. 22:00:25:068 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1682970827 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0400'
  647. 22:00:25:071 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0400'
  648. 22:00:25:073 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholddark', '12000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0400'
  649. 22:00:25:076 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholdoffset', '7000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:64:c2:ae-01-0400'
  650. 22:00:25:080 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('42', 'Motion Sensor Bad gross 2', 'ZHALightLevel', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:64:c2:ae-01-0400', '3000-0001', '{"dark":true,"daylight":false,"lastupdated":"2023-05-01T19:29:15.079","lightlevel":10001,"lux":10}', '{"battery":100,"on":true,"reachable":false,"tholddark":12000,"tholdoffset":7000}', '{"d":263,"ep":1,"in":[1024],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  651. 22:00:25:086 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1682158052 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0406'
  652. 22:00:25:088 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971178 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0406'
  653. 22:00:25:090 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0406'
  654. 22:00:25:092 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'true', 'dev', 1682971178 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0406'
  655. 22:00:25:094 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0406'
  656. 22:00:25:096 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/duration', '120', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0406'
  657. 22:00:25:098 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/temperature', '3000', 'dev', 1682949621 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0406'
  658. 22:00:25:101 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('18', 'Motion Sensor Büro Tisch 2', 'ZHAPresence', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:61:b2:9c-01-0406', '3000-0001', '{"lastupdated":"2023-05-01T19:59:38.641","presence":true}', '{"battery":100,"duration":120,"on":true,"reachable":true,"temperature":3000}', '{"d":263,"ep":1,"in":[1030],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  659. 22:00:25:107 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1682158052 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0400'
  660. 22:00:25:109 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-05-01T19:59Z', 'dev', 1682971178 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0400'
  661. 22:00:25:111 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0400'
  662. 22:00:25:113 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'true', 'dev', 1682971178 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0400'
  663. 22:00:25:116 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0400'
  664. 22:00:25:118 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholddark', '12000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0400'
  665. 22:00:25:120 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/tholdoffset', '7000', 'dev', 1657618336 FROM sub_devices WHERE uniqueid = '00:15:8d:00:04:61:b2:9c-01-0400'
  666. 22:00:25:124 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('17', 'Motion Sensor Büro Tisch 2', 'ZHALightLevel', 'lumi.sensor_motion.aq2', 'LUMI', '00:15:8d:00:04:61:b2:9c-01-0400', '3000-0001', '{"dark":false,"daylight":false,"lastupdated":"2023-05-01T19:59:38.627","lightlevel":17783,"lux":60}', '{"battery":100,"on":true,"reachable":true,"tholddark":12000,"tholdoffset":7000}', '{"d":263,"ep":1,"in":[1024],"p":260}', 'normal', '1', '2023-05-01T19:59Z', '')
  667. 22:00:25:134 DB saved in 711 ms
  668. 22:00:25:136 Daylight now: nauticalDusk, status: 220, daylight: 0, dark: 1
  669. 22:00:25:137 Wait 0s till query finished
  670. 22:00:25:997 Skip idle timer callback, too early: elapsed 859 msec
  671. 22:00:26:082 APS-DATA.indication from child 0xD3F6
  672. 22:00:26:424 poll node d0:cf:5e:ff:fe:da:67:32-01
  673. 22:00:26:425 Poll light node Schlafzimmer Schrank rechts
  674. 22:00:26:426 Idle timer triggered
  675. 22:00:26:426 Force read attributes for ZHAVibration SensorNode Vibration Bad Balkontür
  676. 22:00:26:792 read attributes of 0xD0CF5EFFFEDA6732 cluster: 0x0006: [
  677. 22:00:26:793 0x0000
  678. 22:00:26:794 ]
  679. 22:00:26:795 add task 255 type 19 to 0xD0CF5EFFFEDA6732 cluster 0x0006 req.id 193
  680. 22:00:26:796 Poll APS request 193 to 0xD0CF5EFFFEDA6732 cluster: 0x0006
  681. 22:00:26:851 Poll APS confirm 193 status: 0x00
  682. 22:00:26:852 Erase task req-id: 193, type: 19 zcl seqno: 63 send time 0, profileId: 0x0104, clusterId: 0x0006
  683. 22:00:26:915 Node data 0xd0cf5efffeda6732 profileId: 0x0104, clusterId: 0x0006
  684. 22:00:26:916 0xD0CF5EFFFEDA6732: update ZCL value 0x01/0x0006/0x0000 after 0 s
  685. 22:00:27:423 Wait 1s till query finished
  686. 22:00:27:839 poll node 08:6b:d7:ff:fe:53:2b:f5-01
  687. 22:00:27:840 Poll light node Büro Schrank links
  688. 22:00:27:887 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0006 dropped, values are fresh enough
  689. 22:00:28:203 Poll APS request to 0x086BD7FFFE532BF5 cluster: 0x0008 dropped, values are fresh enough
  690. 22:00:28:422 Wait 0s till query finished
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!