pi@solaranzeige:~ $ influx -host localhost -port 8086 -database wallbox -precision rfc3339 -execute "select * from Service order by time desc limit 5" name: Service time AnzPhasen EnableSys EnableUser ErrorCode1 ErrorCode2 Ladekabel MaxAmpere MaxAmpereHardware MaxAmpereUser Stationsstatus ---- --------- --------- ---------- ---------- ---------- --------- --------- ----------------- ------------- -------------- 2021-05-27T19:12:11Z 0 0 1 0 0 3 0 25 63 1 2021-05-27T19:11:11Z 0 0 1 0 0 3 0 25 63 1 2021-05-27T19:10:12Z 0 0 1 0 0 3 0 25 63 1 2021-05-27T19:09:11Z 0 0 1 0 0 3 0 25 63 1 2021-05-27T19:08:11Z 0 0 1 0 0 3 0 25 63 1 pi@solaranzeige:~ $ influx -host localhost -port 8086 -database wallbox -precision rfc3339 -execute "select * from AC order by time desc limit 5" name: AC time Leistung_gesamt Leistungsfaktor Spannung_R Spannung_S Spannung_T Strom_R Strom_S Strom_T ---- --------------- --------------- ---------- ---------- ---------- ------- ------- ------- 2021-05-27T19:16:11Z 0 0 0 0 0 0 0 0 2021-05-27T19:15:12Z 0 0 0 0 0 0 0 0 2021-05-27T19:14:11Z 0 0 0 0 0 0 0 0 2021-05-27T19:13:11Z 0 0 0 0 0 0 0 0 2021-05-27T19:12:11Z 0 0 0 0 0 0 0 0 pi@solaranzeige:~ $ influx -host localhost -port 8086 -database wallbox -precision rfc3339 -execute "select * from Info order by time desc limit 5" name: Info time Datum Firmware Objekt Produkt ---- ----- -------- ------ ------- 2021-05-27T19:01:11Z 27.05.2021 P30 v 3.10.16 (200708-201734) Keba KC-P30-EC240122-L0R 2021-05-27T18:01:11Z 27.05.2021 P30 v 3.10.16 (200708-201734) Keba KC-P30-EC240122-L0R 2021-05-27T17:01:11Z 27.05.2021 P30 v 3.10.16 (200708-201734) Keba KC-P30-EC240122-L0R 2021-05-27T16:01:12Z 27.05.2021 P30 v 3.10.16 (200708-201734) Keba KC-P30-EC240122-L0R 2021-05-27T15:01:11Z 27.05.2021 P30 v 3.10.16 (200708-201734) Keba KC-P30-EC240122-L0R pi@solaranzeige:~ $ influx -host localhost -port 8086 -database wallbox -precision rfc3339 -execute "select * from Summen order by time desc limit 5" name: Summen time Wh_Gesamt Wh_Ladevorgang ---- --------- -------------- 2021-05-27T19:17:11Z 515652.5 20419 2021-05-27T19:16:11Z 515652.5 20419 2021-05-27T19:15:12Z 515652.5 20419 2021-05-27T19:14:11Z 515652.5 20419 2021-05-27T19:13:11Z 515652.5 20419 pi@solaranzeige:~ $ influx -host localhost -port 8086 -database wallbox -precision rfc3339 -execute "select * from Statistik order by time desc limit 5" name: Statistik time Bezeichnung Datum DieseWoche_TS DieserMonat_TS DiesesJahr_TS Gestern_TS Heute_TS Jahr LetzteWoche_TS LetzterMonat_TS LetztesJahr_TS Monat Stunde TagImJahr TagImMonat Wert Woche Wochentag ---- ----------- ----- ------------- -------------- ------------- ---------- -------- ---- -------------- --------------- -------------- ----- ------ --------- ---------- ---- ----- --------- 2021-05-27T19:10:12Z WhTag 27.05.2021 1621807200000000000 1619820000000000000 1609455600000000000 1621980000000000000 1622066400000000000 2021 1621202400000000000 1617228000000000000 1577833200000000000 5 21 147 27 20419.1 21 Donnerstag 2021-05-27T19:00:22Z WhTag 27.05.2021 1621807200000000000 1619820000000000000 1609455600000000000 1621980000000000000 1622066400000000000 2021 1621202400000000000 1617228000000000000 1577833200000000000 5 21 147 27 20419.1 21 Donnerstag 2021-05-27T18:50:11Z WhTag 27.05.2021 1621807200000000000 1619820000000000000 1609455600000000000 1621980000000000000 1622066400000000000 2021 1621202400000000000 1617228000000000000 1577833200000000000 5 20 147 27 20419.1 21 Donnerstag 2021-05-27T18:40:11Z WhTag 27.05.2021 1621807200000000000 1619820000000000000 1609455600000000000 1621980000000000000 1622066400000000000 2021 1621202400000000000 1617228000000000000 1577833200000000000 5 20 147 27 20419.1 21 Donnerstag 2021-05-27T18:30:11Z WhTag 27.05.2021 1621807200000000000 1619820000000000000 1609455600000000000 1621980000000000000 1622066400000000000 2021 1621202400000000000 1617228000000000000 1577833200000000000 5 20 147 27 20419.1 21 Donnerstag pi@solaranzeige:~ $