Exchange Mailbox Archive Task Report is a really great feature to understand the archiving status. But, the bad part of this feature is no notifications and you must check every server individually.
We created some scripts which can import all reports to SQL server. So you can get notified and easily find archive reports with SQL scripts or SQL reporting.
Please share your comments to improve this script.
This script is just compatible with EV11, EV11.0.1 on Windows 2008R2SP1 and Windows 2012, 2012R2
(I hope someday Symantec directly imports these reports to SQL and we don’t need to use this script)
You’ll need below software;
On SQL Server
Open SQL management studio
You are ready to run scripts!
Run order will be;
Now, you have many options to create fancy SQL queries! You can create notifications, SQL reporting and historical archiving reports.
I'm planning to share some helpfully SQL queries soon.