How to query the soft bounce emails the emails that emails are soft bounced 3 or more times . | Community
Skip to main content
J
jameels50927727
Level 2
May 15, 2017
Solved

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

  • May 15, 2017
  • 3 replies
  • 1500 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Amit_Kumar

    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

    3 replies

    Amit_Kumar
    Amit_KumarAccepted solution
    Level 10
    May 15, 2017

    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

      J
      jameels50927727Author
      Level 2
      May 16, 2017

      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
      Amit_Kumar
      Level 10
      May 16, 2017

      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

      Terms & ConditionsAccessibility statement

      Loading footer...