Search deleted accounts: Difference between revisions
(Search Zimbra MySQL Database for deleted Accounts) |
No edit summary |
||
(2 intermediate revisions by 2 users not shown) | |||
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. | {{BC|Community Sandbox}} | ||
__FORCETOC__ | |||
<div class="col-md-12 ibox-content"> | |||
=Search deleted accounts= | |||
{{KB|{{Unsupported}}|{{ZCS 8.6}}|{{ZCS 8.5}}|{{ZCS 8.0}}|}} | |||
{{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. | |||
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 | ||
+----------------------------------------------+---------------------------+ | +----------------------------------------------+---------------------------+ | ||
| email | from_unixtime(deleted_at) | | | email | from_unixtime(deleted_at) | | ||
Line 13: | Line 19: | ||
[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) | |||
{{Article Footer|Zimbra Collaboration 8.6, 8.0|04/16/2014}} |
Latest revision as of 21:48, 12 July 2015
Search deleted accounts
- This article is a Work in Progress, and may be unfinished or missing sections.
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)