iiinova — where your digital self keeps evolving

James McGee @sqlmcgee.bsky.social · 09/07/2026

🆕 Major Version Update: HEART by Metadata Forensics v 2.0! 🎉 ✅ Artifact Selection 🕚 Timestamp Display With Artifact Selection you can choose to analyze a single artifact, a subset, or all artifacts. Display timestamps in UTC or convert them to the device's local time. tinyurl.com/38m4xuzs

tinyurl.com

GitHub - MetadataForensics/HEART_by_Metadata_Forensics: This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner.

This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner. - MetadataForensics/HEART_by_Metadata_Forensics

000

James McGee @sqlmcgee.bsky.social · 02/07/2026

🚀 New Release: HEART by Metadata Forensics v1.4.2.0! 🚀 This release adds three new Apple Health application artifacts: 🥗 Nutrition 🔊 Environmental Sound - Detailed 🎧 Headphone Audio Levels - Detailed Free to download on GitHub: github.com/MetadataFore...

github.com

GitHub - MetadataForensics/HEART_by_Metadata_Forensics: This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner.

This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner. - MetadataForensics/HEART_by_Metadata_Forensics

000

James McGee @sqlmcgee.bsky.social · 26/06/2026

🚀 New Release: HEART by Metadata Forensics v1.4.1.0! 🚀 This release adds six new Apple Health application artifacts: 📋 Health Details ❤️ Cardio Recovery 💓 Heart Rate Variability 🧘 Mindful Minutes 🌤️ State of Mind 🌬️ Breathing Disturbances Free to download on GitHub: github.com/MetadataFore...

github.com

GitHub - MetadataForensics/HEART_by_Metadata_Forensics: This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner.

This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner. - MetadataForensics/HEART_by_Metadata_Forensics

000

James McGee @sqlmcgee.bsky.social · 19/05/2026

Check out our newest article, Empirical Assessment of Apple Health Activity Data: Accuracy, Granularity, and Database Artifacts! Looking deeper into the cache_encryptedC.db and iOS 26 changes. Article: tinyurl.com/ae8akwm5 Support updated to HEART: tinyurl.com/v8zesb7h

000

James McGee @sqlmcgee.bsky.social · 13/03/2026

KMLer turns CSV and XLSX files into KML files while adding the investigative context examiners and analysts need. 🕵️ Horizontal accuracy visualized, extended data, processing report, and more! Read more here: tinyurl.com/y8d3je3m Get it here: tinyurl.com/3fw8vnn8

000

James McGee @sqlmcgee.bsky.social · 26/02/2026

🚀 New Release: HEART by Metadata Forensics Version 1.3! 🚀 We’ve added Local Device Time conversions! most Apple Health and Fitness application artifacts are linked to the device recorded the event, the associated time zone is preserved as well. Conversions by activity! github.com/MetadataFore...

github.com

GitHub - MetadataForensics/HEART_by_Metadata_Forensics: This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner.

This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner. - MetadataForensics/HEART_by_Metadata_Forensics

000

James McGee @sqlmcgee.bsky.social · 23/02/2026

My own corner of Apple Health forensics lives on the Metadata Forensics company blog, The Metadata Perspective: lnkd.in/e6HZCBFq

010

James McGee @sqlmcgee.bsky.social · 23/02/2026

If you’re in digital investigations and haven’t joined the Summit yet, you still have time (Feb 23–26). It’s free, eye-opening, and full of practical takeaways: lnkd.in/ew3taAjV Looking forward to the rest of the week and continuing the conversation with all of you. #MVS2026 #DFIRCommunity

100

James McGee @sqlmcgee.bsky.social · 23/02/2026

Couldn’t start the week better-thank you Christopher Vance for the shout-out in your session, Harping on health data, during the Magnet Virtual Summit 2026! Your Mobile Unpacked series has helped so many of us, and it’s genuinely humbling to have my Apple Health contributions mentioned alongside it.

100

James McGee @sqlmcgee.bsky.social · 22/10/2025

🚀 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

tinyurl.com

GitHub - MetadataForensics/HEART_by_Metadata_Forensics: This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner.

This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner. - MetadataForensics/HEART_by_Metadata_Forensics

000

James McGee @sqlmcgee.bsky.social · 22/09/2025

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

tinyurl.com

GitHub - MetadataForensics/HEART_by_Metadata_Forensics: This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner.

This free tool parses Apple Health and Fitness Application data from Apple iPhone extractions in a forensic manner. - MetadataForensics/HEART_by_Metadata_Forensics

000

James McGee @sqlmcgee.bsky.social · 28/08/2025

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:

000

