Return
-
Title
How many attachments are ingested in Archive Manager over a period of time? -
Description
How many attachments are ingested in Archive Manager over a period of time? -
Resolution
Disclaimer: The following resolution contains SQL Queries. SQL Queries are provided "As is" for reference purposes. Quest accepts no liability for issues arising from incorrect usage of SQL Queries. Please ensure that full and current database backups exist before making any changes to the Archive Manager database, if in doubt please contact support.
The following SQL query will return the number of messages ingested in AM by day for the period of time from Jan 1st 2015 to Jan 1st 2016 (the dates can be modified in the script accordingly):
SELECT YEAR(DateProcessed) AS Year,MONTH(DateProcessed) AS Month,DAY(DateProcessed) AS Day, COUNT(a.AttachmentID) AS AttachmentAccount FROM Attachment as A JOIN(SELECT MessageID, DateProcessed FROM MessageWHERE DateProcessed between '2015-01-01' AND '2016-01-01') AS M on A.MessageID = M.MessageID GROUP BY YEAR(DateProcessed), MONTH(DateProcessed),DAY(DateProcessed)ORDER BY 1, 2, 3