Clearing old DCI data and freeing up space?

Started by Millenium7, January 17, 2019, 03:49:47 AM

Previous topic - Next topic

Millenium7

I've done a google search, there are some really old topics but not sure if they apply

Essentially I just want to be able to clear old data. For instance I don't care about DCI data older than 30 days at the moment (current retention is set to 60 days)
Is there a way to delete all DCI data older than 30 days?

Same thing for Syslog. Can I delete all old data and/or filter it and delete all data matching certain terms?
I've turned on debugging for a few devices and they have added a lot of syslog entries, can I delete everything matching the term 'debug' for instance?

Victor Kirhenshtein

For DCI data it is simple - set retention to 30 days, wait for housekeeper run (or run it manually), and set retention back.

Syslog is a bit trickier - if you just need to delete all old records you can do the same retention time change. But if you want to delete older records by certain criteria, you have to do it directly in database.

Best regards,
Victor