James McGee @sqlmcgee.bsky.social · 17/02/2025

Excited for this release, best is yet to come with the LEAPPs! Fantastic project, resource, and tool

000

James McGee @sqlmcgee.bsky.social · 14/02/2025

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 in-depth analysis and expert perspectives in DFIR.

tinyurl.com

Examining the United States v. Ladonies P. STRONG Case

The case US v. Strong addresses the legality of warrantless searches of mobile devices, highlighting Fourth Amendment privacy rights. When Strong’s device was searched without a warrant, it r…

000

James McGee @sqlmcgee.bsky.social · 13/02/2025

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..

123

James McGee @sqlmcgee.bsky.social · 05/02/2025

🔍 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

tinyurl.com

Hello! Who is on the Line?

Have you ever wondered how many individuals were on a phone call or Facetime call when reviewing data extracted from an iOS device? This question came up in a case recently when information was dev…

000

James McGee @sqlmcgee.bsky.social · 01/02/2025

🥳 Now also available within iLEAPP! 🎉 Such an incredible tool and community resource 🙌

000

James McGee @sqlmcgee.bsky.social · 30/01/2025

🕵️‍♂️💾 Uncover your device’s secret history! "Beyond the Logs: Using the Health App to Uncover Device Model and OS History" explores Health Application databases to reveal Apple model & OS info. Find out more at tinyurl.com/2dfwn5xs #metadataforensics #DFIR

tinyurl.com

Beyond the Logs: Using the Health App to Uncover Device Model and OS History

This article explores both the healthdb_secure.sqlite and healthdb.sqlite databases for data indicating devices possessed by the user, reviews device information hand-in-hand with OS version and ti…

100

James McGee @sqlmcgee.bsky.social · 28/11/2024

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!

000

James McGee @sqlmcgee.bsky.social · 14/11/2024

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?

000

James McGee @sqlmcgee.bsky.social · 26/08/2024

🚀 New Release Alert! 🎉 Check out the latest versions of our Google Location History Timeline Parser and Brute Force Dictionary List Generator! Now with a new graphical interface and enhanced functionality. Download today at github.com/MetadataFore...! 🚀

github.com

MetadataForensics - Overview

Alongside seeking the digital truth and client satisfaction in all our cases, we also strive to further the DFIR Community with our research and work products. - MetadataForensics

000

James McGee @sqlmcgee.bsky.social · 14/08/2024

New Blog Alert: Rookie Reflections: A Green Examiner's Forensic Journey Into Cellebrite, available here: tinyurl.com/3xbmcrje. Discover insights, challenges, and tips from one of our newest team members in her review of Cellebrite’s CCO course!

tinyurl.com

Rookie Reflections: A Green Examiner’s Forensic Journey Into Cellebrite

I came to Metadata Forensics from a local Police department in Georgia, and while I thoroughly enjoyed the “figure it out” education I accrued there. I was excited to start adding the letters to the e...

010

James McGee @sqlmcgee.bsky.social · 01/08/2024

Wake up to our new article, Sleepless in Cupertino: A Forensic Dive into Apple Watch Sleep Tracking! 🌙 Review how Sleep data is stored and explore parsing with SQL query solutions. 🔍 Learn how this could lend insight into the future Vitals app! 📈 tinyurl.com/yc43kpme

tinyurl.com

Sleepless in Cupertino: A Forensic Dive into Apple Watch Sleep Tracking

How's your sleep been lately? Currently, there are numerous sleep tracking and monitoring devices available to track, monitor, and quantify sleep patterns for users actively seeking to improve their s...

000

James McGee @sqlmcgee.bsky.social · 21/05/2024

🔍 Explore Apple Watch wear data parsed from the healthdb_secure.sqlite! This data can assist in pattern of life analysis and provide valuable context for expected data recording, such as heart rate data.. 📈👀 Available here: tinyurl.com/2a3up53t

tinyurl.com

Apple Watch – Worn Data Analysis

The article explores a lesser-known data point in Apple Health that shows when an Apple Watch is worn. This data indicates one-hour time periods when the Watch was worn and time segments when the Watc...

000

James McGee @sqlmcgee.bsky.social · 29/01/2024

📢 New article alert! Explore the siriremembers.sqlite3 database – a fusion of Biome and the interactionC database! 🔍 SQL queries, key data insights, and future implications. Read about it here: tinyurl.com/4u9v3tjr Explore SQL Queries here: tinyurl.com/7758z4ur

tinyurl.com

Siri’s Memory Lane: Exploring the siriremembers Database

The siriremembers.sqlite3 database, simply put, is a combination of Biome and the interactionC database. In this article, we explore this new SQLite database, cover parsing key data through SQL querie...

000