09-29-2009 09:05 AM
09-30-2009 04:21 AM
09-30-2009 08:18 AM
09-30-2009 09:39 AM
10-07-2009 01:55 PM
10-12-2009 10:32 AM
SELECT VaultIdentity, ex.MbxDisplayName,rc.RetentionCategoryName, COUNT(s.RetentionCategoryIdentity) as Count1, SUM(s.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 MbxDisplayName LIKE 'Aaron Morris' AND NOT EXISTS ( SELECT 1 FROM JournalDelete JD with (nolock) WHERE JD.ArchivePointIdentity = S.ArchivePointIdentity AND JD.ItemSeqNo = S.IndexSeqNo AND JD.DeletionStatus = 0 )
11-02-2009 11:28 AM