Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Login
  • Contact Us
English (UK)
GB English (UK)
US English (US)

You Bring the MFT Questions

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

Popular Topics: Public,

  • Home
  • Public
  • Vendor - Specific
  • Progress MOVEit

Reports to show peak transfer periods

How to identify the peak transfer periods

Written by Sean Holdstock

Updated at August 26th, 2026

  • Public
    Vendor - Specific
+ More

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 FileUploadCount
FROM stats
WHERE 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 FileUploadCount
FROM stats
WHERE 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: 

 

transfer peek

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

Copyright © 2026 Pro2col Ltd

Terms of Sale

Privacy Policy

Support T's & C's


Knowledge Base Software powered by Helpjuice

Expand