Photos.Sqlite Queries

Hello everyone! Back in August 2020, I wrote a blog “Using Photos.Sqlite to show the relationships between photos and the application they were created with?” which was posted on Heather Mahaliks’ blog, https://smarterforensics.com/. The writeup was eventually sent to DFIR Review (https://dfir.pubpub.org/pub/v19rksyf/release/1) and published on their website. This is a follow-up to the aforementioned blogContinue reading “Photos.Sqlite Queries”

iOS KnowledgeC.db Notifications

Cell phone use is routine. Our cell phones are really an extension of ourselves. We carry them around to not only make calls and messages, but they are also our daily planners, to do lists and entertainment resources. We use them at all times of the day – the alarms in the morning, email, andContinue reading “iOS KnowledgeC.db Notifications”

iPhone Device Speeds via Cache.sqlite > ZRTCLLOCATIONMO table

Have you ever wanted to know how fast a vehicle or person was traveling at a particular time? Have you considered acquiring iPhone data to answer that question? The material in this blog will help to provide some tools and methods for answering these questions. We know from previously published research that Apples iOS CoreContinue reading “iPhone Device Speeds via Cache.sqlite > ZRTCLLOCATIONMO table”

iOS Location Services and System Services ON or OFF?

Awhile back, I, started working on some research whether the device speed recorded in an iPhone database could be considered reliable evidence for how fast a device was traveling. I was going to discuss some device settings in the blog, but quickly learned the Location Services and System Services settings should be discussed in aContinue reading “iOS Location Services and System Services ON or OFF?”

Introduction

Hello Everyone, My name is Scott Koenig. I have been working in law enforcement for more than 15 years. In 2016, I decided it would be a good idea to become a digital forensic examiner. Since that time, I have attended several hours of training and earned several levels of certifications, but nothing has taughtContinue reading “Introduction”