Delete unused mailboxes

[BenjS]

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

 

[IgorG]

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;