Skip to content

iOS artifacts cheat sheet

Every artifact on one table, grouped by category. Use your browser's print dialog (landscape) or save it as a PDF.

ArtifactLocationProvesTimestampsAcquisitionRetentionParsers
Communications
AddressBook.sqlitedbiOS 14+/private/var/mobile/Library/AddressBook/AddressBook.sqlitedb (backup: HomeDomain, Library/AddressBook/AddressBook.sqlitedb, fileID 31bb7ba8914766d4ba40d6dfb6113c8b614be442)Which people and organisations the owner stored, with phone numbers, emails, addresses, notes and the account each contact came from, plus when each record was created and last modifiedCocoa time in seconds (add 978307200 for Unix time), UTC, on ABPerson.CreationDate and ModificationDateUnencrypted backup is enough (HomeDomain). A full file system extraction adds the -wal file and freelist pagesUntil the contact is deleted locally or through a synced account (iCloud, Exchange, Google); deleted rows may survive in freelist pages for a whileiLEAPP, sqlite3, DB Browser for SQLite, iMazing, Magnet AXIOM
CallHistory.storedataiOS 14+/private/var/mobile/Library/CallHistoryDB/CallHistory.storedata (backup: HomeDomain, Library/CallHistoryDB/CallHistory.storedata, fileID 5a4935c78a5255723f707230a451d79c540d2741)Incoming, outgoing and missed calls over the phone network, FaceTime and CallKit apps (such as WhatsApp), with the other party, time, duration and answer stateCocoa time in seconds (add 978307200 for Unix time), UTC; ZDURATION in secondsEncrypted backup (Apple lists call history among data only encrypted backups include) or full file system extractionUntil deleted in the Phone app or pruned by iOS; the database can hold more rows than the Recents list shows, and deleted rows may survive in freelist pagesiLEAPP, sqlite3, DB Browser for SQLite, Magnet AXIOM, Cellebrite
interactionC.dbiOS 14–18/private/var/mobile/Library/CoreDuet/People/interactionC.db (backup: HomeDomain, Library/CoreDuet/People/interactionC.db, fileID 1f5a521220a3ad80ebfdc196978df8e7a2e49dee)That the owner interacted with a contact (message, call, share, mail) through a given app and direction at a given time, including apps whose own databases are encrypted or deletedCocoa time in seconds (ZSTARTDATE, ZENDDATE, ZCREATIONDATE and contact first/last dates), UTCReaches an iTunes / Finder backup (HomeDomain); a full file system extraction adds the -wal file and freelist pagesWeeks to a few months of interactions are commonly observed; pruning is internal to CoreDuet. Measure on the evidenceMVT, APOLLO, iLEAPP, sqlite3, DB Browser for SQLite, Magnet AXIOM
Signal (signal.sqlite)iOS 14+/private/var/mobile/Containers/Shared/AppGroup/<UUID>/grdb/signal.sqlite (+ -wal, -shm); attachments under .../Attachments/Signal conversations stored on the device: message bodies, direction, author, thread, recipients (phone numbers, ACI and PNI identifiers), attachments and disappearing-message settingsUnix time in milliseconds (divide by 1000), UTCFull file system extraction from an AFU device plus the keychain (the database key is stored there). Signal data is not in iTunes / Finder backupsUntil deleted by the user, by disappearing-message timers or by conversation length limits the user set; the local copy is usually the only copyiLEAPP, Magnet AXIOM, Cellebrite, Elcomsoft iOS Forensic Toolkit
sms.dbiOS 14+/private/var/mobile/Library/SMS/sms.db (backup: HomeDomain, Library/SMS/sms.db, fileID 3d0d7e5fb2ce288813306e4d4636395e047a3d28)Who exchanged which messages and attachments with the device owner, over which service (iMessage, SMS, and RCS on iOS 18+), and when they were sent, delivered and readCocoa time in nanoseconds (divide by 1,000,000,000, then add 978307200 for Unix time), UTCUnencrypted backup is enough (HomeDomain). A full file system extraction adds the -wal file, freelist pages and the Attachments tree without backup filteringUntil deleted by the user or by the Keep Messages setting (30 days, 1 year or forever). Since iOS 16, deleted messages sit in Recently Deleted for about 30 daysiLEAPP, imessage-exporter, sqlite3, DB Browser for SQLite, Magnet AXIOM, Cellebrite
Telegram (postbox)iOS 14+/private/var/mobile/Containers/Shared/AppGroup/<UUID>/telegram-data/account-<id>/postbox/db/db_sqlite (media: .../postbox/media/)Telegram messages cached on the device (cloud chats and secret chats), the peers involved, forwarded-from information, media and the signed-in accountUnix time in seconds, stored as 32-bit integers inside the binary message keys and records, UTCFull file system extraction from an AFU device; plan on backups being incomplete. The database is SQLCipher-encrypted and needs the key from .tempkeyEncryptedA local cache: cloud chats can be partial and are refreshed from Telegram's servers; secret chats exist only on the devices involved and can self-destructiLEAPP, Magnet AXIOM, Cellebrite, Oxygen Forensic Detective
WhatsApp ChatStorage.sqliteiOS 14+/private/var/mobile/Containers/Shared/AppGroup/<UUID>/ChatStorage.sqlite (group.net.whatsapp.WhatsApp.shared; backup: AppDomainGroup-group.net.whatsapp.WhatsApp.shared, fileID 7c7fba66680ef796b916b067077cc246adacf01d)WhatsApp conversations and groups stored on the device: message text, direction, sender JID, sent and delivered times, media and location attachments, and group membershipCocoa time in seconds (ZMESSAGEDATE, ZSENTDATE, ZLASTMESSAGEDATE), UTCUnencrypted backup is enough (AppDomainGroup-group.net.whatsapp.WhatsApp.shared). A full file system extraction adds the -wal file, freelist pages and media the backup skippedUntil the user deletes messages or chats, or disappearing messages expire them. WhatsApp's own iCloud backup is separate and not part of the device databaseiLEAPP, MVT, sqlite3, DB Browser for SQLite, Magnet AXIOM, Cellebrite
Location
locationd caches / clients.plistiOS 14+/private/var/root/Library/Caches/locationd/ (cache_encryptedA.db, cache_encryptedB.db, cache_encryptedC.db, clients.plist); clients.plist in backups: RootDomain, Library/Caches/locationd/clients.plistclients.plist: which apps and system services were authorised to use location and when they last did. Caches: cell towers and Wi-Fi access points the device looked up or harvested, with their estimated positionsCocoa time in seconds in the caches and in most clients.plist values, UTCclients.plist reaches an iTunes / Finder backup (RootDomain), as MVT's backup module relies on. The cache databases need a full file system extractionclients.plist keeps one entry per client while it exists. Cache tables are short-lived, typically days, and their content varies by releaseiLEAPP, APOLLO, MVT, sqlite3, plutil
Significant Locations (routined)iOS 14+/private/var/mobile/Library/Caches/com.apple.routined/ (Local.sqlite, Cloud-V2.sqlite, Cache.sqlite)Places the device learned and visited, with entry and exit times and a confidence and uncertainty per visit, plus short-lived raw location fixesCocoa time in seconds (add 978307200 for Unix time), UTCFull file system extraction from an AFU device; not included in iTunes / Finder backupsRaw fixes in Cache.sqlite: days. Learned visits in Local.sqlite: weeks to months, until iOS ages them out or the user clears Significant LocationsiLEAPP, APOLLO, sqlite3, DB Browser for SQLite, Magnet AXIOM, Cellebrite
com.apple.wifi.known-networks.plistiOS 14+/private/var/preferences/com.apple.wifi.known-networks.plist (older releases: /private/var/preferences/SystemConfiguration/com.apple.wifi.plist); also com.apple.wifi-private-mac-networks.plistWhich Wi-Fi networks the device knew, when each was added, last joined by the user or automatically, the BSSIDs seen, and settings such as private address and hidden networksProperty list dates (NSDate, stored as Cocoa time, shown as UTC)Encrypted backup (Apple lists Wi-Fi settings among data only encrypted backups include) or full file system extractionA network stays until the user forgets it or resets network settings; per-network dates are overwritten on each join. iCloud Keychain can sync networks from the owner's other devicesiLEAPP, plutil, Magnet AXIOM, Cellebrite
App usage
Biome streamsiOS 16+/private/var/mobile/Library/Biome/streams/{public,restricted}/<Stream>/{local,remote}/ and /private/var/db/biome/streams/Per-event device and user activity: app foreground changes, screen backlight, charging, battery, Wi-Fi and Bluetooth connections, now playing media, Safari navigations, notifications and more, per streamCocoa time (seconds, as double) in SEGB record headers; payload times vary by stream. UTCFull file system extraction from an AFU device; not in iTunes / Finder backupsPer stream, from days to several weeks; files rotate and are deleted by age and size. Measure per streamiLEAPP, ccl-segb, Magnet AXIOM, Cellebrite
DataUsage / netusageiOS 14+/private/var/wireless/Library/Databases/DataUsage.sqlite and /private/var/networkd/netusage.sqlite (older: /private/var/networkd/db/netusage.sqlite)Which processes and apps used cellular (and on some builds Wi-Fi) data, when each was first and last seen, and how many bytes they movedCocoa time in seconds (ZFIRSTTIMESTAMP, ZTIMESTAMP), UTCDataUsage.sqlite reaches an iTunes / Finder backup (WirelessDomain), as MVT's backup checks rely on. netusage.sqlite needs a full file system extractionProcess rows persist for long periods, often months; usage rows are aggregated and pruned. The database is reset by Reset Network Settings or a restoreMVT, iLEAPP, APOLLO, sqlite3, DB Browser for SQLite, Magnet AXIOM
knowledgeC.db / BiomeiOS 14+/private/var/mobile/Library/CoreDuet/Knowledge/knowledgeC.db and /private/var/mobile/Library/Biome/streams/When the device was unlocked, lit and charging, which app was in the foreground and for how long, and other usage signals, per intervalknowledgeC.db: Cocoa time in seconds, UTC, with ZSECONDSFROMGMT offset. Biome SEGB: Cocoa time in record headers; payload times vary by streamFull file system extraction only (not in iTunes / Finder backups); the device should be AFU so the protected files are readableWeeks rather than months: roughly four weeks is commonly observed for knowledgeC.db, and Biome streams are pruned per stream. Measure on the evidenceAPOLLO, iLEAPP, ccl-segb, sqlite3, Magnet AXIOM, Cellebrite
PowerLogiOS 14+/private/var/containers/Shared/SystemGroup/<UUID>/Library/BatteryLife/CurrentPowerlog.PLSQL (+ Archives/*.PLSQL.gz); copies under logs/powerlogs/ in a sysdiagnoseWhich apps ran in the foreground or background and for how long, screen and backlight state, battery level and charging, camera, torch, audio and location-client activity, per sampled intervalUnix time in seconds on PowerLog's internal clock; correct each value with PLStorageOperator_EventForward_TimeOffset before reporting, UTCFull file system extraction; a sysdiagnose also carries recent PowerLog databases. Not in iTunes / Finder backupsThe live database covers days; rotated archives extend that to a few weeks on many devices. Measure the oldest and newest rows per tableiLEAPP, APOLLO, sqlite3, DB Browser for SQLite, Magnet AXIOM, Cellebrite
Screen Time (RMAdminStore)iOS 14+/private/var/mobile/Library/Application Support/com.apple.remotemanagementd/RMAdminStore-Local.sqlite and RMAdminStore-Cloud.sqliteHow long each app, web domain and category was used per hour, how often the device was picked up, and which device and user of the Screen Time account the usage belongs toCocoa time in seconds (ZUSAGEBLOCK.ZSTARTDATE and related), UTC; usage is bucketed per hourFull file system extraction from an AFU device; not in iTunes / Finder backupsScreen Time shows the user about four weeks of history; the databases often hold a similar window. Measure the oldest usage blockAPOLLO, iLEAPP, sqlite3, DB Browser for SQLite, Magnet AXIOM, Cellebrite
Web browsing
Safari History.dbiOS 14+/private/var/mobile/Library/Safari/History.db (backup: HomeDomain, Library/Safari/History.db, fileID 1a0e7afc19d307da602ccdcece51af33afe92c53)Which URLs were visited in Safari (outside Private Browsing), with page titles, visit times, visit counts and redirect chains, including visits synced from the owner's other devicesCocoa time in seconds (add 978307200 for Unix time), UTC, in history_visits.visit_timeEncrypted backup (Apple lists website history among data only encrypted backups include) or full file system extraction; open tabs need a full file systemNot user-configurable on iOS; entries leave when the user clears history or iOS prunes old visits. Measure the oldest visit_time on the evidenceiLEAPP, sqlite3, DB Browser for SQLite, Magnet AXIOM, Cellebrite
Photos & media
Photos.sqliteiOS 14+/private/var/mobile/Media/PhotoData/Photos.sqlite (backup: CameraRollDomain, Media/PhotoData/Photos.sqlite, fileID 12b144c0bd44f2b3dffd9186d3f9c05b917cee25)When each photo or video was captured, added and modified, where it was taken, which app or source created or imported it, and whether it was hidden, favourited, shared or moved to Recently DeletedCocoa time in seconds (add 978307200 for Unix time), UTC; the capture-time zone is stored separately where recordedUnencrypted backup includes the database and locally stored media (CameraRollDomain). A full file system extraction adds thumbnails, derivatives, the WAL and freelist pagesAssets persist until deleted; deleted items stay in Recently Deleted for about 30 days, then leave the table but may remain in thumbnails and freelist pagesiLEAPP, ExifTool, sqlite3, DB Browser for SQLite, Magnet AXIOM, Cellebrite
Device & system
Accounts3.sqliteiOS 14+/private/var/mobile/Library/Accounts/Accounts3.sqlite (backup: HomeDomain, Library/Accounts/Accounts3.sqlite)Which accounts (Apple Account, iCloud services, iMessage and FaceTime identities, Game Center, mail, calendar and third-party providers) were configured on the device, with user names and creation datesCocoa time in seconds (ZACCOUNT.ZDATE), UTCReaches an iTunes / Finder backup (HomeDomain) on the builds commonly documented; a full file system extraction adds the -wal file. Credentials are in the keychain, not hereRows exist while the account is configured; removing an account deletes its rows, which can survive in the WAL or freelist pagesiLEAPP, sqlite3, DB Browser for SQLite, Magnet AXIOM, Cellebrite
Installed appsiOS 14+/private/var/mobile/Library/FrontBoard/applicationState.db; /private/var/containers/Bundle/Application/<UUID>/iTunesMetadata.plist; /private/var/installd/Library/Logs/MobileInstallation/mobile_installation.log.*; backup Info.plist and Manifest.plistWhich apps are installed, their bundle IDs, versions and container paths, who purchased them and when, and (from logs) install, update and uninstall eventsMixed: plist dates (UTC) in iTunesMetadata.plist and UninstalledApplications.plist; mobile_installation.log lines in device local time without an offsetA backup lists installed apps (Info.plist, Manifest.plist). applicationState.db, iTunesMetadata.plist and installation logs need a full file system extraction; logs also appear in a sysdiagnoseCurrent state only for applicationState.db and bundles; installation logs rotate and are sparse on recent releases; uninstall records are partialiLEAPP, MVT, plutil, sqlite3, iMazing, Magnet AXIOM
TCC.dbiOS 14+/private/var/mobile/Library/TCC/TCC.db (backup: HomeDomain, Library/TCC/TCC.db, fileID 64d0019cb3d46bfc8cce545a8ba54b93e7ea9347)Which apps asked for, were granted, limited or denied access to protected resources (camera, microphone, photos, contacts, calendars, Bluetooth, motion...), and when that decision last changedUnix time in seconds (access.last_modified), UTCReaches an iTunes / Finder backup (HomeDomain); a full file system extraction adds the -wal file. Location permissions are elsewhere (locationd clients.plist)One row per app and service, kept while the app is installed; rows are updated in place, so only the latest decision is keptMVT, iLEAPP, APOLLO, sqlite3, DB Browser for SQLite
Acquisition & backups
Manifest.db / Manifest.plistiOS 14+macOS: ~/Library/Application Support/MobileSync/Backup/<UDID>/ · Windows: %APPDATA%\Apple Computer\MobileSync\Backup\<UDID>\ or %USERPROFILE%\Apple\MobileSync\Backup\<UDID>\Which files a backup contains and where each one came from on the device, when the backup was taken, whether it is encrypted, and device identity (name, model, iOS version, serial, IMEI, installed apps)Info.plist and Status.plist dates are plist dates (UTC). MBFile records in Manifest.db hold Unix times in seconds for file birth, modification and status changeThe backup folder on a trusted computer, or a new backup from an unlocked, trusted device. Encrypted backups need the backup password to read Manifest.db and file contentOne backup set per device UDID on a host, overwritten by the next backup unless archived; older backups can survive on other computers or in host file system snapshotslibimobiledevice, pymobiledevice3, iMazing, UFADE, MVT, iphone_backup_decrypt, iLEAPP, plutil, sqlite3
Security & malware
Configuration profiles / MDMiOS 14+/private/var/containers/Shared/SystemGroup/systemgroup.com.apple.configurationprofiles/Library/ConfigurationProfiles/ (profile stubs, MCProfileEvents.plist, CloudConfigurationDetails.plist and others)Which configuration profiles were installed or removed and when, what they contained (root certificates, VPN, proxy, Wi-Fi, restrictions, MDM payloads), and whether the device was enrolled in MDM or Automated Device EnrollmentProperty list dates (NSDate, Cocoa time), shown as UTC; install times in MCProfileEvents.plistReaches an iTunes / Finder backup (SysSharedContainerDomain-systemgroup.com.apple.configurationprofiles), as MVT's backup modules rely on; a full file system extraction adds the rest of the system groupInstalled profiles remain until removed; MCProfileEvents.plist keeps install and removal events for longer, but not indefinitelyMVT, iLEAPP, plutil, Magnet AXIOM, Cellebrite
Crash logs / JetsamEventiOS 14+/private/var/mobile/Library/Logs/CrashReporter/ (*.ips, Retired/); also crashes_and_spins/ in a sysdiagnose and Settings > Privacy & Security > Analytics DataWhich apps and system processes crashed, hung or were killed, when, on which OS build, and (in JetsamEvent reports) which processes were resident in memory at the timeLocal time with UTC offset in the JSON metadata line (timestamp) and in body fields such as captureTime; convert to UTCAn unlocked, trusted device through the crash report service (no backup needed), a sysdiagnose, or a full file system extractioniOS keeps a limited number of reports per type and moves older ones to Retired/ before deleting them; weeks is typical. Collect earlypymobiledevice3, libimobiledevice, iLEAPP, MVT, sysdiagnose (EC-DIGIT-CSIRC)
shutdown.logiOS 14+/private/var/db/diagnostics/shutdown.log (and rotated shutdown.*.log); in a sysdiagnose: system_logs.logarchive/Extra/shutdown.logWhen the device was shut down or rebooted, and which processes (by PID and executable path) were still running and delaying the shutdown at that momentUnix time in seconds in SIGTERM lines, UTC; delays in secondssysdiagnose is enough; a full file system extraction also reaches it. Not in iTunes / Finder backupsEntries have been appended at each reboot and observed to span many months; researchers reported that iOS 26 rewrites the log at reboot instead, so history may be lost. Measure the first and last SIGTERM entryiShutdown, MVT, iLEAPP, sysdiagnose (EC-DIGIT-CSIRC)

The Access column gives the minimum acquisition level (backup, encrypted backup, full file system, sysdiagnose or iCloud). How each level works: iOS acquisition: backups, full file system and sysdiagnose