Hello, It would be nice if there´s a button under Configuration -> Database scripts, which simply truncates the tblNtlogMessage and tblNtlog tables if it gets to big, so i don´t have to search everytime for the sql code.
If you are using a recent Lansweeper release, you should be able to truncate event log data using the DatabaseMaintenance tool found in Program Files (x86)\Lansweeper\Service on your Lansweeper server. This should work for SQL Compact as well as SQL Server.