Plesk 18: lista di tutte le email box e relativo spazio

Blog Plesk Tips Plesk 18: lista di tutte le email box e relativo spazio

Accedere da root in ssh, e:

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"

 

Plesk Tips

Comments are disabled.