09-09-2009 09:48 AM
Solved! Go to Solution.
09-09-2009 11:49 AM
09-09-2009 10:30 AM
09-09-2009 10:37 AM
09-09-2009 10:44 AM
09-09-2009 10:52 AM
09-09-2009 11:40 AM
Select * from dbo.Saveset
Where IdDateTime < '1/1/2008 00:00:00'
Or in the case of Tony's Script
EXEC sp_MSForEachdb 'IF ''?'' NOT IN (''msdb'', ''tempdb'', ''model'', ''EnterpriseVaultDirectory'', ''EnterpriseVaultAudit'')
SELECT ex.MbxDisplayName,
a.archiveditems as Count, (a.archiveditemsSize/1024) as 'Size'
FROM Saveset s
Join Archivepoint a on a.ArchivePointIdentity =s.ArchivePointIdentity
Join EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry ex on ex.DefaultVaultID = a.ArchivePointID
WHERE s.IdDateTime > GetDate()-365
GROUP BY ex.MbxDisplayName, a.archiveditems, a.archiveditemssize'
09-09-2009 11:49 AM
09-09-2009 11:53 AM
09-09-2009 11:55 AM
09-09-2009 12:09 PM