Skip to content

Instantly share code, notes, and snippets.

@siliconmeadow

siliconmeadow/traffic_by_client_in_plesk.sql

Created November 4, 2013 14:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save siliconmeadow/7303515 to your computer and use it in GitHub Desktop.
Save siliconmeadow/7303515 to your computer and use it in GitHub Desktop.
Download ZIP
To find traffic by client per month in Plesk.
Raw
traffic_by_client_in_plesk.sql
SELECT SUM(DomainsTraffic.http_out), SUM(DomainsTraffic.ftp_in), SUM(DomainsTraffic.ftp_out), SUM(DomainsTraffic.smtp_in), SUM(DomainsTraffic.smtp_out), SUM(DomainsTraffic.pop3_imap_in), SUM(DomainsTraffic.pop3_imap_out)
FROM DomainsTraffic, domains, clients
WHERE DomainsTraffic.date < '2008-07-10'
AND DomainsTraffic.date > '2008-05-31'
AND clients.id =1
AND clients.id = domains.cl_id
AND domains.id = DomainsTraffic.dom_id
Raw
traffic_by_client_in_plesk2.sql
SELECT DomainsTraffic.dom_id, DomainsTraffic.date, DomainsTraffic.http_out, DomainsTraffic.ftp_in, DomainsTraffic.ftp_out, DomainsTraffic.smtp_in, DomainsTraffic.smtp_out, DomainsTraffic.pop3_imap_in, DomainsTraffic.pop3_imap_out
FROM DomainsTraffic, domains, clients
WHERE DomainsTraffic.date < '2008-07-10'
AND DomainsTraffic.date > '2008-05-31'
AND clients.id =1
AND clients.id = domains.cl_id
AND domains.id = DomainsTraffic.dom_id
ORDER BY `DomainsTraffic`.`date` ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment