Avensoft Help Desk - Error deleting old logs and old emails

Error deleting old logs and old emails

The timeout period elapsed prior to completion of the operation or the server is not responding

This is usually caused by having too many old logs and emails. You can delete them by running these two SQL statements in SQL Server Management Studio against your nService4 database.

-- delete logs from before January 1, 2024
DELETE ns4_event_log WHERE el_created_on < '20240101'

-- delete sent, deleted, and bad emails older than January 1, 2024
DELETE ns4_email WHERE (em_folder = 3 OR em_folder = 5 OR em_folder = 7) AND em_created_on < '20240101'