Hello everyone! During previous research, I’ve mentioned a few times that my test devices were using the Apple Photos application setting Optimize iPhone Storage in lieu of Download and Keep Originals setting. I’ve used this setting in the past because most devices I’ve encountered are using this setting. I’ve always had a curiosity about theContinue reading “Do you have a Full-Sized Asset…or just a Thumbnail? Did Optimized iPhone Storage process occur?”
Category Archives: Photos.Sqlite
Part B Filling a device internal storage for Optimize iPhone Storage Research
Part B Filling a device internal storage for Optimize iPhone Storage testing If you are reading this portion of the write-up about iCloud Photos and Optimize iPhone Storage, congratulations you have fell headfirst into the rabbit hole!! This is a good thing! More than likely, you’re asking yourself questions like why in the heck didContinue reading “Part B Filling a device internal storage for Optimize iPhone Storage Research”
Photos.sqlite ZINTERNALRESOURCE Table Reference Guide
This reference guide was built as a part of some research and testing I performed looking into the Photos.sqlite ZINTERNALRESOURCE table. During the research, I was able to interpret most of the values I encountered, but I was not able to decode everything. Additional research and testing are required. I will continue to update thisContinue reading “Photos.sqlite ZINTERNALRESOURCE Table Reference Guide”
Shared with You Syndication Photo Library – Message Attachments & Linked Assets
The Shared with You is a new feature that has been discussed within Apple Worldwide Developers Conference (WWDC) videos and other developer videos. Generally, the comments made indicate that within iOS and other Apple Operating Systems this feature will allow a user to easily view and interact with links that have been shared by otherContinue reading “Shared with You Syndication Photo Library – Message Attachments & Linked Assets”
How to find iOS Hidden Assets
Hello again! There has been a lot of discussion and curiosity about the recent news that iOS 16 will have an enhanced Hidden assets feature. According to the press releases, this feature will allow a user to lock hidden assets behind the device Passcode, Touch ID, and/or Face ID. The question I believe most ofContinue reading “How to find iOS Hidden Assets”
Local Photo Library Photos.sqlite Query Documentation & Notable Artifacts
As many of you are aware, I recently updated my Photos.sqlite queries. Since releasing the different query iterations, I have received several questions about how I was able to decode the data included in the queries. That’s a great question! I also noticed several questions being posted to the listservs and DFIR Discord about theContinue reading “Local Photo Library Photos.sqlite Query Documentation & Notable Artifacts”
Local Photo Library Photos.sqlite Query Variations & WHERE statements
I would like to start off by saying thank you to everyone who has reached out about the Photos.sqlite queries I previously posted. After chatting with some people who have used the queries, it was suggested that I update the queries to include the following: To do this, I used data from multiple devices andContinue reading “Local Photo Library Photos.sqlite Query Variations & WHERE statements”
The Forensic Scooter 