Exchange Server | Murat Bilici

"Empower your knowledge"

Posts Tagged 'reports'

How many items archived per mailbox for specified date

You can use the below script to find to daily(or between dates) archived items in a mailbox. Run it on your Vault Store DB. (You can change getdate()-14 to any number to change date range.) select ArchiveName,count(*) as ‘ItemsArchived’ from enterprisevaultdirectory.dbo.root,enterprisevaultdirectory.dbo.archive ,archivepoint ,saveset where archiveddate >getdate()-14 and saveset.archivepointidentity = archivepoint.archivepointidentity and enterprisevaultdirectory.dbo.root.vaultentryid = archivepoint.archivepointid and [...]

23 Şubat 2012 at 17:16 - Comments