The following SQL query will return the number of messages archived in AM per day:
SELECT YEAR(DateProcessed) AS Year, MONTH(DateProcessed) AS Month, DAY(DateProcessed) AS Day, COUNT(*) AS MessageCount FROM Message GROUP BY YEAR(DateProcessed), MONTH(DateProcessed), DAY(DateProcessed) ORDER BY 1, 2, 3
