Accounts3.sqlite: Accounts Signed In on iOS
iOS Accounts3.sqlite lists the Apple Account, iCloud, Game Center, mail and third-party accounts configured on the device, with creation dates.
- Location
- /private/var/mobile/Library/Accounts/Accounts3.sqlite (backup: HomeDomain, Library/Accounts/Accounts3.sqlite)
- Evidence area
- Proves
- 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 dates
- Timestamps
- Cocoa time in seconds (ZACCOUNT.ZDATE), UTC
- Acquisition
- Reaches 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 here
- Retention
- Rows exist while the account is configured; removing an account deletes its rows, which can survive in the WAL or freelist pages
- Collection
- idevicebackup2, iMazing, Full file system extraction
Tools
Compare all toolsWhat it is
Accounts3.sqlite is the database of the Accounts framework, the system-wide registry of accounts configured on the device. Each account has a type (Apple Account, iCloud, IDS for iMessage and FaceTime, Game Center, Exchange, Google, IMAP and others), a user name, a description, an owning app and, for many types, parent and child accounts. It is the quickest way to answer "which identities is this iPhone signed into?", which matters for attribution and for deciding which cloud services to request data from.
The database holds account metadata only. Passwords and tokens are stored in the keychain.
Where it lives
| Source | Path | Notes |
|---|---|---|
| Full file system | /private/var/mobile/Library/Accounts/Accounts3.sqlite (+ -wal, -shm) | Main database |
| iTunes / Finder backup | HomeDomain, Library/Accounts/Accounts3.sqlite | Commonly present; confirm in Manifest.db |
Related sources: the Apple Account also appears in Screen Time user tables and in iCloud-related preference files. Use them to corroborate.
What it proves
- That an account of a given type and user name was configured on the device.
- When the account record was created (
ZDATE), which often marks sign-in on this device or migration from a previous one. - Relationships between accounts, for example the Apple Account and its child iCloud, IDS and Game Center accounts.
- The app that owns third-party accounts (
ZOWNINGBUNDLEID).
It does not prove that the account was used on a given day, or that the device owner is the account holder.
Key fields
| Table / column | Meaning |
|---|---|
ZACCOUNT.ZUSERNAME | User name or email address |
ZACCOUNT.ZACCOUNTDESCRIPTION | Display name, e.g. "iCloud" |
ZACCOUNT.ZDATE | Creation date of the account record |
ZACCOUNT.ZACCOUNTTYPE | Foreign key to ZACCOUNTTYPE |
ZACCOUNT.ZPARENTACCOUNT | Parent account |
ZACCOUNT.ZOWNINGBUNDLEID | App that created the account |
ZACCOUNT.ZIDENTIFIER | Account UUID |
ZACCOUNTTYPE.ZACCOUNTTYPEDESCRIPTION, ZIDENTIFIER | Type, e.g. com.apple.account.AppleAccount, com.apple.account.IdentityServices, com.apple.account.IMAP |
ZACCOUNTPROPERTY | Key-value properties per account (often binary plists) |
Verify column names with .schema ZACCOUNT; Core Data stores add and rename columns across releases.
Timestamps
ZDATE is Cocoa time in seconds, UTC.
SELECT datetime(a.ZDATE + 978307200, 'unixepoch') AS created_utc,
t.ZACCOUNTTYPEDESCRIPTION AS type, t.ZIDENTIFIER AS type_id,
a.ZUSERNAME, a.ZACCOUNTDESCRIPTION, a.ZOWNINGBUNDLEID,
p.ZUSERNAME AS parent_user
FROM ZACCOUNT a
LEFT JOIN ZACCOUNTTYPE t ON a.ZACCOUNTTYPE = t.Z_PK
LEFT JOIN ZACCOUNT p ON a.ZPARENTACCOUNT = p.Z_PK
ORDER BY a.ZDATE;
Retention
Rows remain while the account is configured. Signing out or removing an account deletes its rows; traces may persist in the WAL, freelist pages and older backups. Restoring a device from a backup restores the database, so creation dates can predate the current hardware: compare with the device's activation and setup dates.
Collection
- A standard backup usually includes the database; a full file system adds the WAL.
- If credentials are needed for a lawful cloud acquisition, they come from the keychain (see keychain access groups), not from this file.
- Record the Apple Account shown in Settings during seizure if the screen was visible, and compare.
Parsing
- iLEAPP parses account types, user names and dates.
- Commercial suites list accounts in their device summary.
sqlite3with the query above; decodeZACCOUNTPROPERTYvalues withplutilwhen they are binary plists.
Investigator tips
- An Apple Account on the device that is not the owner's is a classic lead in stalkerware and coercive control cases: someone else may receive iCloud data. Check with the owner, and look for configuration profiles and suspicious TCC grants.
- Exchange or Google accounts identify providers to send legal requests to.
- A
ZDATEfar older than the device's purchase suggests a restore or migration. Build the device history before interpreting other creation dates. - The device and accounts guide combines this file with lockdown data, TCC and profiles.