[Question] what is the best way to display/parse the extracted SMS file

[pmancele]

I tried PhoneSploit and it worked great on my Android 13 OnePlus 8.

I extracted the SMS and wonder if there is a way to parse it and search on the SMS database, with filters like date of contact ?

Is the database using a standard format that I can load under anoher software ?

Or maybe you have another tool to extract the SMS to recommend ?

Thank you !

[AzeemIdrisi]

adb shell content query --uri content://sms/ --projection address:date:body

This command is used with the Android Debug Bridge (ADB) to query the content provider that stores SMS messages on an Android device. Here's a breakdown of the command:

• adb shell: Executes the following command in a shell on the connected Android device.
• content query: Instructs the content resolver to perform a query operation.
• --uri content://sms/: Specifies the URI of the content provider to query. In this case, it's the content provider that stores SMS messages.
• --projection address:date:body: Specifies the columns to include in the query result. The columns are separated by colons (:). The columns requested are address (phone number), date (timestamp), and body (message body) of the SMS messages.

This command would return a list of SMS messages from the device, including the phone number (address), timestamp (date), and message body (body) for each message.

In the device's database, SMS messages are typically stored in a table in a SQLite database. The exact structure of the table can vary depending on the Android version and manufacturer, but it generally includes columns for the following information:

_id: A unique identifier for each message.
address: The phone number of the sender or recipient.
date: The timestamp of the message.
body: The text of the message.
type: The type of message (inbox, sent, draft, etc.).
read: Whether the message has been read.
status: The status of the message (e.g., received, pending, failed).
thread_id: The ID of the message thread (a conversation).

To extract the SQLite database file containing SMS messages from an Android device using ADB, you can use the following steps:

1. Find the path to the SMS database file: You'll need to know the package name of the messaging app to find the database file. Common package names include com.android.messaging for Google Messages and com.android.providers.telephony for the default SMS app.

   Run the following command to find the path to the database file:

   adb shell 'echo $EXTERNAL_STORAGE'

   This will give you the path to the external storage directory (e.g., /storage/emulated/0).

2. Pull the database file: Use the following command to pull the database file from the device to your computer:

   adb pull /data/data/com.android.providers.telephony/databases/mmssms.db

   Replace com.android.providers.telephony with the package name of the messaging app you're interested in, and mmssms.db with the name of the database file if it's different.

3. Access the database: You can then use a SQLite database browser or command-line tool to open and explore the mmssms.db file on your computer.

I found this using ChatGPT, hope it helps.