report all sensors

diff --git a/query.sql b/query.sql
new file mode 100644 (file)
index 0000000..8c5cf57
--- /dev/null
+++ b/query.sql
@@ -0,0 +1,3 @@
+-- select time,addr,json->'type',json->'sensor_data',json->'battery',json->'battery_percent',json->'counter',json->'original'->'data' from eg5120 ;
+
+count(*),min(time),max(time),sensor_type,json->'original'->'mac' as mac,json->'sensor_name' as sensor_name from eg5120 group by sensor_type,sensor_name,json->'original'->'mac' ;