02-09-2012 06:28 AM
Hi All
Can someone tell me the easiest and quickest way to check if an EV9 Exchange archiving activity has run over night and how much data was archived?
I don't have EV Reporting Services and so am looking for a log file or something similar
I get logs generated daily called 'MovedItemsUpdateSummary<servername><date>.txt' which have some detail but not as much as I would have expected for a full archive run.
This file is located in ..\Enterprise Vault\Reports\Exchange mailbox Archiving\ Is this the oly log file generated?
In the same directory I get a log file called EV_ARCHIVING_<servername>_<date&time>.TXT which contains a lot more info but I don't get regularly (the last one was about 6 weeks ago) - What is this log file and when\why is it generated?
Is there a better and easier way to get some confidence that the nightly archiving activity has run and an idea of the amount of data processed?
Thanks
Keir
Solved! Go to Solution.
02-09-2012 06:36 AM
The EV_ARCHIVING_<servername>_<date&time>.TXT is a report generated when you run the archive task in report mode.
Since you don't have reporting you could look at the usage.asp http://evserver/enterprisevault/usage.asp or run a sql query manually.
something like this:
select"Archived Date" = left (convert (varchar, archiveddate,20),10),"Daily Rate" = count (*),"Size" = sum (itemsize)from saveset
where archiveddate > dateadd("hh", -24, getdate ())
group by left(convert (varchar, archiveddate,20),10)
order by "Archived Date" Desc
I also share another sql on this post: https://www-secure.symantec.com/connect/forums/mailbox-archive-rate
02-09-2012 06:36 AM
The EV_ARCHIVING_<servername>_<date&time>.TXT is a report generated when you run the archive task in report mode.
Since you don't have reporting you could look at the usage.asp http://evserver/enterprisevault/usage.asp or run a sql query manually.
something like this:
select"Archived Date" = left (convert (varchar, archiveddate,20),10),"Daily Rate" = count (*),"Size" = sum (itemsize)from saveset
where archiveddate > dateadd("hh", -24, getdate ())
group by left(convert (varchar, archiveddate,20),10)
order by "Archived Date" Desc
I also share another sql on this post: https://www-secure.symantec.com/connect/forums/mailbox-archive-rate
02-09-2012 08:08 AM
Many thanks Tony! Certainly see a use for this in our environment also (we've no reporting going either, unfort)