Analyzing user viewing activity
So far, we have focused on analyzing photo and video media assets; however, the investigator may want to understand not only what media was stored on a device but also what media the user viewed.
This may include any of the following:
- Audio/video streamed through Safari or other browsers
- Music played through Apple Music or third-party apps such as Spotify
- Videos played through third-party apps such as YouTube and Netflix
The KnowledgeC.db
database, which we discussed in Chapter 5, Pattern-of-Life Forensics, tracks most of the user's day-to-day activity, including events related to audio or video playback.
The table of interest is the ZOBJECT
table, which stores device events, organizing them by stream name. Every time iOS detects that the user has initiated media playback, a /media/nowPlaying
event is triggered.
The following screenshot shows some example data from the KnowledgeC.db
database, analyzed using DB Browser...