Work out the hourly archiving rate, for the past 24 hours

USE VaultStore01
SELECT Min(archiveddate) AS ArchivedDate,
 "Hourly Rate for Americas Vault Store 04" = count (*),
 "Av Size" = sum (itemsize)/count (*)
FROM Saveset s
 
WHERE archiveddate > dateadd(hh, -24, getUTCdate ())
GROUP BY LEFT (convert (varchar, s.archiveddate,20),14)
ORDER BY LEFT (convert (varchar, s.archiveddate,20),14) DESC
 
USE VaultStore02
SELECT Min(archiveddate) AS ArchivedDate,
"Hourly Rate for  APJ Vault Store 02" = count (*),
"Av Size" = sum (itemsize)/count (*)
FROM Saveset s