Reports to show peak transfer periods
How to identify the peak transfer periods
For identify periods for downtime it can help to look at the peak transfer periods in the solution. For MOVEit Transfer you can ask a DBA to run the following on the MOVEit Transfer database
MSSQL :
SELECT
FORMAT(logtime, 'ddd HH') AS Hour,
COUNT(*) AS Amount
FROM log
WHERE action = 'file_upload'
AND logtime >= '2026-08-01 00:00:00'
AND logtime <= '2026-08-26 23:59:59'
GROUP BY FORMAT(logtime, 'ddd HH');
MYSQL:
SELECT DATE_FORMAT(logtime, '%a %H') AS Hour, COUNT(*) AS Amount FROM log WHERE action = 'file_upload' AND logtime >= '2026-08-01 00:00:00' AND logtime <= '2026-08-26 23:59:59'GROUP BY DATE_FORMAT(logtime, '%a %H');
Output looks like the following:

We can also should look at Automation if.
MSSQL:SELECT FORMAT(CAST(LogStamp AS DATETIME), 'ddd HH') AS Hour, COUNT(*) AS FileUploadCountFROM statsWHERE Action = 'send' AND CAST(LogStamp AS DATETIME) >= '2025-08-01 00:00:00' AND CAST(LogStamp AS DATETIME) < '2026-08-27 00:00:00'GROUP BY FORMAT(CAST(LogStamp AS DATETIME), 'ddd HH');
MYSQL:SELECT DATE_FORMAT(CAST(LogStamp AS DATETIME), '%a %H') AS Hour, COUNT(*) AS FileUploadCountFROM statsWHERE Action = 'send' AND CAST(LogStamp AS DATETIME) >= '2025-08-01 00:00:00' AND CAST(LogStamp AS DATETIME) < '2026-08-27 00:00:00'GROUP BY DATE_FORMAT(CAST(LogStamp AS DATETIME), '%a %H');
Output looks like the following:
