Difference between revisions of "Search deleted accounts"

(Search Zimbra MySQL Database for deleted Accounts)
 
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. As the ''zimbra'' user issue the following command:
+
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.
  
   mysql -e select email, from_unixtime(deleted_at) from zimbra.deleted_account order by deleted_at
+
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
 
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) |
 
   | email                                        | from_unixtime(deleted_at) |
Line 13: Line 14:
 
   [zimbra@zimbra ~]$
 
   [zimbra@zimbra ~]$
  
--[[User:Managedhosting de|managedhosting.de]] ([[User talk:Managedhosting de|talk]]) 14:25, 18 August 2014 (UTC)
+
--
 +
 
 +
[[User:Managedhosting de|managedhosting.de]] ([[User talk:Managedhosting de|talk]]) 14:25, 18 August 2014 (UTC)

Revision as of 14:27, 18 August 2014

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