How to get a list of all email accounts and their disk usage via a command-line interface in Plesk

• 

  Bobby Martin October 04, 2019 17:21 (Edited October 04, 2019 17:21)

  Thanks Kuzma, very helpful!

  0

  Comment actions Permalink
• 

  Stavros Tsalikoglou September 23, 2020 10:36

  Thank you, nice one!

   

  In MB:

  plesk db "SELECT concat(mail.mail_name,'@',domains.name) AS 'Email address', concat(mn_param.val / 1048576, 'MB') AS 'Mailbox usage', concat(Limits.value / 1048576, 'MB') AS 'Mailbox limit' FROM mail LEFT JOIN mn_param ON mail.id=mn_param.mn_id LEFT JOIN domains ON mail.dom_id=domains.id LEFT JOIN Subscriptions ON domains.id=Subscriptions.object_id LEFT JOIN SubscriptionProperties ON Subscriptions.id=SubscriptionProperties.subscription_id LEFT JOIN Limits ON SubscriptionProperties.value=Limits.id WHERE mn_param.param='box_usage' AND Subscriptions.object_type='domain' AND SubscriptionProperties.name='limitsId' AND Limits.limit_name='mbox_quota'"

  0

  Comment actions Permalink
• 

  Taras Ermoshin September 23, 2020 13:43

  Hi @Stavros T, thanks for sharing!

  1

  Comment actions Permalink
• 

  Luis Zubeldia January 28, 2021 16:45

  Please modify your query to order by mailbox usage and show the values in MB can be more usefull

  0

  Comment actions Permalink
• 

  Sero March 10, 2023 20:40

  There you go @Luis Zubeldia

   

  sorry I currently dont know how put codeline in here.

  Just registered to help you :)

   

  of subscriptions' main domains:

   

  plesk db "

  SELECT concat(mail.mail_name,'@',domains.name) AS 'Email address',

      concat(mn_param.val / 1048576, 'MB') AS 'Mailbox usage',

      concat(Limits.value / 1048576, 'MB') AS 'Mailbox limit'

  FROM mail

  LEFT JOIN mn_param ON mail.id=mn_param.mn_id

  LEFT JOIN domains ON mail.dom_id=domains.id

  LEFT JOIN Subscriptions ON domains.id=Subscriptions.object_id

  LEFT JOIN SubscriptionProperties ON Subscriptions.id=SubscriptionProperties.subscription_id

  LEFT JOIN Limits ON SubscriptionProperties.value=Limits.id

  WHERE mn_param.param='box_usage'

      AND Subscriptions.object_type='domain'

      AND SubscriptionProperties.name='limitsId'

      AND Limits.limit_name='mbox_quota'

  ORDER BY CAST(mn_param.val AS DECIMAL) DESC;

  "

   

   

  of subscriptions' additional domains:

  plesk db "

  SELECT concat(mail.mail_name,'@',domains.name) AS 'Email address',

      concat(mn_param.val / 1048576, 'MB') AS 'Mailbox usage',

      Limits.value AS 'Mailbox limit'

  FROM mail

  LEFT JOIN mn_param ON mail.id=mn_param.mn_id

  LEFT JOIN domains ON mail.dom_id=domains.id

  LEFT JOIN Subscriptions ON domains.webspace_id=Subscriptions.object_id

  LEFT JOIN SubscriptionProperties ON Subscriptions.id=SubscriptionProperties.subscription_id

  LEFT JOIN Limits ON SubscriptionProperties.value=Limits.id

  WHERE mn_param.param='box_usage'

      AND Subscriptions.object_type='domain'

      AND SubscriptionProperties.name='limitsId'

      AND Limits.limit_name='mbox_quota'

      AND domains.webspace_id<>0

      AND domains.parentDomainId=0

  ORDER BY CAST(mn_param.val AS DECIMAL) DESC;

  "

  0

  Comment actions Permalink

Please sign in to leave a comment.