Layton ServiceDesk - Troubleshooting - Incoming Email Overload
From Layton Support
(Difference between revisions)
(New page) |
m (Minor text changes) |
||
(6 intermediate revisions by one user not shown) | |||
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 | + | 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] | + | 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: | 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] | + | DELETE FROM [LaytonServiceDesk].[dbo].[mailin] |
− | 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 | + | This will take considerably longer to execute. |
+ | <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> |
Latest revision as of 00:03, 24 August 2022
[edit] 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.