EV 8.0.4 - how to find how many items been archived for a particular user during a specific period?

[ia01]

Hi,

In EV 8.0.4 - how to find how many items been archived for a particular user during a specific period? Is there any SQL query we can use?

Many Thanks

[Jeff_Shotton · Accepted solution]

for a particular user....yes you can do this. You need to run this against the vault store where the user is archived to:

select COUNT(*), SUM(SS.ItemSize)/1024 'size in MB' from saveset SS
inner join ArchivePoint AP on SS.ArchivePointIdentity = AP.Archivepointidentity
inner join EnterpriseVaultDirectory.dbo.ArchiveView EVDAV on AP.ArchivePointId = EVDAV.VaultEntryId
where EVDAV.ArchiveName = 'Test1'
and SS.ArchivedDate > '2009-10-08'
and SS.ArchivedDate < '2012-12-08'

where EVDAV.ArchiveName = the name of the archive, and the two date parameters are the range.

Regards,

Jeff

[ia01]

Great Thanks Jeff