EV journal archiving rates by Exchange mailbox or archive
Hi All
I need to get journal archiving rates between X and Y dates, by Exchange mailbox, or archive, or journal tasks.
I found a number of SQL queries queries relating to this, but not quit one that works. This is close:
https://www-secure.symantec.com/connect/forums/need-sql-query#comment-7199911
but only works for mailbox archiving tasks, not journaling tasks.
Does anyone have any sample queries?
thanks!
Ok, this will give you a rate by hour for last 7days
SELECT ex.MbxDisplayName, "Archived Date" = left (convert (varchar, archiveddate,20),14), count(*) as 'Number of Items', sum (Convert(bigint,itemsize))/1024 as 'Size'
FROM Saveset s
Join Archivepoint a on a.ArchivePointIdentity =s.ArchivePointIdentity
Join EnterpriseVaultDirectory.dbo.RetentionCategoryEntry rc on rc.RetentionCategoryIdentity = s.RetentionCategoryIdentity
Join EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry ex on ex.DefaultVaultID = a.ArchivePointID
WHERE ArchivedDate > dateadd("dd", -7, getdate ())
GROUP BY ArchivePointID,s.ArchivePointIdentity, left(convert (varchar, archiveddate,20),14), ex.MbxDisplayName
ORDER BY "Archived Date" DESCThis will give you a daily archive rate for last 30 days
SELECT ex.MbxDisplayName, "Archived Date" = left (convert (varchar, archiveddate,20),10), count(*) as 'Number of Items', sum (Convert(bigint,itemsize))/1024 as 'Size'
FROM Saveset s
Join Archivepoint a on a.ArchivePointIdentity =s.ArchivePointIdentity
Join EnterpriseVaultDirectory.dbo.RetentionCategoryEntry rc on rc.RetentionCategoryIdentity = s.RetentionCategoryIdentity
Join EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry ex on ex.DefaultVaultID = a.ArchivePointID
WHERE ArchivedDate > dateadd("dd", -30, getdate ())
GROUP BY ArchivePointID,s.ArchivePointIdentity, left(convert (varchar, archiveddate,20),10), ex.MbxDisplayName
ORDER BY "Archived Date" DESCYou can change the WHERE clause and use a date range in either of these.