Revision as of 06:06, 27 July 2016

Back to Contents

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%'

Back to Contents