We are doing some of our own reporting, and want to be able to pull SMS "chat" transcript into that report that will show each SMS message, with timestamp and sender. (ideally we'd be doing this on the fly via handlers, but for whatever reason webchat is a closed non-handler system)
I can see something that looks like this when I search for an interaction in ICBM and view the "recording", which pops up the transcript with exactly what we want to pull: [ATTACH]904[/ATTACH]
Can anyone tell me where to find this data in the I3 DB?