After the Signal Fix: Exploring Apple's notificationAndSuggestionDB.db
Following my recent research into Apple's Biome ecosystem, I continued examining additional artifacts located within the DuetExpertCenter framework. Although much of the recent forensic attention has focused on the SEGB file format and, in particular, on the notification-related streams located within: /private/var/mobile/Library/DuetExpertCenter/streams/ it seemed reasonable to assume that additional notification-related artifacts might exist elsewhere within the same framework. This assumption proved correct. During the analysis of several iOS full filesystem acquisitions, I identified an SQLite database named: /private/var/mobile/Library/DuetExpertCenter/streams/notificationAndSuggestionDB.db At first glance, the database appeared relatively small and unremarkable. A closer inspection, however, revealed a valuable artifact for forensic investigations. The "notifications" Table Among the various tables present in the database, the most interesting is undoubtedly "n...