Layton ServiceDesk - Troubleshooting - Incoming Email Overload

From Layton Support
Revision as of 00:03, 24 August 2022 by Jpainter (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Btn back up.png Back to Contents

Bulk Delete

If you have an overload of incoming emails (e.g. a mail server suddenly sent Layton ServiceDesk a torrent of mail), you can quickly eliminate all email with this SQL query, executed in Microsoft SQL Server Management Studio:

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

This will take considerably longer to execute.

Btn back up.png Back to Contents

Personal tools

Main Page
Online User Guides
General Support
Release Notes