1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Delete unused mailboxes

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by BenjS, Nov 22, 2011.

  1. BenjS

    BenjS Guest

    0
     
    Hello everybody

    Is there any possibility to check if some mailboxes wheren't used since N days? To prevent all of this zombie mailboxes, I want to check the logins and if a mailbox doesn't have any login in the last e.g. 180 days, I want remove it or simliar.

    Any ideas?

    Cheers,
    Benjamin
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Not sure that it is possible somehow to find data of mailboxes which are not used since N days. There isn't such info in database, for example.
    You can find all mailboxes with following SQL query:

    select concat(mail.mail_name,"@",domains.name) as address from mail,domains,accounts where mail.dom_id=domains.id and mail.account_id=accounts.id order by address;
     
Loading...