Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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. 

Rich

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

SOLUTION
Rich_W's picture

Thank you Sir works very good....