Video Screencast Help

Mailbox Archive Rate

Created: 03 Nov 2011 • Updated: 03 Nov 2011 | 2 comments
Rich_W's picture
This issue has been solved. See solution.

Good morning all,

I have been looking at some of the SQL queries that give you the archive rate of the vault store. I was wondering if anyone has come up with one that will tell us what a user is archiving per hour per day. I imagine it might be possible using the users archive ID, but DBA I am not.

Thanks in advance for any assistance. 


Comments 2 CommentsJump to latest comment

TonySterling's picture

Here is one, it isn't pretty but it works.  You can change the Where clause to use the last 24 hours by removing the -- and then commenting out the other where clause. Also, if you want to run on all mailboxes remove the "and ex.MbxDisplayName =" bit

select ex.MbxDisplayName,"Archived Date" = left (convert (varchar, s.archiveddate,20),14),
"Hourly Rate" = count (*),
"Av Size" = sum (s.itemsize)/count (*)
from saveset s
Join Archivepoint a on a.ArchivePointIdentity =s.ArchivePointIdentity
Join EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry ex on ex.DefaultVaultID = a.ArchivePointID
--where archiveddate > dateadd("hh", -24, getdate ())
where s.archiveddate between '1990-05-01' and '2011-07-31' and ex.MbxDisplayName = 'Mike Smith'
group by ex.MbxDisplayName, left (convert (varchar, s.archiveddate,20),14)
order by "Archived Date" desc

Rich_W's picture

Thank you Sir works very good....