cancel
Showing results for 
Search instead for 
Did you mean: 

Reporting

Sue_Moss
Level 3
Is there a way to get an annual usage report for a specified year?
4 REPLIES 4

Jason_Szeto
Level 6
Not built into the product. If you were handy with SQL you could probably write a simple query. Of course if you're just doing journaling, you could just create new vaults each year and just do a usage on that vault.

Michael_Bilsbor
Level 6
Accredited
Hi,

You can run this query via SQL query analyser and it'd show you how many items have been archived against each archive in the last year.

select ArchiveName,count(*) as 'ItemsArchived' from
enterprisevaultdirectory.dbo.root,enterprisevaultdirectory.dbo.archive
,archivepoint ,saveset where archiveddate >getdate()-365 and
saveset.archivepointidentity = archivepoint.archivepointidentity and
enterprisevaultdirectory.dbo.root.vaultentryid = archivepoint.archivepointid
and
enterprisevaultdirectory.dbo.root.rootidentity=enterprisevaultdirectory.dbo.archive.rootidentity
group by archivename
order by archivename desc

If you just want something like how many items have been archived in the last year the query will be

select count(*) from saveset where archiveddate>getdate()-365

Sue_Moss
Level 3
Many Thanks! I'm not a SQL person, but this helps a lot ...

David_Messeng1
Level 6
You can get size as well I think. I use it to set quotas (work out how much PST data we migrated and then add a few hundred Mb more). You can sub-divide by retention category as well if you want. Remember PST reports sizes that bear little resemblence to reality -- must've been coded by a bloke :) -- so EV always records PST migrated data as being much bigger than it really is.