Search deleted accounts: Difference between revisions

No edit summary
No edit summary
Line 1: Line 1:
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 by SQL.
{{Unsupported}}{{WIP}}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 by SQL.


As the ''zimbra'' user issue the following command:
As the ''zimbra'' user issue the following command:

Revision as of 16:37, 31 March 2015

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 by SQL.

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

  +----------------------------------------------+---------------------------+
  | 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