Layton ServiceDesk - Troubleshooting - Incoming Email Overload
From Layton Support
(Difference between revisions)
m (Jpainter moved page Layton ServiceDesk™ - General Troubleshooting - Incoming Email Overload to Layton ServiceDesk - General Troubleshooting - Incoming Email Overload: Removed the TM symbol for a cleaner URL) |
m (Updated links) |
||
Line 1: | Line 1: | ||
− | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
=Bulk Delete= | =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: | 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: | ||
Line 11: | Line 11: | ||
WHERE sys_mail_subject LIKE '%Alert%' | WHERE sys_mail_subject LIKE '%Alert%' | ||
− | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
Revision as of 06:07, 27 July 2016
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%'