How to Search Deleted Accounts in Zimbra

police_bin

Assalamualaikum.

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"

screen-shot-2017-02-21-at-19-41-42

wassalam..

..

Advertisements
This entry was posted in SQL, Zimbra and tagged , , , . Bookmark the permalink.