11-15-2011 01:10 AM
Hello all, especially SQL guru's..,
I am asked if I can get the size of an archive when the items are older than 1 year, 3 years and 5 years. This relates to the possibility that I need to export archives to pst's, which will be imported in a seperate Exchange environment.
In other words, they want to know for Archive A:
What is the current size? I used usage.asp to get this.
What is the size when exporting items older than 1 year, older than 3 years, older than 5 years?
I found a query I thought might help, but I am not sure. That query is below:
SELECT A.ArchiveName, COUNT(S.IdTransaction) AS ArchivedItemCount, SUM(S.ItemSize/1024) AS ArchivedItemSize
FROM EnterpriseVaultDirectory.dbo.Archive A,
EnterpriseVaultDirectory.dbo.Root R,
linkedserver.mailstoredatabase.dbo.ArchivePoint AP,
linkedserver.mailstoredatabase.dbo.Saveset S
WHERE
(A.ArchiveName = archivename' )
AND S.ArchivePointIdentity = AP.ArchivePointIdentity
AND AP.ArchivePointId = R.VaultEntryID
AND R.RootIdentity = A.RootIdentity
AND S.ArchivedDate > dateAdd("m",-1,getDate())
AND S.ArchivedDate < getDate()
GROUP BY A.ArchiveName
As far as I see, this will give me the size of archived items for the period 'today until today minus 1 month)
Does anyone know how to get it so the S.archiveddate is < 12 months?
Is that simply only using AND S.ArchivedDate < dateAdd("m",-12,getDate()),
or is it something else?
Thanks!
Gertjan
Solved! Go to Solution.
11-15-2011 02:20 AM
11-15-2011 02:20 AM
11-15-2011 04:17 AM
Hi Gertjan,
It sounds like something TransVault Migrator can do out of the box whilst gathering, then automate the migration of the mails that fit the age policy directly to the exchange target mailbox / archive with a full audit trail and no copying PSTs. You may even be working on a site with TransVault already installed...
Regards,
Andrew
11-15-2011 04:48 AM
Hello Andrew,
True in both ways. However, customer is reluctant to pay for the tv-license, and claims exporting from ev is 'cheaper'. More time consuming but cheaper...
Thanks anyway!
11-15-2011 06:28 AM
Thanks for the feedback Gertjan! If they change their mind please let me know.
regards,
Andrew
11-15-2011 06:44 AM
Archive Shuttle would be cheaper than TVS? :)