Jump to content
Sign in to follow this  

Procedure to extract iPhone SMS logs from a MAC

1 post in this topic

Recommended Posts

Filed: K-1 Visa Country: Vietnam

If someone could move this to the right forum, please...

For use as "evidence of Relationship', you may want to get a dump of your iPhone's SMS logs. We used IM mainly in video mode, so we actually had more text in SMS that in IM.

There are tools you can buy to do this. This is how to do it for free with a little elbow grease. I found scattered instructions on how to access the logs, but not the whole process. So.. here is what worked for me. No guarantees, but hope it helps someone.

(** = commentary, & not a command)

**Backup your iPhone in iTunes: right click your device & select 'Back Up'

**Open Terminal (from Applications) & issue the following commands:

** in the following command, replace [username] with your username

cd /Users/[username]/Library/Application Support/MobileSync/Backup/3402aa514e7302dbf18a2649fca1243427ac450e

sqlite3 3d0d7e5fb2ce288813306e4d4636395e047a3d28 .dump > sms.db.txt


** you are now in the sqlite3 db tool

.read ./sms.db.txt

.output smsLog.txt

.separator '%'

** see below for details about this query

SELECT CASE WHEN flags=2 THEN 'FROM' ELSE 'TO ' END, address, datetime(date,'unixepoch','localtime'), text FROM message WHERE address like '84%' OR address like '+84%';

**open smsLog.txt in Excel or openOffice Calc & edit / ready for printing (it will be in the same path you cd's to access the logs). In the spreadsheet tool, you need to define the field separator as '%' when inhaling the file - it should automatically prompt you for this. Any newlines (Carriage returns) in your SMS texts will be read as new lines, so you will need to manually edit those lines.

For the SELECT statement.. This is basic SQL syntax. If you don't know anything about SQL & don't care to research it.. you're still ok. Note that my example matches 2 possible wildcards on the country code 84 (Vietnam). In some cases, my phone used the +, in others it didn't, so I needed to do it this way. You can also search for exact #s like so:

SELECT CASE WHEN flags=2 THEN 'FROM' ELSE 'TO ' END, address, datetime(date,'unixepoch','localtime'), text FROM message WHERE address ='8885551212';

Edited by astrlsrfr

Share this post

Link to post
Share on other sites
Didn't find the answer you were looking for? Ask our VJ Immigration Lawyers.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
- Back to Top -

Important Disclaimer: Please read carefully the Visajourney.com Terms of Service. If you do not agree to the Terms of Service you should not access or view any page (including this page) on VisaJourney.com. Answers and comments provided on Visajourney.com Forums are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Visajourney.com does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. VisaJourney.com does not condone immigration fraud in any way, shape or manner. VisaJourney.com recommends that if any member or user knows directly of someone involved in fraudulent or illegal activity, that they report such activity directly to the Department of Homeland Security, Immigration and Customs Enforcement. You can contact ICE via email at Immigration.Reply@dhs.gov or you can telephone ICE at 1-866-347-2423. All reported threads/posts containing reference to immigration fraud or illegal activities will be removed from this board. If you feel that you have found inappropriate content, please let us know by contacting us here with a url link to that content. Thank you.
  • Create New...