- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
0 Likes
Total Likes