Problem mit Gladys Plus

[guim31]

Ich glaube, ich werde alles darauf setzen, dass wir uns irgendwann mal anrufen, denn heute Morgen war die Verbindung wieder weg… obwohl meine Freebox keine Unterbrechung anzeigt.
Verstehe gar nichts mehr !!!

Ich weiß nicht, ob es der richtige Tag ist… aber HERZLICHEN GLÜCKWUNSCH ZUM GEBURTSTAG !!!

[pierre-gilles]

Hallo @guim31

Ich weiß nicht, ob du seitdem weiter recherchieren konntest.

Ich hatte eine Idee, du kannst https://healthchecks.io/ verwenden, um einen Healthcheck für deine Gladys einzurichten.

Damit kannst du überprüfen, ob Gladys selbst noch mit dem Internet verbunden ist / « lebendig » bleibt.

Konkrekt musst du eine Szene in Gladys erstellen, die diesen Dienst regelmäßig pingt, und wenn Gladys aufhört, den Dienst zu ping, erhältst du eine Benachrichtigung (per E-Mail standardmäßig, aber auch andere Dienste sind verfügbar).

1. Du erstellst einen « Check » (kostenlos bis zu 20 Checks)

Du kannst anpassen, ob du einen kürzeren Zeitraum einstellen möchtest, z.B. alle Minuten, wenn du wirklich präzise sein willst, oder alle 5 Minuten.

In deinem Fall ist es vielleicht am besten, mit alle Minuten / 2 Minuten zu beginnen, um den Zustand deines Netzwerks/Instanzen am besten zu verfolgen.

2. Du kopierst die URL:

3. Du erstellst eine Szene in Gladys, die im definierten Intervall (z.B. alle Minuten) einen Ping an healthchecks mit der Aktion « HTTP-Anfrage » durchführt:

Damit kannst du genauer feststellen, wann/ob Gladys von Internet getrennt ist/ausgefallen ist.

@guim31

Ich weiß nicht, ob es der richtige Tag ist… aber HERZLICHEN GLÜCKWUNSCH!!!

Danke!!

[guim31]

Dann werde ich das mal genauer unter die Lupe nehmen, denn seit 10 Tagen habe ich täglich eine Verbindungstrennung von Gladys Plus… SEHR ärgerlich.

Letzten Dienstag hatte ich einen Internetausfall bei mir zu Hause (Freebox, die nicht mehr synchronisierte) für 2 oder 3 Stunden.
Beim Neustart führt die Freebox ein Update durch und ab da stelle ich fest, dass ich keine Trennungen mehr habe… Ich denke, alles wird besser! … bis Samstagmorgen: wieder getrennt

[pierre-gilles]

Mist, in diesem Fall ist es tatsächlich am besten, alle 1 Minute einen Healthcheck durchzuführen, um präzise Alerts zu erhalten, wann das Problem auftritt bzw. wann es wieder behoben ist.

Vielleicht führt der längere Ausfall deiner Internetverbindung dazu, dass sich Ereignisse ansammeln, die an den Gladys Plus-Server gesendet werden sollen, und Gladys hat dann Schwierigkeiten, wieder die Kontrolle zu übernehmen. Genau aus diesem Grund kann uns mehr präzise Daten über die Häufigkeit und Dauer der Ausfälle helfen, das Problem zu verstehen.

[guim31]

Es hätte ja nur einer Erwähnung bedurft… Ich war gerade auf meinem Gladys unterwegs (ich bin bei der Arbeit) und zack, abgemeldet.

Ein Neustart des Containers und ich werde meine Szene erstellen! Ich halte dich auf dem Laufenden

EDIT: Alles ist eingerichtet… jetzt warte ich auf das nächste Problem!

[guim31]

Heute Morgen stelle ich fest, dass ich immer noch offline bin.

Auf healthcheck.io wird weiterhin korrekt gepingt.

Leider kann ich nicht mehr als 100 Zeilen der Historie anzeigen, daher kann ich nicht feststellen, ob es in der Nacht ein Problem gab.

[pierre-gilles]

@guim31

daher kann ich nicht wissen, ob es in der Nacht ein Problem gab.

Ja, du erhältst eine E-Mail, wenn ein Check ausfällt (Oder ein anderer Dienst, wenn du einen anderen Dienst konfiguriert hast, z. B. Telegram)

[guim31]

Na ja, in diesem Fall: keine Mail, nichts.

[pierre-gilles]

Okay, also keine Internetunterbrechung, wenn es noch läuft (oder zumindest keine Unterbrechung von mehr als 1 Minute)

Hast du mehr Informationen darüber, wann das passiert? Vielleicht noch andere Logs?

[guim31]

Ich suche zwar, aber ich finde absolut nichts.
Vor allem, weil es schließlich auf ziemlich zufällige Weise passiert: tagsüber / nachts…

[pierre-gilles]

Welche Art von Aktivität hast du auf deiner Instanz? Ultra intensiv oder eher okay?

Könnten es ein oder mehrere zu aggressive Sensoren sein, die Gladys „verschmutzen“ und deine Instanz zum Einfrieren bringen?

Nutzt du die Google Home- oder Alexa-Integration?

[guim31]

Also glaube ich nicht, dass es eine extrem intensive Aktivität gibt, aber ich habe viele Sensoren, also vielleicht ist da ein Schwätzer dabei. Wie könnte ich das herausfinden?

Ich nutze weder Google Home noch Alexa.

[pierre-gilles]

@guim31

Wie kann ich das herausfinden?

Man kann deine Datenbank analysieren Weißt du, wie du deine Datenbank extrahieren und einige Abfragen darauf ausführen kannst?

Ich hatte eine SQL-Abfrage im Forum geteilt

[guim31]

Ich könnte zwar leicht zur Datenbank navigieren, aber ich weiß nicht, wie ich sie herunterladen (mit wget?) und darauf Operationen durchführen soll.

Ich finde die von dir erwähnte Abfrage einfach nicht …

[pierre-gilles]

Man muss Gladys stoppen, dann kannst du die Datenbank mit einem Tool wie Cyberduck oder FileZilla herunterladen

Danach kannst du TablePlus verwenden, um Abfragen auf der Datei auszuführen!

Ich versuche, die Abfrage für dich zu finden

[pierre-gilles]

Hilfe! Problem mit der Aggregation?

@lmilcent Hop c’est cadeau: SELECT COUNT(t_device_feature_state.id), device_feature_id, t_device_feature.name as feature_name, t_device.name as device_name FROM t_device_feature_state JOIN t_device_feature ON t_device_feature.id = device_feature_id JOIN t_device ON t_device.id = t_device_feature.device_id GROUP BY device_feature_id ORDER BY COUNT(t_device_feature_state.id) DESC;

[guim31]

Super, danke für deine Hilfe, ich ziehe gerade meine Datenbank auf meinen Laptop um… 24 GB Übertragung läuft langsam (danke FTP-Transfer über WLAN…).

Sobald ich das habe, führe ich die SQL-Abfrage aus und poste das Ergebnis hier.

[guim31]

