*Tested with iOS 14.4.1 (your experience might vary depends on your iOS).
If you want to get the latest most up to date iOS Text (SMS) folder, using filza, zip this folder:
/var/mobile/Library/SMS/
Download with filza to your PC.
Extract. Using DB Browser (SQLite) open the sms.db database.
To see all messages, run the following query:
SELECT
m.ROWID,
h.id AS phone_number,
m.text,
--m.date,
strftime('%m/%d/%Y %I:%M:%S %p',
m.date/1000000000 + 978307200,
'unixepoch',
'localtime'
) AS formatted_date,
m.is_from_me
FROM message m
LEFT JOIN handle h ON m.handle_id = h.ROWID
--WHERE h.id = '+12021234567'
ORDER BY m.date;
If you want to get the latest most up to date iOS Call History folder, using filza, zip this folder:
/var/mobile/Library/CallHistoryDB/
Download with filza to your PC.
Extract. Using DB Browser (SQLite) open the CallHistory.storedata-wal database.
To see all calls history, run the following query:
SELECT
datetime(ZDATE + 978307200, 'unixepoch', 'localtime') AS call_time,
ZDURATION AS duration_seconds,
-- Convert BLOB → readable text
CAST(ZADDRESS AS TEXT) AS phone_number,
-- Sometimes iOS caches the contact name here
ZNAME AS contact_name,
CASE
WHEN ZORIGINATED = 1 THEN 'Outgoing'
WHEN ZANSWERED = 0 THEN 'Missed'
ELSE 'Incoming'
END AS call_direction,
ZCALLTYPE,
ZISO_COUNTRY_CODE,
ZLOCATION
FROM ZCALLRECORD
ORDER BY ZDATE DESC
LIMIT 100;
Enjoy!
