Layton ServiceDesk - Troubleshooting - Incoming Email Overload
From Layton Support
(Difference between revisions)
(New page) |
Revision as of 01:32, 3 March 2015
Bulk Delete
If you have an overload of incoming emails (e.g. a mail server suddenly sends out a torrent of mail), you can quickly eliminate all email with this SQL query:
TRUNCATE TABLE [LaytonServiceDesk].[dbo].[mailin]
You can more selectively remove emails if there is a common element you can use, in this case, a string in the subject line:
DELETE FROM [LaytonServiceDesk].[dbo].[mailin] WHERE sys_mail_subject LIKE '%Alert%'