Search deleted accounts

Revision as of 14:25, 18 August 2014 by Managedhosting de (talk | contribs) (Search Zimbra MySQL Database for deleted Accounts)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Zimbra keeps track of deleted accounts in its MySQL database. So if it will be necessary to search for accounts that may have existed some time ago, you can list all accounts. As the zimbra user issue the following command:

  mysql -e select email, from_unixtime(deleted_at) from zimbra.deleted_account order by deleted_at

The result should look like

  [zimbra@zimbra ~]$ mysql -e "select email, from_unixtime(deleted_at) from zimbra.deleted_account order by deleted_at"
  +----------------------------------------------+---------------------------+
  | email                                        | from_unixtime(deleted_at) |
  +----------------------------------------------+---------------------------+
  | john.doe@zimbra-test.de                      | 2014-07-23 21:21:49       |
  +----------------------------------------------+---------------------------+
  [zimbra@zimbra ~]$

--managedhosting.de (talk) 14:25, 18 August 2014 (UTC)

Jump to: navigation, search