Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Archiving and eDiscovery Community Blog

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

Created: 15 Dec 2009 • Updated: 29 May 2014 • 1 comment
Wayne Humphrey's picture
+3 3 Votes
Login to vote

So here is a SQL script to work out the hourly archiving rate, for the past 24 hours .

You will need to define all the Vault Stores in this query.

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

 

Comments 1 CommentJump to latest comment

GregRountree's picture

Thanks Wayne Great Stuff!

0
Login to vote