Difference between revisions of "Search deleted accounts"

(Search Zimbra MySQL Database for deleted Accounts)
 
 
(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. As the ''zimbra'' user issue the following command:
+
{{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
  
  [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 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

   KB 21134        Last updated on 2015-07-12  




0.00
(0 votes)

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)

Verified Against: Zimbra Collaboration 8.6, 8.0 Date Created: 04/16/2014
Article ID: https://wiki.zimbra.com/index.php?title=Search_deleted_accounts Date Modified: 2015-07-12



Try Zimbra

Try Zimbra Collaboration with a 60-day free trial.
Get it now »

Want to get involved?

You can contribute in the Community, Wiki, Code, or development of Zimlets.
Find out more. »

Looking for a Video?

Visit our YouTube channel to get the latest webinars, technology news, product overviews, and so much more.
Go to the YouTube channel »


Jump to: navigation, search