21 de septiembre de 2016

1. Estadísticas de tráfico SMTP del mes actual, ordenada por dominios SELECT name, CONCAT(YEAR(date),’-‘,MONTH(date)) fecha, SUM(smtp_out/1024/1024) as smtp_out,  SUM(smtp_in/1024/1024) as smtp_in FROM DomainsTraffic INNER JOIN domains ON domains.id = DomainsTraffic.dom_id WHERE YEAR(date)=YEAR(now()) and MONTH(date)=MONTH(now()) GROUP BY name ORDER BY name 2. Estadísticas diarias para un dominio SELECT name, date fecha, SUM(smtp_out/1024/1024) as smtp_out, SUM(smtp_in/1024/1024) as […]