How to list all mailboxes, their size, mail quota and mailbox occupation?

Question

How to list all mailboxes, their size, mail quota and mailbox occupation?

Answer

1. Connect to the server via SSH
2. Use the following command:

   # plesk db "SELECT CONCAT(mail_name,'@',name) as 'Email', (truncate(mn.val/(1024*1024), 1)) as 'Megabytes',(truncate(mail.mbox_quota/(1024*1024), 1)) as 'Mailbox Size', (truncate((mn.val/mail.mbox_quota)*100, 1)) as 'Ocuppation' FROM mail,domains join mn_param mn WHERE dom_id=domains.id and mail.id=mn.mn_id and mn.param='box_usage' AND postbox='true' order by 4 desc"