kb: how-to
Plesk for Linux
Question
How to list all mailboxes, their size, mail quota and mailbox occupation?
Answer
- Connect to the server via SSH
- 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"
Comments
0 comments
Please sign in to leave a comment.