The Philips Hue network

All the lights in the house are Philips Hue compatible. Over 90 Hue devices are spread over 3 bridges. A lot of data is being logged from this network such as reachability, battery levels (for the remotes and motions sensors) and power consumption.

Hue motionsensors
A total of 14 Philips Hue motion sensors are being used for event based lightning (like movement at a certain time of the day will turn on the lights) and temperature monitoring.
Most recent motion sensor data
SensorDateTimeTemperatureBatteryLightlevelReachable
Motionsensor Attic03-Oct-202510:18:2317.6℃61%0%Yes
Motionsensor Babyroom03-Oct-202510:13:5018.3℃60%0%Yes
Motionsensor Bathroom03-Oct-202509:56:3417.1℃19%0%Yes
Motionsensor Bedroom03-Oct-202510:18:5517.8℃68%0%Yes
Motionsensor Garage03-Oct-202510:16:0012.5℃100%0%Yes
Motionsensor Garden03-Oct-202510:16:0611.2℃96%0%Yes
Motionsensor Hallway downstairs03-Oct-202510:10:5118.7℃77%23%No
Motionsensor Hallway upstairs03-Oct-202510:15:0318.0℃57%0%Yes
Motionsensor Kitchen03-Oct-202510:14:0718.0℃37%33%No
Motionsensor Livingroom03-Oct-202510:19:1816.9℃100%40%No
Motionsensor Stairs26-Aug-202516:00:2720.4℃44%4%Yes
Motionsensor Storagecloset26-Aug-202516:26:0022.1℃58%26%No
Motionsensor Study03-Oct-202510:19:3619.6℃47%11%Yes
Motionsensor Toilet03-Oct-202510:06:3417.8℃75%0%No
Motionsensor batterylevels last 12 months

Hue motion sensors work on batteries that need to be periodically replaced

Where do we spend most of our time in the house?

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'icepick_jeroen.motionsensor_weekhistory' doesn't exist in /home/icepick/public_html/common.php:676 Stack trace: #0 /home/icepick/public_html/common.php(676): PDO->query('SELECT\r\n\t\t\tCOUN...') #1 /home/icepick/public_html/measurements/huenetwork.php(80): print_hue_motion_pie_chart() #2 {main} thrown in /home/icepick/public_html/common.php on line 676