<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"helvetica neue";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma",sans-serif;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1027" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Try the following query:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here are the quarantined msgs.content types:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">V = Virus<o:p></o:p></p>
<p class="MsoNormal">B = Banned<o:p></o:p></p>
<p class="MsoNormal">S = Quarantined Spam<o:p></o:p></p>
<p class="MsoNormal">M = Bad-Mime<o:p></o:p></p>
<p class="MsoNormal">H = Bad-Header<o:p></o:p></p>
<p class="MsoNormal">O = Oversized<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hope this helps.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Many more queries can be found here:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><a href="https://github.com/deeztek/Hermes-Secure-Email-Gateway/blob/master/dirstructure/var/www/html/admin/message_history_new.cfm">https://github.com/deeztek/Hermes-Secure-Email-Gateway/blob/master/dirstructure/var/www/html/admin/message_history_new.cfm</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"helvetica neue",serif;color:#585856"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.5pt;font-family:"helvetica neue",serif;color:#585856"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> amavis-users <amavis-users-bounces+dino.edwards=mydirectmail.net@amavis.org>
<b>On Behalf Of </b>Benedict White<br>
<b>Sent:</b> Sunday, June 13, 2021 7:26 PM<br>
<b>To:</b> amavis-users@amavis.org<br>
<b>Subject:</b> Issue with mails in sql quarantine<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-GB">I had an issue for two days over a weekend where most emails got quarantined.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">Does anyone have an sql statement to list quarantined emails by user please?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-GB">Kind Regards,
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-GB">Benedict White<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-GB" style="color:#1F497D;mso-fareast-language:EN-GB">Our business grows by referrals. If you know someone who would benefit from our help, please pass on our details.<o:p></o:p></span></b></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="margin-left:-.25pt;border-collapse:collapse">
<tbody>
<tr>
<td width="265" valign="top" style="width:198.45pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><a href="http://www.cse-ltd.co.uk/?utm_source=EmailSig&utm_medium=None&utm_campaign=CSE_TechSupp"><span style="color:#1F497D;mso-fareast-language:EN-GB;text-decoration:none"><img border="0" width="218" height="94" style="width:2.2708in;height:.9791in" id="Picture_x0020_1" src="cid:image001.jpg@01D760DD.D822B0B0" alt="cid:image001.jpg@01D12C21.CE196A10"></span></a><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
</td>
<td width="236" valign="top" style="width:177.2pt;padding:0in 5.4pt 0in 5.4pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="280" style="width:210.0pt">
<tbody>
<tr>
<td width="45" style="width:33.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;color:#1F497D;mso-fareast-language:EN-GB">Tel:
<o:p></o:p></span></b></p>
</td>
<td width="235" style="width:176.25pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;color:#1F497D;mso-fareast-language:EN-GB">01444 238070<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width="45" style="width:33.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;color:#1F497D;mso-fareast-language:EN-GB">Tech:
<o:p></o:p></span></b></p>
</td>
<td width="235" style="width:176.25pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;color:#1F497D;mso-fareast-language:EN-GB">01444 238080<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width="45" style="width:33.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;color:#1F497D;mso-fareast-language:EN-GB">Fax:
<o:p></o:p></span></b></p>
</td>
<td width="235" style="width:176.25pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;color:#1F497D;mso-fareast-language:EN-GB">01444 238099<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width="45" style="width:33.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;line-height:115%;color:#1F497D;mso-fareast-language:EN-GB">Web:
<o:p></o:p></span></b></p>
</td>
<td width="235" style="width:176.25pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="line-height:115%"><span style="mso-fareast-language:EN-GB"><a href="http://www.cse-ltd.co.uk/?utm_source=EmailSig&utm_medium=None&utm_campaign=CSE_TechSupp" target="_blank"><b><span style="font-size:9.0pt;line-height:115%;color:black">www.cse-ltd.co.uk</span></b></a></span><b><span style="font-size:12.0pt;line-height:115%;color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></b></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="line-height:115%"><span style="font-size:7.5pt;line-height:115%;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-GB">Registered in England and Wales No: 8666450<br>
Unit D, Consort Way, Burgess Hill, West Sussex,<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:7.5pt;line-height:105%;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-GB">RH15 9TJ</span><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
</td>
<td width="331" valign="top" style="width:248.05pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter" />
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0" />
<v:f eqn="sum @0 1 0" />
<v:f eqn="sum 0 0 @1" />
<v:f eqn="prod @2 1 2" />
<v:f eqn="prod @3 21600 pixelWidth" />
<v:f eqn="prod @3 21600 pixelHeight" />
<v:f eqn="sum @0 0 1" />
<v:f eqn="prod @6 1 2" />
<v:f eqn="prod @7 21600 pixelWidth" />
<v:f eqn="sum @8 21600 0" />
<v:f eqn="prod @7 21600 pixelHeight" />
<v:f eqn="sum @10 21600 0" />
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect" />
<o:lock v:ext="edit" aspectratio="t" />
</v:shapetype><v:shape id="Picture_x0020_6" o:spid="_x0000_s1026" type="#_x0000_t75" style='position:absolute;margin-left:-1.65pt;margin-top:6.1pt;width:191.25pt;height:65.25pt;z-index:-251658752;visibility:visible;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:text;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page'>
<v:imagedata cropbottom="-1407374884f" cropright="-1407374884f" />
<w:wrap type="through"/>
</v:shape><![endif]--><![if !vml]><img width="255" height="87" style="width:2.6562in;height:.9062in" src="cid:image002.png@01D760DF.38A54E10" align="left" hspace="12" v:shapes="Picture_x0020_6"><![endif]><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:28.2pt">
<td width="265" valign="top" style="width:198.45pt;padding:0in 5.4pt 0in 5.4pt;height:28.2pt">
<p class="MsoNormal" style="line-height:105%"><span style="color:#1F497D;mso-fareast-language:EN-GB">
</span><a href="http://www.facebook.com/?ref=tn_tnmn#!/pages/CSE/173531926406"><span style="color:#1F497D;mso-fareast-language:EN-GB;text-decoration:none"><img border="0" width="33" height="33" style="width:.3437in;height:.3437in" id="Picture_x0020_2" src="cid:image009.png@01D760DD.D822B0B0" alt="cid:image004.png@01D12C21.CE196A10"></span></a><span style="color:#1F497D;mso-fareast-language:EN-GB"> </span><a href="http://www.google.com/+CseltdUk_ITSupport"><span style="color:#1F497D;mso-fareast-language:EN-GB;text-decoration:none"><img border="0" width="33" height="33" style="width:.3437in;height:.3437in" id="Picture_x0020_3" src="cid:image010.png@01D760DD.D822B0B0" alt="cid:image005.png@01D12C21.CE196A10"></span></a><span style="color:#1F497D;mso-fareast-language:EN-GB"> </span><a href="https://twitter.com/cseltd"><span style="color:#1F497D;mso-fareast-language:EN-GB;text-decoration:none"><img border="0" width="33" height="33" style="width:.3437in;height:.3437in" id="Picture_x0020_4" src="cid:image011.png@01D760DD.D822B0B0" alt="cid:image006.png@01D12C21.CE196A10"></span></a><span style="color:#1F497D;mso-fareast-language:EN-GB"> </span><a href="http://www.linkedin.com/company/computer-systems-engineering-ltd"><span style="color:#1F497D;mso-fareast-language:EN-GB;text-decoration:none"><img border="0" width="33" height="33" style="width:.3437in;height:.3437in" id="Picture_x0020_5" src="cid:image012.jpg@01D760DD.D822B0B0" alt="cid:image007.jpg@01D12C21.CE196A10"></span></a><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
</td>
<td width="236" valign="top" style="width:177.2pt;padding:0in 5.4pt 0in 5.4pt;height:28.2pt">
<p class="MsoNormal" align="center" style="text-align:center;line-height:105%"><a href="http://www.cse-ltd.co.uk/Help?utm_source=EmailSig&utm_medium=TechHelp&utm_campaign=CSE_TechSupp"><span style="color:#1F497D;mso-fareast-language:EN-GB;text-decoration:none"><img border="0" width="92" height="50" style="width:.9583in;height:.5208in" id="Picture_x0020_8" src="cid:image013.jpg@01D760DD.D822B0B0" alt="Description: Q:\marketing\Logos\NewCo\ActionPress\Help.jpg"></span></a><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
</td>
<td width="331" valign="top" style="width:248.05pt;padding:0in 5.4pt 0in 5.4pt;height:28.2pt">
<p class="MsoNormal" style="line-height:105%"><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
</td>
</tr>
<tr style="height:15.45pt">
<td width="265" valign="top" style="width:198.45pt;padding:0in 5.4pt 0in 5.4pt;height:15.45pt">
<p class="MsoNormal" style="line-height:105%"><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
</td>
<td width="236" valign="top" style="width:177.2pt;padding:0in 5.4pt 0in 5.4pt;height:15.45pt">
<p class="MsoNormal" style="line-height:105%"><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
</td>
<td width="331" valign="top" style="width:248.05pt;padding:0in 5.4pt 0in 5.4pt;height:15.45pt">
<p class="MsoNormal" style="line-height:105%"><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
</td>
</tr>
<tr>
<td width="832" colspan="3" valign="top" style="width:623.7pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal" style="line-height:105%"><b><span style="font-size:7.5pt;line-height:105%;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-GB">Legal Disclaimer:</span></b><span style="font-size:7.5pt;line-height:105%;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:EN-GB">
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.</span><span style="color:#1F497D;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
</div>
</body>
</html>