Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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

Created: 08 Oct 2012 • Updated: 08 Oct 2012 | 2 comments
This issue has been solved. See solution.

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

Comments 2 CommentsJump to latest comment

Jeff Shotton's picture

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

Jeff Shotton

Principal Consultant

Adept-tec Ltd

Website: here

SOLUTION