10-03-2017 04:32 PM
Hi all.
Is it possible to pull journalling statistics and break it down per domain?
@xx.domain1.com
@xx.domain2.com
Etc?
EV 11, DA 11. Exchange 2010
Solved! Go to Solution.
10-05-2017 12:30 AM
Hello,
I use a Powershell script to get the data per Vault Store. I am not sure how to get it by archive, you might need to add a where statement. In the attached txt, change $SQLServer and $SQLCatalog as indicated. In the 'select' statement there is somewhere ">dateadd(""dd"", -7, getdate"
The -7 inidicates the number of days it needs to be calculated. Change this to 31 for a month.
the output file has the name of the Vault Store, plus the date/time it was run. Copy paste this in an excel for sorting etc. Be advised that the last row is for items being archived today, so ignore that.
if you take the 'select' line, you can run that from within SQL if you want.
10-04-2017 02:03 AM
What excatly do you want to see within the statistics?
10-04-2017 04:37 PM
Journal rate.. How much data /weekly/monthly per domain is being journaled.
10-05-2017 12:30 AM
Hello,
I use a Powershell script to get the data per Vault Store. I am not sure how to get it by archive, you might need to add a where statement. In the attached txt, change $SQLServer and $SQLCatalog as indicated. In the 'select' statement there is somewhere ">dateadd(""dd"", -7, getdate"
The -7 inidicates the number of days it needs to be calculated. Change this to 31 for a month.
the output file has the name of the Vault Store, plus the date/time it was run. Copy paste this in an excel for sorting etc. Be advised that the last row is for items being archived today, so ignore that.
if you take the 'select' line, you can run that from within SQL if you want.