NetXMS Support Forum

English Support => General Support => Topic started by: Millenium7 on January 17, 2019, 03:49:47 AM

Title: Clearing old DCI data and freeing up space?
Post by: Millenium7 on January 17, 2019, 03:49:47 AM
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?
Title: Re: Clearing old DCI data and freeing up space?
Post by: Victor Kirhenshtein on January 29, 2019, 04:53:28 PM
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