Hier klebe ich das Ergebnis der Anfrage (im JSON-Format, sorry, ich habe keine bessere Möglichkeit gefunden, um es im Forum einzufügen):

	
0	
COUNT(t_device_feature_state.id)	"2709800"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
feature_name	"Verbrauchte Leistung"
device_name	"Messung Verbrauch"
1	
COUNT(t_device_feature_state.id)	"2709800"
device_feature_id	"5c6f6494-dcf7-4eea-9f5f-1f2f4ea29083"
feature_name	"Signalstärke"
device_name	"Messung Verbrauch"
2	
COUNT(t_device_feature_state.id)	"2709800"
device_feature_id	"ad6d2942-a329-4a04-8cd3-5f6328dcd0d2"
feature_name	"Durchschnittsspannung"
device_name	"Messung Verbrauch"
3	
COUNT(t_device_feature_state.id)	"2709799"
device_feature_id	"34e1765d-a24b-46f1-92db-754062b84567"
feature_name	"Verbrauchte Stärke"
device_name	"Messung Verbrauch"
4	
COUNT(t_device_feature_state.id)	"2709799"
device_feature_id	"f698ae49-fb13-430c-8211-8038157a1890"
feature_name	"Verbrauchte Energie"
device_name	"Messung Verbrauch"
5	
COUNT(t_device_feature_state.id)	"370112"
device_feature_id	"5a228014-4a17-4481-9c20-9a2b5ca2edd5"
feature_name	"Schalter"
device_name	"NASDOURY-Steckdose"
6	
COUNT(t_device_feature_state.id)	"370112"
device_feature_id	"5e4ce261-7975-4e17-94f7-b1a7a1b4667f"
feature_name	"NAS-Verbrauch"
device_name	"NASDOURY-Steckdose"
7	
COUNT(t_device_feature_state.id)	"369156"
device_feature_id	"6062d7cd-2117-46cb-a05e-977f9f8c2834"
feature_name	"Signalstärke"
device_name	"Garagentor"
8	
COUNT(t_device_feature_state.id)	"369156"
device_feature_id	"b73fa27e-8782-46ad-a535-bd12ed11380c"
feature_name	"Schalter"
device_name	"Garagentor"
9	
COUNT(t_device_feature_state.id)	"367875"
device_feature_id	"b53bd970-339c-42c6-bc10-c5c6ac063a55"
feature_name	"Schalter"
device_name	"Schiebetor"
10	
COUNT(t_device_feature_state.id)	"255295"
device_feature_id	"4bc897ed-684a-42e2-ae5b-6e97d28798af"
feature_name	"Verbrauchte Stärke"
device_name	"Kühlschrank"
11	
COUNT(t_device_feature_state.id)	"255295"
device_feature_id	"9bf31899-f6d7-4639-9bf0-54ce43ac1e8d"
feature_name	"Verbrauchte Energie"
device_name	"Kühlschrank"
12	
COUNT(t_device_feature_state.id)	"255295"
device_feature_id	"b94bc1eb-780f-4057-81f7-a8794f2295d5"
feature_name	"Kühlschrankleistung"
device_name	"Kühlschrank"
13	
COUNT(t_device_feature_state.id)	"255295"
device_feature_id	"eab06631-6e85-447b-8d14-55c56838dadb"
feature_name	"Schalter"
device_name	"Kühlschrank"
14	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"275650f9-084e-4e55-b014-17ab6efd9017"
feature_name	"Verbrauchte Leistung"
device_name	"Wäschesteckdose"
15	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"8b67cea5-64b9-435a-94c6-b80d9c4e446b"
feature_name	"Signalstärke"
device_name	"Wäschesteckdose"
16	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"a3971f66-6994-47d7-9ee1-0fa97892ff28"
feature_name	"Durchschnittsspannung"
device_name	"Wäschesteckdose"
17	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"ad73644b-c4b7-48ac-811d-416fde00ab5e"
feature_name	"Verbrauchte Energie"
device_name	"Wäschesteckdose"
18	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"c0af51c9-c569-456b-bebd-d72dbd9246c5"
feature_name	"Schalter"
device_name	"Wäschesteckdose"
19	
COUNT(t_device_feature_state.id)	"187123"
device_feature_id	"ebe8d0e6-8ec2-4241-8c4f-7bb51865b1c9"
feature_name	"Verbrauchte Stärke"
device_name	"Wäschesteckdose"
20	
COUNT(t_device_feature_state.id)	"176758"
device_feature_id	"60d8d1c4-ea6a-4ee5-a0a4-0bba36c4f195"
feature_name	"Verbrauchte Energie"
device_name	"🌀​ Poolpumpe "
21	
COUNT(t_device_feature_state.id)	"176758"
device_feature_id	"897855fb-4604-4dbe-926c-2509cb4ff5a8"
feature_name	"Schalter"
device_name	"🌀​ Poolpumpe "
22	
COUNT(t_device_feature_state.id)	"176758"
device_feature_id	"8e3bc76b-460e-4a69-8599-6b1a04661068"
feature_name	"Poolpumpenverbrauch"
device_name	"🌀​ Poolpumpe "
23	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"03688620-b18e-44bb-8715-41ec7c807dd7"
feature_name	"Signalstärke"
device_name	"Glättungssteckdose"
24	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"254b7fc5-6d2f-455d-8614-fcd4f665f86e"
feature_name	"Durchschnittsspannung"
device_name	"Glättungssteckdose"
25	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"62a31453-74cc-4aba-bbef-a540cec4bd5c"
feature_name	"Verbrauchte Stärke"
device_name	"Glättungssteckdose"
26	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"d0021da7-6b04-483b-8b76-b27241af64a2"
feature_name	"Schalter"
device_name	"Glättungssteckdose"
27	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"db52b727-7137-49b3-9175-11104f2f73b4"
feature_name	"Verbrauchte Leistung"
device_name	"Glättungssteckdose"
28	
COUNT(t_device_feature_state.id)	"169718"
device_feature_id	"dea897e2-f877-4e31-9b97-997118d3c687"
feature_name	"Verbrauchte Energie"
device_name	"Glättungssteckdose"
29	
COUNT(t_device_feature_state.id)	"129776"
device_feature_id	"1c2bc447-7bbd-4eff-9755-a8e360316739"
feature_name	"PV-Produktion (kWh)"
device_name	"PV-Produktion"
30	
COUNT(t_device_feature_state.id)	"129776"
device_feature_id	"49d9e7d3-8c6f-4fdd-9ca8-745b4dcd10be"
feature_name	"Hausverbrauch (kWh)"
device_name	"Hausverbrauch"
31	
COUNT(t_device_feature_state.id)	"129757"
device_feature_id	"6f30443c-8aad-48bd-96c5-391730392abd"
feature_name	"Netzverkauf"
device_name	"Netzverkaufsverwendung"
32	
COUNT(t_device_feature_state.id)	"129757"
device_feature_id	"86b1d2cd-c539-4fad-b398-95bc691ff27a"
feature_name	"EDF-Netz (kWh)"
device_name	"Netzverbrauchsverwendung"
33	
COUNT(t_device_feature_state.id)	"126235"
device_feature_id	"d53e0e17-a9a2-4192-b0e7-636dadeb3451"
feature_name	"Anwesenheit"
device_name	"Switch 48 PoE"
34	
COUNT(t_device_feature_state.id)	"126234"
device_feature_id	"6df35bd2-40c1-4b4c-9f76-81fca25ef2fc"
feature_name	"Anwesenheit"
device_name	"Drucker"
35	
COUNT(t_device_feature_state.id)	"126232"
device_feature_id	"c81396be-7603-4b5d-8151-dbe6dad719a9"
feature_name	"Anwesenheit"
device_name	"Freebox Server"
36	
COUNT(t_device_feature_state.id)	"126227"
device_feature_id	"dfaf030a-6d1a-46bf-b411-d382c18f39d3"
feature_name	"Anwesenheit"
device_name	"Kamera 1"
37	
COUNT(t_device_feature_state.id)	"126226"
device_feature_id	"0258f3de-bc05-404f-9ef8-205005b78c6e"
feature_name	"Anwesenheit"
device_name	"Kamera 2 "
38	
COUNT(t_device_feature_state.id)	"123610"
device_feature_id	"b6203951-70b7-40c2-a5b1-f85e928ffb56"
feature_name	"Kindersicherung"
device_name	"Glättungssteckdose"
39	
COUNT(t_device_feature_state.id)	"118484"
device_feature_id	"fc7525db-9e3f-409e-850f-fb55519fbfd6"
feature_name	"Anwesenheit"
device_name	"DENON S650"
40	
COUNT(t_device_feature_state.id)	"114734"
device_feature_id	"602a9d6b-0636-4a34-bbaf-04eb898e3019"
feature_name	"Anwesenheit"
device_name	"NASDOURY"
41	
COUNT(t_device_feature_state.id)	"109483"
device_feature_id	"b32c7ffb-32c3-4c0c-b968-5ec7212c38b8"
feature_name	"Schalter"
device_name	"NUC-Steckdose"
42	
COUNT(t_device_feature_state.id)	"109482"
device_feature_id	"37fe54f3-8eca-420f-b520-50b2cd29bb68"
feature_name	"NUC-Verbrauch"
device_name	"NUC-Steckdose"
43	
COUNT(t_device_feature_state.id)	"102984"
device_feature_id	"d3a07fa5-03d3-4e4e-b083-152bd217bc5f"
feature_name	"Anwesenheit"
device_name	"Wechselrichter"
44	
COUNT(t_device_feature_state.id)	"87635"
device_feature_id	"d192de0d-8268-44ad-a9e6-ae44867e095b"
feature_name	"Verbrauchte Energie"
device_name	"Gartensteckdose"
45	
COUNT(t_device_feature_state.id)	"87635"
device_feature_id	"e15cf56b-83e9-4eb9-b13e-ecb3956107cf"
feature_name	"Verbrauchte Leistung"
device_name	"Gartensteckdose"
46	
COUNT(t_device_feature_state.id)	"80935"
device_feature_id	"108a0efc-944a-49a5-821c-ff8cbc918989"
feature_name	"Beleuchtungstemperatur"
device_name	"Guilhems Nachttisch"
47	
COUNT(t_device_feature_state.id)	"80935"
device_feature_id	"655e61ca-0d65-4f97-b8a1-6e7272febec4"
feature_name	"Beleuchtungshelligkeit"
device_name	"Guilhems Nachttisch"
48	
COUNT(t_device_feature_state.id)	"80935"
device_feature_id	"ec820624-b322-47ee-b0d1-9818756facc0"
feature_name	"Beleuchtung Ein/Aus"
device_name	"Guilhems Nachttisch"
49	
COUNT(t_device_feature_state.id)	"78001"
device_feature_id	"4cbb5b61-d909-46ad-ae93-b1c2e85ef838"
feature_name	"Beleuchtungshelligkeit"
device_name	"Sophies Nachttisch"
50	
COUNT(t_device_feature_state.id)	"78001"
device_feature_id	"4d17ad37-c266-4b69-9cdb-e2ec47daede4"
feature_name	"Eclairage Ein/Aus"
device_name	"Chevet Sophie"
51	
COUNT(t_device_feature_state.id)	"78001"
device_feature_id	"89867f20-0f3a-4019-8b1f-5468ca23cec4"
feature_name	"Signalstärke"
device_name	"Chevet Sophie"
52	
COUNT(t_device_feature_state.id)	"78001"
device_feature_id	"ffe20476-c2b2-44ae-ab1a-c75ff1bccee8"
feature_name	"Beleuchtungstemperatur"
device_name	"Chevet Sophie"
53	
COUNT(t_device_feature_state.id)	"74769"
device_feature_id	"9e7ec4cc-022d-4df7-8288-c3983ece0c39"
feature_name	"Präsenz"
device_name	"Galaxy S23 Sophie"
54	
COUNT(t_device_feature_state.id)	"50426"
device_feature_id	"217c7b6d-81d4-412a-b19b-574de883eb8f"
feature_name	"Schalter"
device_name	"Wasserhahn"
55	
COUNT(t_device_feature_state.id)	"50426"
device_feature_id	"95b65412-8c6d-4b57-b639-0fafb6e1728b"
feature_name	"Signalstärke"
device_name	"Wasserhahn"
56	
COUNT(t_device_feature_state.id)	"46434"
device_feature_id	"037fd573-5af5-48d2-b245-283b83806bc2"
feature_name	"Präsenz"
device_name	"SOLAREDGE"
57	
COUNT(t_device_feature_state.id)	"33185"
device_feature_id	"bbd52a89-202c-490b-939e-a9003d596c88"
feature_name	"Kindersicherung"
device_name	"Wäscheklemme"
58	
COUNT(t_device_feature_state.id)	"32055"
device_feature_id	"48a97355-d8e2-4fa2-aa72-166143c4566b"
feature_name	"Wohnzimmer"
device_name	"Wohnzimmer Temperatur"
59	
COUNT(t_device_feature_state.id)	"32055"
device_feature_id	"67828420-a788-40db-8a1e-abdfa2b7ec03"
feature_name	"Wohnzimmer"
device_name	"Wohnzimmer Temperatur"
60	
COUNT(t_device_feature_state.id)	"32055"
device_feature_id	"a1b3b112-8649-4c14-8a3d-e2933b8d0521"
feature_name	"Druckdezimalwert"
device_name	"Wohnzimmer Temperatur"
61	
COUNT(t_device_feature_state.id)	"29465"
device_feature_id	"bdc6f0b7-da2e-46dc-9da5-eb8700929ca0"
feature_name	"Präsenz"
device_name	"TV"
62	
COUNT(t_device_feature_state.id)	"25925"
device_feature_id	"eaa0c4ab-259e-460f-9193-dff52eb416f1"
feature_name	"Tagesverbrauch"
device_name	"Verbrauch"
63	
COUNT(t_device_feature_state.id)	"21755"
device_feature_id	"7bab1e21-4696-47a1-aa54-bf5323f1316a"
feature_name	"Außen Temperatur"
device_name	"Garten Temperatur"
64	
COUNT(t_device_feature_state.id)	"21755"
device_feature_id	"dab34dcc-836e-437e-beb9-f9cd50ffb834"
feature_name	"Luftfeuchtigkeit"
device_name	"Garten Temperatur"
65	
COUNT(t_device_feature_state.id)	"19813"
device_feature_id	"6abde235-08ff-4d45-899d-ccbc6c6ea0fa"
feature_name	"Signalstärke"
device_name	"Helligkeit"
66	
COUNT(t_device_feature_state.id)	"19813"
device_feature_id	"743da3c3-f4d1-4dc6-b834-c15a2b36f8fc"
feature_name	"Batterie"
device_name	"Helligkeit"
67	
COUNT(t_device_feature_state.id)	"19813"
device_feature_id	"86551ff8-ff10-4a70-bce7-89b4c1d0ef46"
feature_name	"Helligkeit Dezimal"
device_name	"Helligkeit"
68	
COUNT(t_device_feature_state.id)	"19813"
device_feature_id	"a41a2be3-08f5-488a-8ba6-81190c36bd3d"
feature_name	"Durchschnittsspannung"
device_name	"Helligkeit"
69	
COUNT(t_device_feature_state.id)	"18645"
device_feature_id	"b9e638ca-e50d-443c-8541-25de712462de"
feature_name	"Präsenz"
device_name	"Mi9T Guilhem"
70	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"1cbfb505-3bcf-47a9-9f50-bb844a9c2f9e"
feature_name	"Kindersicherung"
device_name	"Subwoofer Steckdose"
71	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"305f90bb-4f75-4d7f-b202-2e73f72609bb"
feature_name	"Signalstärke"
device_name	"Subwoofer Steckdose"
72	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"45e93ca2-0dbc-4d3d-b0ea-90446a4d1870"
feature_name	"Verbrauch"
device_name	"Subwoofer Steckdose"
73	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"5891d7a1-be9b-4faa-898e-1da64143d7fe"
feature_name	"Schalter"
device_name	"Subwoofer Steckdose"
74	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"bc5cdb7d-e18e-479a-bb5f-8f16b96a84a0"
feature_name	"Verbrauchte Leistung"
device_name	"Subwoofer Steckdose"
75	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"e3dbdc45-8415-424f-83e2-31905b5a4bf9"
feature_name	"Durchschnittsspannung"
device_name	"Subwoofer Steckdose"
76	
COUNT(t_device_feature_state.id)	"16515"
device_feature_id	"fc82045f-7ba7-4e2c-b536-bc2ba2162120"
feature_name	"Verbrauch"
device_name	"Subwoofer Steckdose"
77	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"1e47215c-5ab9-4a14-b07d-92b96ceed9e8"
feature_name	"Verbrauch"
device_name	"Denon Verstärker Steckdose"
78	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"8b64d5c5-a1f4-4b3f-9c92-9bb3f9e69789"
feature_name	"Signalstärke"
device_name	"Denon Verstärker Steckdose"
79	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"9621ad34-ab0e-4505-86bb-11f483b2639b"
feature_name	"Kindersicherung"
device_name	"Denon Verstärker Steckdose"
80	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"a5aa323a-f50e-4d80-98d3-6474236d2427"
feature_name	"Verbrauch"
device_name	"Denon Verstärker Steckdose"
81	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"bac6cd45-cc6b-4e62-9e7a-8ee44bcafa2d"
feature_name	"Durchschnittsspannung"
device_name	"Denon Verstärker Steckdose"
82	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"ddd6cfe4-5448-4e02-ac76-e69452c3c287"
feature_name	"Schalter"
device_name	"Denon Verstärker Steckdose"
83	
COUNT(t_device_feature_state.id)	"15082"
device_feature_id	"e3486be6-c61a-44e7-b8a9-02b32587046a"
feature_name	"Verbrauchte Leistung"
device_name	"Denon Verstärker Steckdose"
84	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"0aa78d43-a621-4c8b-8233-0b69ff749f5d"
feature_name	"Durchschnittsspannung"
device_name	"Bewegung Eingang"
85	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"2199a794-940c-4ecf-a65a-22356ab0d891"
feature_name	"Temperatur"
device_name	"Bewegung Eingang"
86	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"2cd0395a-a909-4145-bc04-1a1120c1bc35"
feature_name	"Bewegung Ja/Nein"
device_name	"Bewegung Eingang"
87	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"5b3463f3-5ea9-487d-b4e6-7a5e337a13e0"
feature_name	"Batterie"
device_name	"Bewegung Eingang"
88	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"774e6be3-49d8-4fdf-8d0f-7c1142401cb7"
feature_name	"Signalstärke"
device_name	"Bewegung Eingang"
89	
COUNT(t_device_feature_state.id)	"14610"
device_feature_id	"c4524b08-7cd8-4331-b04d-10b25c392fe2"
feature_name	"Helligkeit Dezimal"
device_name	"Bewegung Eingang"
90	
COUNT(t_device_feature_state.id)	"13780"
device_feature_id	"68ac2240-7096-48d5-acce-b677520a5a37"
feature_name	"Druckdezimalwert"
device_name	"Garage Temperatur"
91	
COUNT(t_device_feature_state.id)	"13780"
device_feature_id	"c70aa7d1-13f0-42ae-84f0-8590c7347d18"
feature_name	"Garage"
device_name	"Garage Temperatur"
92	
COUNT(t_device_feature_state.id)	"13780"
device_feature_id	"f65b143f-eaf4-428f-a5ba-409675eb0462"
feature_name	"Garage"
device_name	"Garage Temperatur"
93	
COUNT(t_device_feature_state.id)	"11932"
device_feature_id	"0ceec336-560e-49fe-80cf-b4aed629e152"
feature_name	"Rubens Zimmer"
device_name	"Rubens Zimmer Temperatur"
94	
COUNT(t_device_feature_state.id)	"11932"
device_feature_id	"326841e0-cba5-4542-a48e-a51d24a6381e"
feature_name	"Rubens Zimmer"
device_name	"Rubens Zimmer Temperatur"
95	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"0dcfd8ed-29bc-44fc-9983-0fa973ae44bf"
feature_name	"Temperatur"
device_name	"Garagenportal Bewegung"
96	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"0e88bfa5-77b1-4ca9-9ca2-cb0f120c7027"
feature_name	"Helligkeit Dezimal"
device_name	"Garagenportal Bewegung"
97	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"0ef6f592-6d29-42c1-99e2-9f139861160f"
feature_name	"Batterie"
device_name	"Garagenportal Bewegung"
98	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"2222f5da-ddf4-4797-83cf-652faa4134d5"
feature_name	"Signalstärke"
device_name	"Garagenportal Bewegung"
99	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"42162f60-47bb-4a01-8d90-0c5d0338e6ca"
feature_name	"Durchschnittsspannung"
device_name	"Garagenportal Bewegung"
100	
COUNT(t_device_feature_state.id)	"11806"
device_feature_id	"99625a0c-2871-400f-84e0-0487c26cc591"
feature_name	"Bewegung Ja/Nein"
device_name	"Bewegung Garagentor"
101	
COUNT(t_device_feature_state.id)	"11466"
device_feature_id	"0ec538d5-ea59-4571-8877-c84e661532d7"
feature_name	"Melodie"
device_name	"Alarme Orange"
102	
COUNT(t_device_feature_state.id)	"11466"
device_feature_id	"2077dd76-6cc8-451f-908b-951deb6e91a2"
feature_name	"Batterie"
device_name	"Alarme Orange"
103	
COUNT(t_device_feature_state.id)	"11466"
device_feature_id	"e789bfed-1404-4cb3-b214-85ec9a04aca6"
feature_name	"Lautstärke der Sirene"
device_name	"Alarme Orange"
104	
COUNT(t_device_feature_state.id)	"11289"
device_feature_id	"24eece28-45a9-411c-9ffa-fbbe5ed9014e"
feature_name	"Öffnen / Schließen"
device_name	"Poolbefüllung"
105	
COUNT(t_device_feature_state.id)	"11236"
device_feature_id	"2f1f12be-60ef-42fd-aee2-72fdc366dad1"
feature_name	"Elternschlafzimmer"
device_name	"Temperatur Elternschlafzimmer"
106	
COUNT(t_device_feature_state.id)	"11236"
device_feature_id	"36e279cc-e960-4379-871f-211eec0a5d09"
feature_name	"Elternschlafzimmer"
device_name	"Temperatur Elternschlafzimmer"
107	
COUNT(t_device_feature_state.id)	"10951"
device_feature_id	"3f7209fa-d705-4fef-a29d-b2d06bf932a8"
feature_name	"Gästehzimmer"
device_name	"Temperatur Gästehzimmer"
108	
COUNT(t_device_feature_state.id)	"10951"
device_feature_id	"407fcf33-ce7d-4ac6-bb80-b52be9a52b98"
feature_name	"Gästehzimmer"
device_name	"Temperatur Gästehzimmer"
109	
COUNT(t_device_feature_state.id)	"10696"
device_feature_id	"73289f39-67d6-4b11-86ed-03590aaf409a"
feature_name	"Büro"
device_name	"Temperatur Büro"
110	
COUNT(t_device_feature_state.id)	"10696"
device_feature_id	"e909ecf2-f395-4e1d-a820-267565edb0a0"
feature_name	"Büro"
device_name	"Temperatur Büro"
111	
COUNT(t_device_feature_state.id)	"10146"
device_feature_id	"363f22e1-e608-47dc-bad1-7ca6e09abdc1"
feature_name	"Druckwert"
device_name	"Temperatur Romelie"
112	
COUNT(t_device_feature_state.id)	"10146"
device_feature_id	"4b642b1b-f2cd-47f5-a476-ff716cae9cce"
feature_name	"Schlafzimmer Romélie"
device_name	"Temperatur Romelie"
113	
COUNT(t_device_feature_state.id)	"10146"
device_feature_id	"c76abcd0-dbd8-4c25-ab90-3250b913b7fd"
feature_name	"Schlafzimmer Romélie"
device_name	"Temperatur Romelie"
114	
COUNT(t_device_feature_state.id)	"9330"
device_feature_id	"81c2f23c-d8cb-4101-8ad7-974081316b9d"
feature_name	"Signalstärke"
device_name	"Rollo - TV"
115	
COUNT(t_device_feature_state.id)	"9330"
device_feature_id	"ac9d99bf-533f-4c82-a45b-b986c78a79d5"
feature_name	"Zustand des Rollos"
device_name	"Rollo - TV"
116	
COUNT(t_device_feature_state.id)	"9330"
device_feature_id	"f2a7c728-9952-44d0-b81a-732b1f09807c"
feature_name	"Position des Rollos"
device_name	"Rollo - TV"
117	
COUNT(t_device_feature_state.id)	"8330"
device_feature_id	"1a01f9d2-6d31-4d7b-8ef3-97217f09cebc"
feature_name	"Position des Rollos"
device_name	"Rollo - Schlafzimmer"
118	
COUNT(t_device_feature_state.id)	"8330"
device_feature_id	"1ae8c0ce-ce76-471c-a86f-faeac31f6dc3"
feature_name	"Signalstärke"
device_name	"Rollo - Schlafzimmer"
119	
COUNT(t_device_feature_state.id)	"8330"
device_feature_id	"906d34a6-64d3-44b8-a007-3c30a1588dae"
feature_name	"Zustand des Rollos"
device_name	"Rollo - Schlafzimmer"
120	
COUNT(t_device_feature_state.id)	"8214"
device_feature_id	"9fe5b638-ccec-4845-bf27-9afcda995f95"
feature_name	"Azimut"
device_name	"Sonneneinstrahlung"
121	
COUNT(t_device_feature_state.id)	"8214"
device_feature_id	"e84f49af-185c-42bf-ae69-20ac2e4eb20e"
feature_name	"Höhe"
device_name	"Sonneneinstrahlung"
122	
COUNT(t_device_feature_state.id)	"7617"
device_feature_id	"2d8d4fee-aeef-478e-aa8b-d1df6041a6ce"
feature_name	"Zustand des Rollos"
device_name	"Rollo - Pool"
123	
COUNT(t_device_feature_state.id)	"7617"
device_feature_id	"4b9d9940-cbec-4f07-a771-790ae54fc5d2"
feature_name	"Signalstärke"
device_name	"Rollo - Pool"
124	
COUNT(t_device_feature_state.id)	"7617"
device_feature_id	"b157f868-e016-449c-8e76-8781131e90b0"
feature_name	"Position des Rollos"
device_name	"Rollo - Pool"
125	
COUNT(t_device_feature_state.id)	"7508"
device_feature_id	"4bda9984-d0e2-4c9a-ad5d-436a957afbb4"
feature_name	"Licht"
device_name	"Büroschalter"
126	
COUNT(t_device_feature_state.id)	"7249"
device_feature_id	"18277bdb-2c03-414b-9605-2d13ce5747a7"
feature_name	"Schalter"
device_name	"💡 Wohnzimmerlicht"
127	
COUNT(t_device_feature_state.id)	"6732"
device_feature_id	"ba4e87b9-7227-41ca-8fae-9267644c268d"
feature_name	"Signalstärke"
device_name	"Bewässerungsschalter"
128	
COUNT(t_device_feature_state.id)	"6732"
device_feature_id	"cabbf1c7-e623-4d0f-96e8-e18fc1a9f1a7"
feature_name	"Schalter"
device_name	"Bewässerungsschalter"
129	
COUNT(t_device_feature_state.id)	"6561"
device_feature_id	"2a927909-adc4-4d00-994f-8061d9093fb4"
feature_name	"Pooltemperatur"
device_name	"Pooltemperatur"
130	
COUNT(t_device_feature_state.id)	"6323"
device_feature_id	"3dc53b8f-9f5d-4707-af7d-949dd056bd33"
feature_name	"Signalstärke"
device_name	"Tropfbewässerungsschalter"
131	
COUNT(t_device_feature_state.id)	"6323"
device_feature_id	"6aa1d7dc-4ccd-4d53-9529-bcdedac7400e"
feature_name	"Schalter"
device_name	"Tropfbewässerungsschalter"
132	
COUNT(t_device_feature_state.id)	"5690"
device_feature_id	"38e166e3-9cbf-493f-9f13-66b74a68f126"
feature_name	"Beleuchtung Ein/Aus"
device_name	"Birne Schlafzimmer Ruben"
133	
COUNT(t_device_feature_state.id)	"5690"
device_feature_id	"3d53e584-b954-439b-9644-387a3016fae4"
feature_name	"Beleuchtungstemperatur"
device_name	"Birne Schlafzimmer Ruben"
134	
COUNT(t_device_feature_state.id)	"5690"
device_feature_id	"afeb8c7a-0d72-4f74-a241-6830e05f3044"
feature_name	"Helligkeit der Beleuchtung"
device_name	"Birne Schlafzimmer Ruben"
135	
COUNT(t_device_feature_state.id)	"5690"
device_feature_id	"c3d6a2bc-3e86-40c5-89d9-a36ca0dfa9c2"
feature_name	"Signalstärke"
device_name	"Birne Schlafzimmer Ruben"
136	
COUNT(t_device_feature_state.id)	"5626"
device_feature_id	"3d6fe393-b942-44d3-bd1c-d7d9204bd547"
feature_name	"Beleuchtung Ein/Aus"
device_name	"Birne Schlafzimmer Romélie"
137	
COUNT(t_device_feature_state.id)	"5424"
device_feature_id	"38ecaa9d-b148-410b-9e3a-542606044b23"
feature_name	"Signalstärke"
device_name	"Router Elternschlafzimmer"
138	
COUNT(t_device_feature_state.id)	"5258"
device_feature_id	"f4216d19-eaee-4455-ad09-de95f164aaa4"
feature_name	"Signalstärke"
device_name	"Garten-Router"
139	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"00765e20-5323-4886-a40e-8a4349e1971d"
feature_name	"Durchschnittliche Spannung"
device_name	"Öffnung der Glasfront des Pools"
140	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"512b2fc2-bc64-407f-83b2-16df1b4ece65"
feature_name	"Signalstärke"
device_name	"Öffnung der Glasfront des Pools"
141	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"576af393-7248-4f70-830a-9727a6ca8729"
feature_name	"Batterie"
device_name	"Öffnung der Glasfront des Pools"
142	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"9a1cb18d-aff6-4525-8320-755fc7a0206f"
feature_name	"Temperatur"
device_name	"Öffnung der Glasfront des Pools"
143	
COUNT(t_device_feature_state.id)	"4695"
device_feature_id	"b60c2eec-7913-475b-a146-7bb96e3fdf08"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Öffnung der Glasfront des Pools"
144	
COUNT(t_device_feature_state.id)	"4333"
device_feature_id	"0e8bb70b-12a5-4adc-84a3-4553e15fd833"
feature_name	"Temperatur"
device_name	"Öffnung des Garagentors"
145	
COUNT(t_device_feature_state.id)	"4333"
device_feature_id	"883640f9-4943-4414-ae0f-52b75d97625f"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Öffnung des Garagentors"
146	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"375a7fb9-c185-4a3a-bbef-9d66a43f04da"
feature_name	"Durchschnittliche Spannung"
device_name	"Öffnung der Eingangstür"
147	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"5203a6d0-f66a-434c-b8ea-2cddd5aa2707"
feature_name	"Batterie"
device_name	"Öffnung der Eingangstür"
148	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"7b5abe18-8072-4c7d-98f4-111c5b046f63"
feature_name	"Öffnung (Ja/Nein)"device_name	"Türöffnung Eingang"
149	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"9c0914bd-b7a1-49bf-b8dd-3872148b03c6"
feature_name	"Signalstärke"
device_name	"Türöffnung Eingang"
150	
COUNT(t_device_feature_state.id)	"4283"
device_feature_id	"be2ab703-1db6-43a7-af7b-1528b6483963"
feature_name	"Temperatur"
device_name	"Türöffnung Eingang"
151	
COUNT(t_device_feature_state.id)	"2887"
device_feature_id	"19c1e1df-103f-4c71-bf34-ea3863622655"
feature_name	"Signalstärke"
device_name	"Inter 6 Tasten"
152	
COUNT(t_device_feature_state.id)	"2887"
device_feature_id	"31992d38-eb95-46dc-8055-261ccb0575b7"
feature_name	"Batterie"
device_name	"Inter 6 Tasten"
153	
COUNT(t_device_feature_state.id)	"2887"
device_feature_id	"9ba6c0a2-c6a2-4fde-9573-e90f50dde780"
feature_name	"Durchschnittsspannung"
device_name	"Inter 6 Tasten"
154	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"1f74c290-2ed4-4a78-9fd5-debcd326b0c3"
feature_name	"Durchschnittsspannung"
device_name	"Türöffnung Romélie-Zimmer"
155	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"3d2d6a20-dda3-47d7-a5a1-6aec48648310"
feature_name	"Signalstärke"
device_name	"Türöffnung Romélie-Zimmer"
156	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"8b2bf155-672d-42d8-82ed-438536803ba7"
feature_name	"Temperatur"
device_name	"Türöffnung Romélie-Zimmer"
157	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"ab7153bf-655e-4556-a8d0-c612124a78a3"
feature_name	"Batterie"
device_name	"Türöffnung Romélie-Zimmer"
158	
COUNT(t_device_feature_state.id)	"2808"
device_feature_id	"d216fafd-cf9f-4715-9c93-e5ce97d4f5d1"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Türöffnung Romélie-Zimmer"
159	
COUNT(t_device_feature_state.id)	"2703"
device_feature_id	"4ca21dd7-f049-43b4-a62c-efc94eb78368"
feature_name	"Temperatur"
device_name	"Türöffnung Garagentor"
160	
COUNT(t_device_feature_state.id)	"2703"
device_feature_id	"a69b7fe2-6908-4d39-bdde-1eef83c68138"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Türöffnung Garagentor"
161	
COUNT(t_device_feature_state.id)	"2682"
device_feature_id	"6171088f-e1cf-4ea6-ac7a-39bdb25c14a5"
feature_name	"Beleuchtung Ein/Aus"
device_name	"Lampe Elternzimmer"
162	
COUNT(t_device_feature_state.id)	"2673"
device_feature_id	"013529b5-43c8-4dd0-ad01-d3c67dbcbbae"
feature_name	"Signalstärke"
device_name	"Inter 4 Wohnzimmer TV"
163	
COUNT(t_device_feature_state.id)	"2673"
device_feature_id	"55b0af49-df11-4982-98fa-86772044c37c"
feature_name	"Batterie"
device_name	"Inter 4 Wohnzimmer TV"
164	
COUNT(t_device_feature_state.id)	"2673"
device_feature_id	"b4a995ae-1b06-4351-afaa-63085f4932a7"
feature_name	"Durchschnittsspannung"
device_name	"Inter 4 Wohnzimmer TV"
165	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"097816b1-2763-4200-9235-e93d863815e5"
feature_name	"Durchschnittsspannung"
device_name	"Türöffnung Wohnzimmerfenster"
166	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"1051d11e-86be-40ff-8948-41c29440af44"
feature_name	"Batterie"
device_name	"Türöffnung Wohnzimmerfenster"
167	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"96052a09-8a06-4060-8d54-9a9d02d884e8"
feature_name	"Temperatur"
device_name	"Türöffnung Wohnzimmerfenster"
168	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"cd7ef5db-ff10-426e-8b2e-49b5e4bd5172"
feature_name	"Signalstärke"
device_name	"Türöffnung Wohnzimmerfenster"
169	
COUNT(t_device_feature_state.id)	"2662"
device_feature_id	"e1e8254f-02e4-4488-9bed-1153fffa54fe"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Türöffnung Wohnzimmerfenster"
170	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"2a18625d-cad0-4c20-bc24-fdbb0d664f5d"
feature_name	"Signalstärke"
device_name	"Türöffnung Badezimmer"
171	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"2d3c8196-84bd-4d9c-b6e0-bb48f2276bc9"
feature_name	"Temperatur"
device_name	"Türöffnung Badezimmer"
172	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"5d15b405-d447-4c73-8d6c-5df0a92dfd27"
feature_name	"Durchschnittsspannung"
device_name	"Türöffnung Badezimmer"
173	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"68fd9390-c8b5-422c-a4cf-eb2523cf8e5d"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Türöffnung Badezimmer"
174	
COUNT(t_device_feature_state.id)	"2652"
device_feature_id	"c653c383-7a9a-4d3a-bb97-a9b0e806baf3"
feature_name	"Batterie"
device_name	"Türöffnung Badezimmer"
175	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"0db3ddcb-65d1-4237-8d88-1f0f251ee94d"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Türöffnung TV-Fensterfront"
176	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"56ad57e8-8a26-48e0-a821-8617d209e135"
feature_name	"Batterie"
device_name	"Türöffnung TV-Fensterfront"
177	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"7d2e5b01-abba-4df5-920c-3cbed27a3399"
feature_name	"Durchschnittsspannung"
device_name	"Türöffnung TV-Fensterfront"
178	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"ba608422-c80d-4dc4-97b4-6b17399d0ca6"
feature_name	"Temperatur"
device_name	"Türöffnung TV-Fensterfront"
179	
COUNT(t_device_feature_state.id)	"2649"
device_feature_id	"d830be06-b962-4c44-960d-954ab9fa4505"
feature_name	"Signalstärke"
device_name	"Türöffnung TV-Fensterfront"
180	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"1bb0feb8-dcd9-4b11-ade5-70224f5fefc1"
feature_name	"Batterie"
device_name	"Türöffnung Gästeschlafzimmer"
181	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"8faaafbf-c33d-4737-93c3-4e290228460a"
feature_name	"Durchschnittsspannung"
device_name	"Türöffnung Gästeschlafzimmer"
182	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"a0641142-c27e-4391-b9f3-17fb5c13a6da"
feature_name	"Temperatur"
device_name	"Türöffnung Gästeschlafzimmer"
183	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"ad7ec7e0-cf9a-4d81-9890-d97566788385"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Türöffnung Gästeschlafzimmer"
184	
COUNT(t_device_feature_state.id)	"2619"
device_feature_id	"da4dc8c1-1626-4a92-87a7-c617ff423c9f"
feature_name	"Signalstärke"
device_name	"Türöffnung Gästeschlafzimmer"
185	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"06fae8d0-7eee-4c1c-8e22-c1c5f33e23ab"
feature_name	"Durchschnittsspannung"
device_name	"Türöffnung Bürofenster"
186	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"6d75528b-390b-40de-aeb8-4ddecc67bb8a"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Türöffnung Bürofenster"
187	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"a62dd698-650c-419a-bcf9-6825a13d5b45"
feature_name	"Batterie"
device_name	"Türöffnung Bürofenster"
188	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"d3df4482-c4ff-47e3-b298-d95b8ec98a69"
feature_name	"Signalstärke"
device_name	"Türöffnung Bürofenster"
189	
COUNT(t_device_feature_state.id)	"2605"
device_feature_id	"eab015b9-c234-4c6a-af20-017f27b3fa8f"
feature_name	"Temperatur"
device_name	"Türöffnung Bürofenster"
190	
COUNT(t_device_feature_state.id)	"2584"
device_feature_id	"392ac79b-dd72-4bf6-b7bb-e4b6b6ebc6ae"
feature_name	"Durchschnittsspannung"
device_name	"Duschleckage"
191	
COUNT(t_device_feature_state.id)	"2584"
device_feature_id	"3d77971a-67df-4999-bf11-3ece2632c3dd"
feature_name	"Leckage (Ja/Nein)"
device_name	"Duschleckage"
192	
COUNT(t_device_feature_state.id)	"2584"
device_feature_id	"ff996d3b-3f6b-434a-aa4d-650079dadda3"
feature_name	"Batterie"
device_name	"Duschleckage"
193	
COUNT(t_device_feature_state.id)	"2521"
device_feature_id	"21fe9f89-c69d-44a3-9cfe-dcb49d2ed3a2"
feature_name	"Signalstärke"
device_name	"Türöffnung Ruben-Zimmer"
194	
COUNT(t_device_feature_state.id)	"2521"
device_feature_id	"95a8078a-dbfb-4539-ac65-f6ffb5b26014"
feature_name	"Durchschnittsspannung"
device_name	"Türöffnung Ruben-Zimmer"
195	
COUNT(t_device_feature_state.id)	"2521"
device_feature_id	"d18aac7e-5f7e-44a2-bbc6-fe47d7f3e8f7"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Türöffnung Ruben-Zimmer"
196	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"2783010e-0702-4e4b-b16a-7b5a8db611ab"
feature_name	"Batterie"
device_name	"Türöffnung Elternzimmer"197	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"2f7b00ca-0a3d-4ebf-b291-70a13f410183"
feature_name	"Öffnung (Ja/Nein)"
device_name	"Elternschlafzimmer-Öffnung"
198	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"cd63f74a-2cb2-425e-a625-fc1ecf0e8600"
feature_name	"Signalstärke"
device_name	"Elternschlafzimmer-Öffnung"
199	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"d1d918b0-3905-480b-ae4d-3d019301eab6"
feature_name	"Durchschnittsspannung"
device_name	"Elternschlafzimmer-Öffnung"
200	
COUNT(t_device_feature_state.id)	"2351"
device_feature_id	"fb149148-0da8-4173-b767-4d55c85e4e6a"
feature_name	"Temperatur"
device_name	"Elternschlafzimmer-Öffnung"
201	
COUNT(t_device_feature_state.id)	"2137"
device_feature_id	"13e702c1-6a9d-492d-bd65-d8d6ccb60f31"
feature_name	"Beleuchtungshelligkeit"
device_name	"Küchenrückseite-Lampe"
202	
COUNT(t_device_feature_state.id)	"2137"
device_feature_id	"398e2714-ce5c-434b-8a73-0185ae1d2eed"
feature_name	"Beleuchtungstemperatur"
device_name	"Küchenrückseite-Lampe"
203	
COUNT(t_device_feature_state.id)	"2137"
device_feature_id	"a86212c3-be53-49ad-a5b9-602783e35394"
feature_name	"Beleuchtung Ein/Aus"
device_name	"Küchenrückseite-Lampe"
204	
COUNT(t_device_feature_state.id)	"2034"
device_feature_id	"36d870c8-bb68-41db-a822-e4df1e524a96"
feature_name	"Bodenfeuchtigkeit"
device_name	"Bodenfeuchtigkeitssensor"
205	
COUNT(t_device_feature_state.id)	"1710"
device_feature_id	"5986cdf2-c257-48b2-97ba-aa5a64d25aef"
feature_name	"Beleuchtungshelligkeit"
device_name	"Gästeschlafzimmer-Lampe"
206	
COUNT(t_device_feature_state.id)	"1710"
device_feature_id	"cb288d6b-7acd-466a-be04-e6ee06543d5c"
feature_name	"Beleuchtung Ein/Aus"
device_name	"Gästeschlafzimmer-Lampe"
207	
COUNT(t_device_feature_state.id)	"1710"
device_feature_id	"dfda8172-4684-4bc1-b97f-aa3be9a8e5c6"
feature_name	"Beleuchtungstemperatur"
device_name	"Gästeschlafzimmer-Lampe"
208	
COUNT(t_device_feature_state.id)	"1710"
device_feature_id	"e8a816ab-f80f-4b64-abf1-00d3ba92bf30"
feature_name	"Signalstärke"
device_name	"Gästeschlafzimmer-Lampe"
209	
COUNT(t_device_feature_state.id)	"1130"
device_feature_id	"66114b90-2ff0-479c-b92a-fc1c315b265f"
feature_name	"Beleuchtung Ein/Aus"
device_name	"Büro 2-Lampe"
210	
COUNT(t_device_feature_state.id)	"809"
device_feature_id	"7bf1300c-dd9c-4a88-a090-bbb1e24fa4ce"
feature_name	"Signalstärke"
device_name	"Bewässerungsventil"
211	
COUNT(t_device_feature_state.id)	"809"
device_feature_id	"b31a31d0-0635-4925-ad17-8cf22813320e"
feature_name	"Batterie"
device_name	"Bewässerungsventil"
212	
COUNT(t_device_feature_state.id)	"469"
device_feature_id	"24347efa-7b8b-4129-9e60-44c67c832ce9"
feature_name	"Signalstärke"
device_name	"Gästezimmer-Router"
213	
COUNT(t_device_feature_state.id)	"469"
device_feature_id	"d9509f28-e5cf-4fdb-88f2-db4975bcc4bb"
feature_name	"Schwache Batterie (Ja/Nein)"
device_name	"Duschleckage"
214	
COUNT(t_device_feature_state.id)	"435"
device_feature_id	"276b9318-d220-4f8d-8724-b1f6649ca67f"
feature_name	"Beleuchtungstemperatur"
device_name	"Eingangs-Farbspot"
215	
COUNT(t_device_feature_state.id)	"435"
device_feature_id	"6b91319c-46f5-4b60-ae05-542dc24d1a29"
feature_name	"Beleuchtungshelligkeit"
device_name	"Eingangs-Farbspot"
216	
COUNT(t_device_feature_state.id)	"435"
device_feature_id	"8dc26644-a6fb-4a14-a575-915eaa370ee5"
feature_name	"Beleuchtung Ein/Aus"
device_name	"Eingangs-Farbspot"
217	
COUNT(t_device_feature_state.id)	"435"
device_feature_id	"9a7a1332-8c09-4921-86b6-5dea1228da39"
feature_name	"Beleuchtungsfarbe"
device_name	"Eingangs-Farbspot"
218	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"03506eca-2d2b-4d24-bd0d-ed6555d731e5"
feature_name	"Beleuchtung Ein/Aus"
device_name	"LED-Streifen"
219	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"2b55d5a2-6729-4eb5-92a0-6d18dc49dc08"
feature_name	"Beleuchtungstemperatur"
device_name	"LED-Streifen"
220	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"55c34624-e6ff-40ac-af33-dacb0c2e0186"
feature_name	"Beleuchtungsfarbe"
device_name	"LED-Streifen"
221	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"a6edbae5-2a21-4ae6-8c98-54501c7d5176"
feature_name	"Signalstärke"
device_name	"LED-Streifen"
222	
COUNT(t_device_feature_state.id)	"395"
device_feature_id	"af1bf389-e2e4-40d3-a296-7255b06848af"
feature_name	"Beleuchtungshelligkeit"
device_name	"LED-Streifen"
223	
COUNT(t_device_feature_state.id)	"88"
device_feature_id	"09634c1d-a8f6-4d04-969c-27245a1d8599"
feature_name	"Verbrauch im Standby"
device_name	"Verbrauch"
224	
COUNT(t_device_feature_state.id)	"35"
device_feature_id	"5366a343-5cce-4f2f-ae77-06bfd11db50f"
feature_name	"Füllstand"
device_name	"Poolpumpen-Tools"
225	
COUNT(t_device_feature_state.id)	"28"
device_feature_id	"f2f59900-df9f-415a-b4e0-dd92deca7260"
feature_name	"Tastendruck"
device_name	"Garagen-Einzelknopf"
226	
COUNT(t_device_feature_state.id)	"9"
device_feature_id	"f92149a1-5b7a-4c01-ad5f-bf29cc29f1aa"
feature_name	"ÜBERWACHUNG - Zustand"
device_name	"ÜBERWACHUNG"
227	
COUNT(t_device_feature_state.id)	"8"
device_feature_id	"6c7cd64f-d620-4128-a69b-9f774294e3be"
feature_name	"Einbruch (Zustand) "
device_name	"Einbruch"
228	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"10e6207a-7756-49aa-81c5-9132cd5afd1a"
feature_name	"Signalstärke"
device_name	"Sophie-Nachtkästchenknopf"
229	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"1b011336-3fd3-4adf-bb6d-adbfd38e6a40"
feature_name	"Signalstärke"
device_name	"Garagen-Lichtsteckdose"
230	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"1e154dba-8167-4fe1-9b34-212ff7849484"
feature_name	"Verbrauchte Leistung"
device_name	"Garagen-Lichtsteckdose"
231	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"3533b52f-2641-447f-95e2-adc18119810c"
feature_name	"Signalstärke"
device_name	"Badezimmer-Leckage"
232	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"36b7b113-3d8c-4ff4-bc6d-b48ff66145cd"
feature_name	"Temperatur"
device_name	"Sophie-Nachtkästchenknopf"
233	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"4498cb4a-6504-4da7-80bb-314d27d06dcd"
feature_name	"Batterie"
device_name	"Sophie-Nachtkästchenknopf"
234	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"6327eddc-0b1c-4463-89d4-e7f182523ef1"
feature_name	"Zugangskontrollmodus"
device_name	"Garagen-Lichtsteckdose"
235	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"71656496-df24-466a-aaeb-e923b129ae6e"
feature_name	"Verbrauchte Energie"
device_name	"Garagen-Lichtsteckdose"
236	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"7478b88e-b406-4970-a24d-cf83ad23ef39"
feature_name	"Batterie"
device_name	"Badezimmer-Leckage"
237	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"78fff789-1c83-469c-8583-e51674642c8d"
feature_name	"Erzwungener Betrieb"
device_name	"Poolpumpen-Tools"
238	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"8e5d8cb8-f770-453f-9bbf-019d36df8bd9"
feature_name	"Durchschnittsspannung"
device_name	"Garagen-Lichtsteckdose"
239	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"b0a51dd3-ae5f-46ef-b99c-066945706a91"
feature_name	"Verbrauchte Stärke"
device_name	"Garagen-Lichtsteckdose"
240	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"bc653819-ae23-4e74-848c-9d4f86fd9396"
feature_name	"Temperatur"
device_name	"Badezimmer-Leckage"
241	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"c7248901-580c-416d-b189-376cc1bdc68f"
feature_name	"Durchschnittsspannung"
device_name	"Sophie-Nachtkästchenknopf"
242	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"e87e4c3f-44ed-445a-a7fd-fee4df06028c"
feature_name	"Schalter"
device_name	"Garagen-Lichtsteckdose"
243	
COUNT(t_device_feature_state.id)	"5"
device_feature_id	"fa383e7b-9749-41eb-83cf-af021c3c39ca"
feature_name	"Durchschnittsspannung"
device_name	"Badezimmer-Leckage"
244	
COUNT(t_device_feature_state.id)	"4"
device_feature_id	"7a1602d9-e033-426b-b5d3-11ec78ee6a27"
feature_name	"Rote Alarmanlage - Lautstärke"
device_name	"Rote Alarmanlage - Lautstärke"
245	
COUNT(t_device_feature_state.id)	"4"
device_feature_id	"9930f2eb-78d8-470a-ba1c-9fe573dd3095"
feature_name	"ÜBERWACHUNG - Umschalter"
device_name	"ÜBERWACHUNG"
246	
COUNT(t_device_feature_state.id)	"2"
device_feature_id	"2e968fd5-a318-4a63-9856-e9210da9bf8d"
feature_name	"Pumpe (STATUS)"
device_name	"Pumpenwerkzeuge"

