Expand my Community achievements bar.

SOLVED

From which table SMS content sent to a particular profile to be viewed ?

Avatar

Level 3

I have a mobile number of particular profile & want to check what SMS contents has been sent to it.

From which table I can view its content ?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @NeelamBakre ,

SMS content is stored in [content/sms/source] of nms:delivery schema. Bear in mind it is not reflected as physically separated column as this is part of XML field (physically MDATA).

If you had some personalization inside of the delivery you won't be able to see personalization values in this field unless you have created mirror link.

 

Regards,

Milan

View solution in original post

8 Replies

Avatar

Correct answer by
Community Advisor

Hi @NeelamBakre ,

SMS content is stored in [content/sms/source] of nms:delivery schema. Bear in mind it is not reflected as physically separated column as this is part of XML field (physically MDATA).

If you had some personalization inside of the delivery you won't be able to see personalization values in this field unless you have created mirror link.

 

Regards,

Milan

Avatar

Level 2

If we take one step back and do not expect AC to save the personalized SMS content in a ready made table, is there any possibility to extract the personalized SMS content right before/after it is sent?
In our case, we are using SMPP protocol and with verbose debug log turned on, we can see those SMPP protocol messages from mtachild.log, but that's a bit too much hacking to "reverse engineer" and find out what SMS content AC has sent out.

Regards,
Shaohong

Avatar

Community Advisor

Hi @shaohong 
I am not sure there is an easy way for it. Personalization is done on the fly by MTA.
You can enable mirror page option on delivery level and have the preview of the content for the time you define as mirror page lifetime.

 

Cheers,

Milan

Avatar

Level 2

Thanks @Milan_Vucetic we'll give approach that a try, I hope there are programtic ways to get the mirror page url for the given (deliveryID, messageID) combo and then we can fetch the mirror page content from there.

Shaohong

Avatar

Employee Advisor

There would be a way to inject the Personalisation into the SMS content source using JavaScript function however it'd be very cumbersome because you would have to store ALL the target data to make it happen AND you don't control what fields would be in the Target Data at all, so it's although technically possible, not viable solution for the long run...

Outside the technicality, what are the business use cases where you would need to have the exact content of the SMS message sent? 

Not sure using the mirror page is also viable either but worth a try

Denis_Bozonnet_0-1671701687301.png

 

Avatar

Level 2

@DENT  The business requirement is to store the exact SMS text sent to the customer, so that when a customer support agent is enaging with a customer, he/she has the full context rather than just seeing a message template.

 

Avatar

Community Advisor

Hi @shaohong 

enable Force creation of mirror page on delivery level and fetch the link via JS:
mirrorPage = nms.delivery.GetMirrorURL(deliveryId,broadlogId.toXMLString());

 

Cheers,
Milan