Avatar

Community Advisor

Hi @Ramaswami,

 

extend this query in WHERE clause to identify you specific delivery or domain.

You have enough for start just adjust it per your needs.

 

SELECT sum((D0.iUnknownUser)) as HARD_BOUNCES, sum((D0.iUnreachable + D0.iMailBoxFull + D0.iInvalidDomain + D0.iDisabled + D0.iNotConnected + D0.iRefused)) as SOFT_BOUNCES,
sum((D0.iPrepared + D0.iError + D0.iSuccess)) as PROCESSED,
sum(D0.iSent) as SENT,
D0.sDomain,
O2.sLabel
FROM NmsDeliveryLogStats D0
JOIN NmsDelivery D1
ON (D1.iDeliveryId = D0.iDeliveryId)
JOIN NmsOperation O2
ON (O2.iOperationId = D1.iOperationId)
WHERE (D1.iMessageType = 0)
GROUP BY D0.sDomain, O2.sLabel;

 

Regards,

Milan