Delete all historical sensor data (while keeping sensors) Topic is solved

Topics (not sure which fora)
when not sure where to post, post here and mods will move it to right forum.

Moderators: leecollings, remb0

Post Reply
Lomax
Posts: 32
Joined: Monday 18 May 2015 17:12
Target OS: Raspberry Pi / ODroid
Domoticz version:
Location: United Kingdom
Contact:

Delete all historical sensor data (while keeping sensors)

Post by Lomax »

I've been messing around a lot with a Domoticz build the last few days, and I've now come to a point where I'm quite happy with how it works. The only problem is that many of the sensors have completely invalid historical data, including wildly incorrect values, and I would like to "wipe the slate" clean and restart the log. Is there an easy way to do this, without deleting (and recreating) all the sensors?
CaesarPL
Posts: 104
Joined: Tuesday 08 November 2016 14:03
Target OS: Raspberry Pi / ODroid
Domoticz version:
Location: Poland
Contact:

Re: Delete all historical sensor data (while keeping sensors)

Post by CaesarPL »

You can open database and delete not necessary data
HW:Raspberry PiB+,Pi3,PiB,RFLink,FA20RF,DCS-930L,DCS-935L,Clarus switches,RF Temp sensors,Owl Micro+,Mi Flora,Kerui,Yeelight,Xiaomi,Broadlink RMM3,Alexa
SF:Jessie,Dmtcz 3.8153,Logitech Media srv,PiCorePlayers,Dashticz,Max2Play,InfluxDB,Grafana,HABridge
Lomax
Posts: 32
Joined: Monday 18 May 2015 17:12
Target OS: Raspberry Pi / ODroid
Domoticz version:
Location: United Kingdom
Contact:

Re: Delete all historical sensor data (while keeping sensors)

Post by Lomax »

Allrighty, I'll have a poke around with sqlite3 - after stopping Domoticz, and making a backup copy...
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest