27.01.2020, 19:00
(This post was last modified: 27.01.2020, 20:12 by Erwin van der Zwart.)
Hi,
You can only delete them all by the delete button or use the alert manager to delete them by line.
Another option is to reduce the alert log size (default 200) so FIFO will take care of it.
Last option is a SQL query to drop them from the DB, in this case you can make a query to drop entry’s older then x period.
Run this as scheduled script once a day / week
BR,
Erwin
You can only delete them all by the delete button or use the alert manager to delete them by line.
Another option is to reduce the alert log size (default 200) so FIFO will take care of it.
Last option is a SQL query to drop them from the DB, in this case you can make a query to drop entry’s older then x period.
Run this as scheduled script once a day / week
Code:
old = 30 -- days
timestamp = os.time() - (old * 86400)
db:query('delete from alerts where alerttime < ?', timestamp)
Erwin