04-09-2013 11:59 PM
Hello all, and especially SQL guru's
We found that for some reason one of our Vaultstores has grown with 12GB last night, where the average growth is about 2GB a night.
Is it possible to use a SQL query to find which archive(s) have a huge amount of data added in the last 24 to 48 hour? This to try to find if a user is doing something (ie manually importing a large PST, someone archiving lots of holidaypics) or if something is wrong.
Thanks.
Gertjan
Solved! Go to Solution.
04-10-2013 01:13 AM
04-10-2013 12:03 AM
I'd suggest travelling back in time to the weekend, where you would be upgrading to EV 10.0.3, and then you'd be able to use the mailbox archiving report to see if it was that which had caused the extra influx of data ;)
04-10-2013 01:13 AM
04-10-2013 03:53 AM
Gertjan,
Not sure if this query is helpful but see if this helps
select ArchiveName,count(*) as 'ItemsArchived' from
enterprisevaultdirectory.dbo.root,enterprisevaultdirectory.dbo.archive
,archivepoint ,saveset where archiveddate >'2012-04-09 00:00:00.000' and archiveddate < '2013-04-09 23:59:00.000'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
04-10-2013 07:25 AM
Thanks JW