James McGee (@sql_mcgee) 's Twitter Profile
James McGee

@sql_mcgee

Husband || Father || Digital Forensic Examiner || Cyber Crime Investigator || SQL Query Fanatic || Sometimes I make NFTs of my Dog

ID: 1491585091688181762

calendar_today10-02-2022 01:29:48

211 Tweet

284 Followers

88 Following

James McGee (@sql_mcgee) 's Twitter Profile Photo

Our latest course review is now available! šŸ“±šŸ§  Explore Hexordia’s Mobile Data Structures: Honing Your Digital Forensic Edge for our thoughts on this course. šŸ“ˆšŸ“Š Find it here: tinyurl.com/msb27jyz šŸ”—

James McGee (@sql_mcgee) 's Twitter Profile Photo

Many thanks to Oxygen Forensics for the opportunity to speak at this great event. Excited to share original research and insights into new and emerging data from the Health and Workout applications. Hope to see you Tuesday!

James McGee (@sql_mcgee) 's Twitter Profile Photo

Let’s discuss: unpopular opinion? iOS 18: AFU is <72 hrs from reboot and BFU state. Lot of extraction ASAP talk, regardless of search auth. You can articulate, but with auth prior you don’t have to. What am I missing? Are auths after device seizure really going beyond 24 hrs?

Let’s discuss: unpopular opinion? iOS 18: AFU is &lt;72 hrs from reboot and BFU state. Lot of extraction ASAP talk, regardless of search auth. You can articulate, but with auth prior you don’t have to. What am I missing? Are auths after device seizure really going beyond 24 hrs?
James McGee (@sql_mcgee) 's Twitter Profile Photo

This Thanksgiving, I’m grateful for the opportunity to make a difference and help bring justice to light. It’s the small details that matter, and I’m thankful to be part of a journey that strives for truth and fairness for all. Wishing everyone a meaningful Thanksgiving!

James McGee (@sql_mcgee) 's Twitter Profile Photo

šŸ” New article from Metadata Forensics! šŸ“± ā€œHello! Who is on the Line?ā€ – we’re diving into parsing iPhone group calls, something not previously supported by commercial or open-source mobile forensic tools. Check it out šŸ‘‰ tinyurl.com/3n6c3374

James McGee (@sql_mcgee) 's Twitter Profile Photo

Many thanks to Magnet Forensics, Hexordia, and the CTF authors for this great experience! Glad the timing worked out that I was able to participate - really enjoyable, creative, and challenging. Still may go back and look at some more of these questions..

Many thanks to <a href="/MagnetForensics/">Magnet Forensics</a>, <a href="/hexordia/">Hexordia</a>, and the CTF authors for this great experience! Glad the timing worked out that I was able to participate - really enjoyable, creative, and challenging. Still may go back and look at some more of these questions..
James McGee (@sql_mcgee) 's Twitter Profile Photo

We’re thrilled to unveil "Legal Bytes in a Digital World," our new article series examining the intersection of law, technology, and digital forensics. In our debut piece, we explore US v. Strong - available here: tinyurl.com/ymn2ju28 Stay tuned for more!

James McGee (@sql_mcgee) 's Twitter Profile Photo

šŸš€ Google Location History Takeout ParserĀ Version 1.3.0.0 is here! šŸŽ‰ With enhanced KML support (TimeSpans, Descriptions & LineStrings), taking your data to the next level. Continue leveraging Google Location History Takeout & Warrant Return data. šŸ‘‰ tinyurl.com/2s8yzksx

James McGee (@sql_mcgee) 's Twitter Profile Photo

šŸš€ Google Location History Timeline Parser v 1.4 is now available! This release features multithreaded processing, time elapsed tracking, input file size calculation, and location-related files including HTML, CSV, and TXT. Available here: tinyurl.com/4dr3tuv5

James McGee (@sql_mcgee) 's Twitter Profile Photo

Thanks to our great DFIR Community and discussion on the matter, I’m happy to announce our Google Location History Takeout Parser, Version 1.4.1. We’ve added Horizontal Accuracy KMLs for Records.JSON data and Parking Events. Get it at tinyurl.com/4aua56u4 Google Earth example:

Thanks to our great DFIR Community and discussion on the matter, I’m happy to announce our Google Location History Takeout Parser, Version 1.4.1. We’ve added Horizontal Accuracy KMLs for Records.JSON data and Parking Events. Get it at tinyurl.com/4aua56u4 Google Earth example:
James McGee (@sql_mcgee) 's Twitter Profile Photo

HEART by Metadata Forensics (Health Events & Activity Reporting Tool) Free tool to parse Apple Health & Fitness data from FFS Extractions. šŸ” 31+ artifacts supported šŸ“Š HTML report + CSV/PDF export ā¬‡ļø Download: tinyurl.com/v8zesb7h šŸ“– Article: tinyurl.com/94rx6vk4

James McGee (@sql_mcgee) 's Twitter Profile Photo

šŸš€ New release! HEART by Metadata Forensics (Health Events & Activity Reporting Tool) Version 1.1.0.0! Now supporting TAR, DAR (some), Advanced Logical (Encrypted) Extractions, iTunes Encrypted Backups. ā¬‡ļø Download: tinyurl.com/v8zesb7h šŸ“– Article: tinyurl.com/94rx6vk4

James McGee (@sql_mcgee) 's Twitter Profile Photo

🧩 RowIDetectiveĀ šŸ•µļøā€ā™‚ļø formerly detailed Lagging for the Win: Querying for Negative Evidence in the sms.db. Now detecting missing messages at the end of Apple sms.db. Because every gap tells a story. šŸ”— github.com/MetadataForens…

James McGee (@sql_mcgee) 's Twitter Profile Photo

Ever wondered what secrets are in your Apple Contacts? šŸ“± iQueryContacts šŸ•µļø is our new advanced SQL query work for the AddressBook.sqlitedb. All the classic data plus some new info including the Chinese lunar birthday! Find out more atĀ github.com/MetadataForens…