Ich stelle fest, dass der Teil des Stromverbrauchs des Hauses (über Nodered mit der Solaredge-API verwendet) viele Daten sendet. Aber ich weiß nicht, ob das „zu viel“ ist oder nicht!

[pierre-gilles]

Vielen Dank, dass du die Anfrage ausgeführt hast!

Jetzt, wo wir die „redseligsten“ Geräte kennen, kannst du dir ansehen, wie häufig sie Daten an Gladys senden:

SELECT * FROM t_device_feature_state 
WHERE device_feature_id = 'ERSETZE_DURCH_EINE_ID'
ORDER BY created_at DESC
LIMIT 100

Das gibt dir die letzten 100 Zustände einer Funktion. Beginne mit der „redseligsten“ Funktion (237016de-746c-4ba5-9e75-7dd7f801a391) und arbeite dich dann schrittweise nach oben.

Für jede davon geht es darum, herauszufinden, in welchem Intervall Gladys Daten erhält, und zu prüfen, ob einige nicht zu „redselig“ sind.

[guim31]

Hier ist das Ergebnis der Abfrage, die du mir gegeben hast:

	
0	
id	"da386e55-4d6d-4818-8e4d-8bccbeb06217"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:12:00.359 +00:00"
updated_at	"2024-07-18 19:12:00.359 +00:00"
1	
id	"7291c4c1-ae30-4afc-bbd4-8f3e66ff5d50"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:58.906 +00:00"
updated_at	"2024-07-18 19:11:58.906 +00:00"
2	
id	"0c45c908-5c50-498d-bd42-353dbefc01f8"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:58.889 +00:00"
updated_at	"2024-07-18 19:11:58.889 +00:00"
3	
id	"94a831a5-043a-4158-8778-aea7073a2b6b"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:55.967 +00:00"
updated_at	"2024-07-18 19:11:55.967 +00:00"
4	
id	"76ee29f3-f832-44b0-8390-e779f07cfb75"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:53.555 +00:00"
updated_at	"2024-07-18 19:11:53.555 +00:00"
5	
id	"b7eeec37-2a13-42da-bf45-8edbe0277a11"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:53.539 +00:00"
updated_at	"2024-07-18 19:11:53.539 +00:00"
6	
id	"0631bc75-fad1-4713-a10c-922684d1e8f2"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:48.177 +00:00"
updated_at	"2024-07-18 19:11:48.177 +00:00"
7	
id	"60a312e4-53e4-4646-88e7-c051a5fac9aa"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:48.163 +00:00"
updated_at	"2024-07-18 19:11:48.163 +00:00"
8	
id	"ae24f6cf-8c27-40a2-a345-43a0ce40ce0b"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:42.831 +00:00"
updated_at	"2024-07-18 19:11:42.831 +00:00"
9	
id	"5fea2f51-e451-4fbd-b4a2-fde3a150234d"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:42.817 +00:00"
updated_at	"2024-07-18 19:11:42.817 +00:00"
10	
id	"692f397e-f9a3-4c55-851b-04420dae15b8"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:37.442 +00:00"
updated_at	"2024-07-18 19:11:37.442 +00:00"
11	
id	"ad6cefa4-7d14-4bcd-a161-c9129eeb7773"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:37.426 +00:00"
updated_at	"2024-07-18 19:11:37.426 +00:00"
12	
id	"8b87f330-16c9-4357-ad41-4c79e624ee8f"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:32.090 +00:00"
updated_at	"2024-07-18 19:11:32.090 +00:00"
13	
id	"6beadd39-e122-459f-ae3a-68441d462029"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:32.075 +00:00"
updated_at	"2024-07-18 19:11:32.075 +00:00"
14	
id	"34e53295-c05d-44f0-847c-a490ac94150c"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:29.660 +00:00"
updated_at	"2024-07-18 19:11:29.660 +00:00"
15	
id	"32d12777-375f-4a43-93b8-9cc0b95676d3"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:26.720 +00:00"
updated_at	"2024-07-18 19:11:26.720 +00:00"
16	
id	"e77a9673-dba7-435f-bde2-7fc1f2d8c821"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:26.704 +00:00"
updated_at	"2024-07-18 19:11:26.704 +00:00"
17	
id	"b9ac1c95-b075-4309-9dcc-a7504d4e7568"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:21.369 +00:00"
updated_at	"2024-07-18 19:11:21.369 +00:00"
18	
id	"1bccbd7e-4221-4daa-8cd0-2a1ecd3e87c0"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:21.350 +00:00"
updated_at	"2024-07-18 19:11:21.350 +00:00"
19	
id	"f687f2ca-440e-4fdf-9005-2da32ee7133e"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:16.012 +00:00"
updated_at	"2024-07-18 19:11:16.012 +00:00"
20	
id	"265ac03f-6409-45a3-a451-0aa197efe7bc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:15.983 +00:00"
updated_at	"2024-07-18 19:11:15.983 +00:00"
21	
id	"dc5d1e07-75f7-4ca0-8732-e12e9b65f644"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:12.033 +00:00"
updated_at	"2024-07-18 19:11:12.033 +00:00"
22	
id	"4294cc52-7af3-4723-9313-aa15d03ada26"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:10.648 +00:00"
updated_at	"2024-07-18 19:11:10.648 +00:00"
23	
id	"d271beb8-1443-4932-8c99-cfd5580ca422"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:10.630 +00:00"
updated_at	"2024-07-18 19:11:10.630 +00:00"
24	
id	"d68c4c0e-eecb-4feb-9da2-6473f1c95af8"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:05.288 +00:00"
updated_at	"2024-07-18 19:11:05.288 +00:00"
25	
id	"20d15b93-aeac-4aea-a418-8284bfc6a08d"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:05.268 +00:00"
updated_at	"2024-07-18 19:11:05.268 +00:00"
26	
id	"1d9483f2-79d9-4de3-b27e-3bf8db281518"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:11:03.342 +00:00"
updated_at	"2024-07-18 19:11:03.342 +00:00"
27	
id	"9747f8df-2bae-4a54-a7f8-f6124e360bc5"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:59.974 +00:00"
updated_at	"2024-07-18 19:10:59.974 +00:00"
28	
id	"1b7afd68-5f06-445b-947f-2e35568b7f72"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:59.956 +00:00"
updated_at	"2024-07-18 19:10:59.956 +00:00"
29	
id	"0bc8a2a0-995d-4f77-bc0f-14153f9dd58e"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:54.572 +00:00"
updated_at	"2024-07-18 19:10:54.572 +00:00"
30	
id	"2228c1ed-f22c-4f64-ac4e-79fc22e1817c"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:54.554 +00:00"
updated_at	"2024-07-18 19:10:54.554 +00:00"
31	
id	"a1ccd984-e1b1-45d9-b834-c03dfce55861"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:49.207 +00:00"
updated_at	"2024-07-18 19:10:49.207 +00:00"
32	
id	"656a34ce-708b-46a5-8133-9bdeaa99cd2a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:49.189 +00:00"
updated_at	"2024-07-18 19:10:49.189 +00:00"
33	
id	"8d2b9891-4178-40a5-a4d3-7b4ba0feccd6"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:45.800 +00:00"
updated_at	"2024-07-18 19:10:45.800 +00:00"
34	
id	"959403e6-1779-41e7-b91a-15d9fdbad176"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:43.848 +00:00"
updated_at	"2024-07-18 19:10:43.848 +00:00"
35	
id	"c12cd9f2-6adb-4d2c-92fa-f7e7d5b31f33"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:43.829 +00:00"
updated_at	"2024-07-18 19:10:43.829 +00:00"
36	
id	"b119a70b-cf4f-43b4-9303-c746f8d7d252"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:38.484 +00:00"
updated_at	"2024-07-18 19:10:38.484 +00:00"
37	
id	"18e3e71e-c7f1-4010-ba64-ef57d169d3cf"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:38.465 +00:00"
updated_at	"2024-07-18 19:10:38.465 +00:00"
38	
id	"4b9d8457-b7c5-46f4-af99-844b6edfe72f"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:33.120 +00:00"
updated_at	"2024-07-18 19:10:33.120 +00:00"
39	
id	"5b7b7094-6541-450f-a95a-dc1c61da668a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:10:33.104 +00:00"
updated_at	"2024-07-18 19:10:33.104 +00:00"
40	
id	"c4e1ac1b-522c-40f2-a16c-e63aa3e2ebdc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:27.766 +00:00"
bearbeitet_am	"2024-07-18 19:10:27.766 +00:00"
41	
id	"30220cd9-61ff-47eb-9930-fd2cb53d2074"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:27.749 +00:00"
bearbeitet_am	"2024-07-18 19:10:27.749 +00:00"
42	
id	"83abc19f-9ffb-4b7b-904d-634a63228ef2"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:25.695 +00:00"
bearbeitet_am	"2024-07-18 19:10:25.695 +00:00"
43	
id	"adb25582-c5f0-4d28-bef5-9b7e341bb1fc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:22.399 +00:00"
bearbeitet_am	"2024-07-18 19:10:22.399 +00:00"
44	
id	"eaeccac5-8fdd-40eb-b1d9-172e655a0895"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:22.388 +00:00"
bearbeitet_am	"2024-07-18 19:10:22.388 +00:00"
45	
id	"3e9e5ccd-926c-4cb8-9514-a81d25517268"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:17.053 +00:00"
bearbeitet_am	"2024-07-18 19:10:17.053 +00:00"
46	
id	"0b700a26-e785-4270-8829-8c2025a88c8f"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:17.038 +00:00"
bearbeitet_am	"2024-07-18 19:10:17.038 +00:00"
47	
id	"1ba9511a-fc1a-4141-8ccf-8c42943b8e04"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:11.706 +00:00"
bearbeitet_am	"2024-07-18 19:10:11.706 +00:00"
48	
id	"1a5c8174-e40d-4bba-a61b-a8016457e4fd"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:11.687 +00:00"
bearbeitet_am	"2024-07-18 19:10:11.687 +00:00"
49	
id	"399f83d3-6cb9-41ff-94d9-d80a08a636fe"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:06.335 +00:00"
bearbeitet_am	"2024-07-18 19:10:06.335 +00:00"
50	
id	"0a687a87-f2c2-4d7b-a7ac-68d4667aaf68"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:06.316 +00:00"
bearbeitet_am	"2024-07-18 19:10:06.316 +00:00"
51	
id	"55ed3d67-b045-4990-856c-3bfe25b81703"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:01.946 +00:00"
bearbeitet_am	"2024-07-18 19:10:01.946 +00:00"
52	
id	"49ce059d-bc34-4b5e-8e2e-b928dbb166e2"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:00.972 +00:00"
bearbeitet_am	"2024-07-18 19:10:00.972 +00:00"
53	
id	"5d3559c5-bc96-43f7-ab8b-c4b36acea46c"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:10:00.951 +00:00"
bearbeitet_am	"2024-07-18 19:10:00.951 +00:00"
54	
id	"1a5703ce-8ee1-42ba-bbb1-be3321e0d6ee"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:57.563 +00:00"
bearbeitet_am	"2024-07-18 19:09:57.563 +00:00"
55	
id	"16c9ed02-ff36-4c73-868d-5c206e02b1f6"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:55.605 +00:00"
bearbeitet_am	"2024-07-18 19:09:55.605 +00:00"
56	
id	"7f8ed872-9e21-4a9e-816b-312e64b617dc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:55.589 +00:00"
bearbeitet_am	"2024-07-18 19:09:55.589 +00:00"
57	
id	"22c62170-87f8-4cd0-8968-208ca51b4e22"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:50.245 +00:00"
bearbeitet_am	"2024-07-18 19:09:50.245 +00:00"
58	
id	"def0c52c-c6d6-465f-9ceb-e7d25b9e5acd"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:50.232 +00:00"
bearbeitet_am	"2024-07-18 19:09:50.232 +00:00"
59	
id	"2edcb314-c2f7-486c-a95a-3cd58ee86cf2"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:44.886 +00:00"
bearbeitet_am	"2024-07-18 19:09:44.886 +00:00"
60	
id	"e8ebacfb-932f-497d-8f6b-196b6aef6463"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:44.869 +00:00"
bearbeitet_am	"2024-07-18 19:09:44.869 +00:00"
61	
id	"d7f6947c-b728-4980-a76b-792e35cfbb70"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:39.549 +00:00"
bearbeitet_am	"2024-07-18 19:09:39.549 +00:00"
62	
id	"04fec33b-b306-4916-9d3b-2e2f45f7982d"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:39.528 +00:00"
bearbeitet_am	"2024-07-18 19:09:39.528 +00:00"
63	
id	"caef7087-96bc-42f3-8c2d-c471c0d0cda9"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:34.178 +00:00"
bearbeitet_am	"2024-07-18 19:09:34.178 +00:00"
64	
id	"9e2a5200-823b-4109-b4fd-a637f64d741a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:34.160 +00:00"
bearbeitet_am	"2024-07-18 19:09:34.160 +00:00"
65	
id	"f1ae32fd-652f-4c20-9b21-a47fb620b412"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:28.838 +00:00"
bearbeitet_am	"2024-07-18 19:09:28.838 +00:00"
66	
id	"ed81bdad-eaaf-43f4-8bb0-9e959ce731ff"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:28.815 +00:00"
bearbeitet_am	"2024-07-18 19:09:28.815 +00:00"
67	
id	"fd89c9b0-105c-44ce-8f2b-d273b10ada92"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:23.509 +00:00"
bearbeitet_am	"2024-07-18 19:09:23.509 +00:00"
68	
id	"80d74355-5b78-42f2-bf37-5df8519c72f5"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:23.493 +00:00"
bearbeitet_am	"2024-07-18 19:09:23.493 +00:00"
69	
id	"e1297fbf-2426-4c6a-9d9d-300712d6a652"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:18.152 +00:00"
bearbeitet_am	"2024-07-18 19:09:18.152 +00:00"
70	
id	"dee6031c-212e-4a9b-9a9a-db9ad44b8a31"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:18.135 +00:00"
bearbeitet_am	"2024-07-18 19:09:18.135 +00:00"
71	
id	"da4406d4-8183-4cba-af5b-ba754268ebcc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:12.765 +00:00"
bearbeitet_am	"2024-07-18 19:09:12.765 +00:00"
72	
id	"2e1a51da-32ba-4083-97ed-741b4753497b"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:12.746 +00:00"
bearbeitet_am	"2024-07-18 19:09:12.746 +00:00"
73	
id	"72dbf546-3caf-4fdf-85c3-b1007d3606a7"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:07.399 +00:00"
bearbeitet_am	"2024-07-18 19:09:07.399 +00:00"
74	
id	"57366838-e65c-4135-b4c1-ddcc0cf90f98"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:07.378 +00:00"
bearbeitet_am	"2024-07-18 19:09:07.378 +00:00"
75	
id	"94e4d31b-4d86-45cd-9fcd-219b9555c551"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:02.046 +00:00"
bearbeitet_am	"2024-07-18 19:09:02.046 +00:00"
76	
id	"9c1c510b-0d9e-42be-a379-debf2e5b3231"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:09:02.023 +00:00"
bearbeitet_am	"2024-07-18 19:09:02.023 +00:00"
77	
id	"048f6881-460a-478e-bf79-3729996786c9"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:08:56.666 +00:00"
bearbeitet_am	"2024-07-18 19:08:56.666 +00:00"
78	
id	"ed49a861-0712-4071-8685-505a5ff99655"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:08:56.648 +00:00"
bearbeitet_am	"2024-07-18 19:08:56.648 +00:00"
79	
id	"c4e3d331-f489-4414-9c77-ff66f98e0fa1"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
erstellt_am	"2024-07-18 19:08:51.797 +00:00"
bearbeitet_am	"2024-07-18 19:08:51.797 +00:00"
80	
id	"b4373039-70ed-4620-853e-485a443ac40a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
wert	"0.0"
created_at	"2024-07-18 19:08:51.307 +00:00"
updated_at	"2024-07-18 19:08:51.307 +00:00"
81	
id	"4c91b322-8f9d-4bff-89c0-0a093be85ab5"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:51.288 +00:00"
updated_at	"2024-07-18 19:08:51.288 +00:00"
82	
id	"dcde1a47-4aa5-4817-854f-f8af708233ba"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:45.948 +00:00"
updated_at	"2024-07-18 19:08:45.948 +00:00"
83	
id	"86fed140-de68-442b-b977-82c2086bae21"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:45.930 +00:00"
updated_at	"2024-07-18 19:08:45.930 +00:00"
84	
id	"0daa32ef-45c9-4332-a022-b5f2575878b4"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:40.597 +00:00"
updated_at	"2024-07-18 19:08:40.597 +00:00"
85	
id	"cd99bc3d-2998-493b-a0d0-fd20eb4cbdd3"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:40.575 +00:00"
updated_at	"2024-07-18 19:08:40.575 +00:00"
86	
id	"1b327df5-49b6-4296-95f2-1018adc8ce4c"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:35.245 +00:00"
updated_at	"2024-07-18 19:08:35.245 +00:00"
87	
id	"8203ea55-a7c7-458f-bda0-39d0411d3824"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:35.225 +00:00"
updated_at	"2024-07-18 19:08:35.225 +00:00"
88	
id	"c0ba2904-5520-46a8-a8be-d75cfea45bd0"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:34.257 +00:00"
updated_at	"2024-07-18 19:08:34.257 +00:00"
89	
id	"b0d73f06-1b13-4040-a4fb-193c293da917"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:29.861 +00:00"
updated_at	"2024-07-18 19:08:29.861 +00:00"
90	
id	"065f09e6-4ae6-4f2c-ac16-dd0b44ba0508"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:29.848 +00:00"
updated_at	"2024-07-18 19:08:29.848 +00:00"
91	
id	"f89af62b-47cf-49b6-a99b-dd61a49046fc"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:24.509 +00:00"
updated_at	"2024-07-18 19:08:24.509 +00:00"
92	
id	"e1fd25c3-f62f-4568-89c6-4abe7219d7ed"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:24.493 +00:00"
updated_at	"2024-07-18 19:08:24.493 +00:00"
93	
id	"9466938c-dce4-4833-ab73-43fa6994793a"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:19.161 +00:00"
updated_at	"2024-07-18 19:08:19.161 +00:00"
94	
id	"f0255cb4-bc12-459f-bed5-5a94ee6887b7"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:19.140 +00:00"
updated_at	"2024-07-18 19:08:19.140 +00:00"
95	
id	"f6e7bb1f-a1c4-4f0c-a99c-54261a13a132"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:13.837 +00:00"
updated_at	"2024-07-18 19:08:13.837 +00:00"
96	
id	"854c7833-e5fc-4ea8-8c61-955aba8a5517"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:13.822 +00:00"
updated_at	"2024-07-18 19:08:13.822 +00:00"
97	
id	"d82ff859-e31b-4fa0-b039-c317f039b6e9"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:08.437 +00:00"
updated_at	"2024-07-18 19:08:08.437 +00:00"
98	
id	"0cabefb7-1795-4b0c-be72-8859432468e1"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:08.420 +00:00"
updated_at	"2024-07-18 19:08:08.420 +00:00"
99	
id	"4b6a0bb6-d933-4c37-a64e-006f29de5044"
device_feature_id	"237016de-746c-4ba5-9e75-7dd7f801a391"
value	"0.0"
created_at	"2024-07-18 19:08:03.097 +00:00"
updated_at	"2024-07-18 19:08:03.097 +00:00"

Man sieht deutlich, dass es sich um ULTRA nahe beieinander liegende Aufrufe handelt (zwischen 10 ms und 1000 ms), insbesondere da die Anfrage nur ein einziges Gerät betrachtet hat.

Ich sollte also wahrscheinlich einen Weg finden, diese Daten im Zeitverlauf etwas zu strecken. Vielleicht eine interessante Spur!