Created
September 30, 2017 22:37
-
-
Save apla/bc1c48575260863a9a0d0accf75fbbbb to your computer and use it in GitHub Desktop.
macOS Library/Mail account identifiers to username conversion
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ls -1 ~/Library/Mail/V5 | xargs -I {} sqlite3 -noheader -column ~/Library/Accounts/Accounts4.sqlite "select ZIDENTIFIER || ' => ' || ZUSERNAME || '/' || ZACCOUNTDESCRIPTION || ' ACTIVE: ' || ZACTIVE from ZACCOUNT where ZIDENTIFIER = '{}'" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment