Possibility to cleanup/purge connection Log Table?

Here is an example of a script that will delete all log entries older than 18 months.

Note: The script, as written bellow, won't actually delete the rows (it roles back the transaction). You will need to comment/delete the "rollback tran" line and un-comment the "commit tran" line. Why? I have a policy to never give out scripts that delete/modify data without a rollback.

Chagne the @xMonth value to the number of months you would like to keep in the logs.

begin tran

declare @xMonths int;
set @xMonths = 18;
delete from [dbo].[ConnectionLog] where creationdate < dateadd(MONTH, - @xMonths, getdate())

rollback tran
-- commit tran
Note 2: We have an enhancement to allow this to be done via the UI but it has yet to be implemented.

Regards,

Thanks a lot!

Hi,
Adding something in the UI is definitively on our todo list