Issue with mails in sql quarantine

[Dino Edwards]

Try the following query:

SELECT msgrcpt.mail_id, msgrcpt.ds, msgs.sid, msgs.spam_level, msgs.mail_id, msgs.secret_id, msgs.time_iso, msgs.subject, msgs.from_addr, msgs.content, msgs.client_addr FROM msgs INNER
JOIN msgrcpt ON msgs.mail_id = msgrcpt.mail_id where msgs.time_iso between '2021-05-01 12:00:00' and '2021-05-01 23:00:00' and msgs.content like binary 'S' order by msgs.time_iso desc

Here are the quarantined msgs.content types:

V = Virus
B = Banned
S = Quarantined Spam
M = Bad-Mime
H = Bad-Header
O = Oversized

Hope this helps.

Many more queries can be found here:

https://github.com/deeztek/Hermes-Secure-Email-Gateway/blob/master/dirstructure/var/www/html/admin/message_history_new.cfm






From: amavis-users <amavis-users-bounces+dino.edwards=mydirectmail.net at amavis.org> On Behalf Of Benedict White
Sent: Sunday, June 13, 2021 7:26 PM
To: amavis-users at amavis.org
Subject: Issue with mails in sql quarantine

I had an issue for two days over a weekend where most emails got quarantined.

Does anyone have an sql statement to list quarantined emails by user please?

Kind Regards,

Benedict White

Our business grows by referrals. If you know someone who would benefit from our help, please pass on our details.

[cid:image001.jpg at 01D12C21.CE196A10]<http://www.cse-ltd.co.uk/?utm_source=EmailSig&utm_medium=None&utm_campaign=CSE_TechSupp>

Tel:

01444 238070

Tech:

01444 238080

Fax:

01444 238099

Web:

www.cse-ltd.co.uk<http://www.cse-ltd.co.uk/?utm_source=EmailSig&utm_medium=None&utm_campaign=CSE_TechSupp>

Registered in England and Wales No: 8666450
Unit D, Consort Way, Burgess Hill, West Sussex,
RH15 9TJ

[cid:image002.png at 01D760DF.38A54E10]

  [cid:image004.png at 01D12C21.CE196A10] <http://www.facebook.com/?ref=tn_tnmn#!/pages/CSE/173531926406>      [cid:image005.png at 01D12C21.CE196A10] <http://www.google.com/+CseltdUk_ITSupport>      [cid:image006.png at 01D12C21.CE196A10] <https://twitter.com/cseltd>      [cid:image007.jpg at 01D12C21.CE196A10] <http://www.linkedin.com/company/computer-systems-engineering-ltd>

[Description: Q:\marketing\Logos\NewCo\ActionPress\Help.jpg]<http://www.cse-ltd.co.uk/Help?utm_source=EmailSig&utm_medium=TechHelp&utm_campaign=CSE_TechSupp>









Legal Disclaimer: This message and any attachment may be confidential and privileged. If you are not the intended recipient please notify the sender and delete this e-mail and any attachment from your system. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. All information given in this e-mail is provided in good faith but not binding for legal reasons.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20210614/46ff6195/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4468 bytes
Desc: image001.jpg
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20210614/46ff6195/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.png
Type: image/png
Size: 2875 bytes
Desc: image009.png
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20210614/46ff6195/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image010.png
Type: image/png
Size: 1817 bytes
Desc: image010.png
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20210614/46ff6195/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image011.png
Type: image/png
Size: 2661 bytes
Desc: image011.png
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20210614/46ff6195/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image012.jpg
Type: image/jpeg
Size: 1155 bytes
Desc: image012.jpg
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20210614/46ff6195/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image013.jpg
Type: image/jpeg
Size: 2953 bytes
Desc: image013.jpg
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20210614/46ff6195/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 200 bytes
Desc: image002.png
URL: <https://lists.amavis.org/pipermail/amavis-users/attachments/20210614/46ff6195/attachment-0003.png>