Question How to get a list of domains and their mail outputs?

[tkalfaoglu]

I would like to get a list of how much outbound mail (in bytes for example) per domain right now.
For example,

abc.com 363733
xyz.com 28282
etc

Is there an SQL query or some plesk report that would provide something like that?
Many thanks, -turgut

 

[IgorG]

You can use following SQL query for period from 10 May to 20 May, for example:

select domains.name, (sum(DomainsTraffic.smtp_out))/1024/1024 as "Out SMTP,MB", (sum(DomainsTraffic.pop3_imap_out))/1024/1024 as "Out IMAP/POP3,MB" from domains, DomainsTraffic where id=dom_id AND date>='2020-05-10' AND date<='2020-05-20' GROUP BY dom_id;

Results in Mb.