Jahresrückblick 2025 – unser neuer Blogbeitrag ist online! ✨

[liv-in-sky]

@stenmic ok

habe die abfrage ob dauer ist 0 nochmal geändert im script

bis morgen

[stenmic]

@liv-in-sky danke... der Datenpunkt passt!

Über ein blockly kann ich so die bash schreiben.

(kann man wahrscheinlich noch in dein Skript integrieren)

Ergebnis:

#!/bin/bash
influx -execute 'delete from "Heizung.Badezimmer.Ventil" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Schlafzimmer.Ventil" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Kueche.Ventil" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Wohnzimmer.Ventil" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Buero.Ventil" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Flur.Ventil" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Esszimmer.Ventil" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Atelier.Ventil" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.Trockner.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.Geschirrspueler.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.Waschmaschine.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.TV.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Esszimmer.Temperatur.Soll" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.Server.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.TanjaPC.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.Luftbefeuchter.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.Kuehlschrank.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.Gefrierschrank.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.Rauchabzug.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Plugs.MichaPC.Power" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Luftdruck.Aussen" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Luftdruck.Aussen_max" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Luftdruck.Aussen_min" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Außen.MAX" where time < '\'`date +%Y-%m-%d -d "730 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Außen.MIN" where time < '\'`date +%Y-%m-%d -d "730 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Außen.Tagesdurchschnitt" where time < '\'`date +%Y-%m-%d -d "730 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Außen.Tagesdurchschnitt2" where time < '\'`date +%Y-%m-%d -d "730 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Außen.Tagesdurchschnitt3" where time < '\'`date +%Y-%m-%d -d "730 day ago"`\' -database="iobroker"
influx -execute 'delete from "BMW_3er_Leasing.Tagesverbrauch.Liter_100km_History" where time < '\'`date +%Y-%m-%d -d "365 day ago"`\' -database="iobroker"
influx -execute 'delete from "Leasing.Tagesverbrauch.Test-Tankfuellung" where time < '\'`date +%Y-%m-%d -d "365 day ago"`\' -database="iobroker"
influx -execute 'delete from "Leasing.tanken.KM-APP" where time < '\'`date +%Y-%m-%d -d "365 day ago"`\' -database="iobroker"
influx -execute 'delete from "Leasing.tanken.KM-Jahr-Leasing" where time < '\'`date +%Y-%m-%d -d "730 day ago"`\' -database="iobroker"
influx -execute 'delete from "Leasing.tanken.Liter-100KM-Gesamt" where time < '\'`date +%Y-%m-%d -d "730 day ago"`\' -database="iobroker"
influx -execute 'delete from "Leasing.tanken.Liter-100KM-Strecke" where time < '\'`date +%Y-%m-%d -d "730 day ago"`\' -database="iobroker"
influx -execute 'delete from "bmw.0.WBA6K31010FK63788.dynamic.remaining_fuel" where time < '\'`date +%Y-%m-%d -d "92 day ago"`\' -database="iobroker"
influx -execute 'delete from "Gasverbrauch.15min.Grenzwert" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Gasverbrauch.15min.Aktuell" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Gasverbrauch.Monat.Grenzwert" where time < '\'`date +%Y-%m-%d -d "365 day ago"`\' -database="iobroker"
influx -execute 'delete from "Gasverbrauch.Tag.Grenzwert" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Gasverbrauch.Tag.Aktuell" where time < '\'`date +%Y-%m-%d -d "365 day ago"`\' -database="iobroker"
influx -execute 'delete from "Sonne.Lux.Aktuell2" where time < '\'`date +%Y-%m-%d -d "365 day ago"`\' -database="iobroker"
influx -execute 'delete from "Sonne.Lux.Max" where time < '\'`date +%Y-%m-%d -d "365 day ago"`\' -database="iobroker"
influx -execute 'delete from "Sonne.Lux.Aktuell" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Luftdruck.Aussen_24h" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Kuehlschrank.24h" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "System.Master.Disk" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "System.Slave1.Disk" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "System.Slave1.RAM" where time < '\'`date +%Y-%m-%d -d "14 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Bad.Max" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Bad.Min" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Badezimmer.Temperatur.Soll" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Buegelzimmer.Max" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Buegelzimmer.Min" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Buegelzimmer.Temperatur.Soll" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Buero.Max" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Buero.Min" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Buero.Temperatur.Soll" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Dachboden.Max" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Dachboden.Min" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Flur.Max" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Flur.Min" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Flur.Temperatur.Soll" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Kueche.Max" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Temperaturen.Kueche.Min" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"
influx -execute 'delete from "Heizung.Kueche.Temperatur.Soll" where time < '\'`date +%Y-%m-%d -d "31 day ago"`\' -database="iobroker"

Danke dir!