SMS Database Location

[freepbxNewbie45]

Hello, I have successfully configured SMS for phone numbers through the UCP and I am able to send/receive messages through it. I saw a reference that the SMS messages are stored in a table called sms_messages, however, I cannot find this.

I am searching for the database to extract the messages for all DIDs. Could anyone direct me to where it would be located on the server?

[davidg]

If you want to access the database from the terminal as the asterisk user, just type fwconsole m

View what tables are in the asterisk database
show tables;

Select all data from sms_messages table
select * from sms_messages;

Good primer for viewing table data out of mysql can be found here:

SQL SELECT Statement