Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Differentiate Message Center Blacklists and AC blacklists

Avatar

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
priyankah586599
Level 3

28-11-2017

Hi,

Can someone let me know how can we differentiate the two.My customer is asking me to provide a list of MC blacklists and AC blacklists.

Regards,

Priyanka

Replies

Avatar

Avatar
Coach
MVP
david_garcia1
MVP

Likes

106 likes

Total Posts

183 posts

Correct Reply

41 solutions
Top badges earned
Coach
Contributor
Shape 1
Give Back 25
Give Back 10
View profile

Avatar
Coach
MVP
david_garcia1
MVP

Likes

106 likes

Total Posts

183 posts

Correct Reply

41 solutions
Top badges earned
Coach
Contributor
Shape 1
Give Back 25
Give Back 10
View profile
david_garcia1
MVP

28-11-2017

Start by linking the nmsaddress to the nmsdelivery tables and differentiate which templates are used  by MC through on deliveryId foreign keys, you can also group which addresses fell in the blacklist from all the different transactional templates/deliveries.

The following should get you started, start learning how the SQL tables are joined.

SELECT  top 201 A0.iAddressId, A0.sAddress, A0.iType, A0.iStatus, A0.iQuarantineReason, A0.tsLastModified, A0.tsCreated, $(pfx)GetEmailDomain(A0.sAddress), A0.mQuarantineText, A0.iDeliveryId, A0.tsLastError, A0.iConsecutiveError, D1.sInternalName

FROM NmsAddress A0 LEFT JOIN NmsDelivery D1 ON (D1.iDeliveryId = A0.iDeliveryId)

ORDER BY A0.tsLastModified DESC, A0.iAddressId

Avatar

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
priyankah586599
Level 3

29-11-2017

Hi David,

Thank you for your reply.

But I don't see nms:delivery schema. Did you mean some other Delivery?

I'm trying to join using enrichment activity and dont see fields like Quarantine reason.

Please help.

Regards,

Priyanka

Avatar

Avatar
Coach
MVP
david_garcia1
MVP

Likes

106 likes

Total Posts

183 posts

Correct Reply

41 solutions
Top badges earned
Coach
Contributor
Shape 1
Give Back 25
Give Back 10
View profile

Avatar
Coach
MVP
david_garcia1
MVP

Likes

106 likes

Total Posts

183 posts

Correct Reply

41 solutions
Top badges earned
Coach
Contributor
Shape 1
Give Back 25
Give Back 10
View profile
david_garcia1
MVP

30-11-2017

The quarantine reason is the "quarantineText" field and "quarantineReason"

1361494_pastedImage_0.png