January 2018
Beginner to intermediate
402 pages
10h 6m
English
The Short Message Service (SMS) database contains text and multimedia messages that were sent from and received by the device along with the phone number of the remote party, date and time, and other carrier information. Starting with iOS 5, iMessages data is also stored in the SMS database. iMessage allows users to send SMS and MMS messages over a cellular or Wi-Fi network to other iOS or OS X users, thus providing an alternative to SMS. The SMS database is a HomeDomain file, and it can be found at /private/var/mobile/Library/SMS/sms.db. This location has not changed as iOS versions have been released.
You can run the following queries in the DB Browser for SQLite to parse the SMS messages. Afterwards, you can export it into ...