This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.

Event log creation and presentation
#9
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
Code:
old = 30 -- days
timestamp = os.time() - (old * 86400)
db:query('delete from alerts where alerttime < ?', timestamp)
BR,

Erwin
Reply


Messages In This Thread
RE: Event log creation and presentation - by Erwin van der Zwart - 27.01.2020, 19:00

Forum Jump: