NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: Clearing old DCI data and freeing up space?  (Read 243 times)


  • Newbie
  • *
  • Posts: 28
    • View Profile
Clearing old DCI data and freeing up space?
« 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?

Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6655
    • View Profile
Re: Clearing old DCI data and freeing up space?
« Reply #1 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,