Layton ServiceDesk - Troubleshooting - Incoming Email Stops
From Layton Support
(Difference between revisions)
(New page) |
(Added Bulk Delete option) |
||
| Line 8: | Line 8: | ||
=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: | |
| + | |||
| + | 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%' | ||
| − | |||
<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> | <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 23:27, 28 August 2014
Contents |
Overview
If incoming email is not being processed, check the following:
- Ensure that your mail server is functioning correctly and that the mailbox is available.
- Ensure that your incoming mail settings are correct. Do a test to make sure.
- Ensure that Auto Import Settings are turned on.
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%'
