How to query the soft bounce emails the emails that emails are soft bounced 3 or more times .

[jameels50927727]

Hi,

  How to query the soft bounce emails the emails that emails are soft bounced 3 or more times . Please any one help me .

Thanks & regards,

jameel.sk

[Amit_Kumar · Accepted solution]

Hi Jameel,

this can be computed as follows:

softBounce =  @unreachable + @mailBoxFull + @invalidDomain + @disabled + @notConnected + @refused

from nms:deliveryLogStats) this is also computed weekly in "Delivery weekly reporting" as softBounce.

if this value exceed 3 than you got what you want. 

Regards,

Amit

[jameels50927727]

Hi Amit_kumar,

     Thank you so much for valuable information.If you have please share screen short regarding soft bounced emails 3 or more times query.

Thanks & regards

jameel.sk

[Amit_Kumar]

Here you go:

This is already available in a computed field in nms:deliveryLogStats  schema even if you want to compute your own using workflow you can refer to following workflow:

<package author="Amit (amit)" buildDate="2017-05-16 06:58:52.848Z" buildNumber="8724" buildVersion="6.1"> <entities schema="xtk:workflow"> <workflow form="xtk:workflow" internalName="WKF755" label="test for soft bounces" modelName="newWorkflow" scenario-cs="Notification of the workflow supervisor (notifySupervisor)" schema="nms:recipient" simulation="false"> <activities> <query label="soft bounces greater than 3" name="query" recipientLink="" schema="nms:deliveryLogStats" x="347" y="79"> <transitions> <result name="result"/> </transitions> <select> <node alias="@softBounced" expr="ToInteger( @unreachable + @mailBoxFull + @invalidDomain + @disabled + @notConnected + @refused)" label="ToInteger(unreachable + inbox full + invalid domain + disabled account + not connected + rejected)"/> </select> <where filterName="backGroundFilterFrm" filteringSchema="nms:deliveryLogStats"> <condition expr="@softBounce &gt; 3" internalId="2713911315"/> </where> <outputFilter> <condition expr="@softBounced &gt; 3" internalId="2708340751"/> </outputFilter> <humanCond>Query: soft bounces greater than 3</humanCond> </query> </activities> <variables/> <scenario _operation="none" internalName="notifySupervisor"/> <desc>Empty template to create a new workflow</desc> <folder _operation="none" name="Folder97"/> </workflow> </entities> </package>

Hope this helps,

Regards,

Amit