How to connect to your Archive Manager Database and create a Task to report on your data in the Archive Manager Database.
Setting Connections to Archive Manager:
1. Navigate to the Archive Manager node, right-click and select Connect.
2. Enter the name of the server that hosts the Archive Manager database.
3.Click elispis button beside the Archive Manager SQL Connection string box. The Data Link Properties dialog is displayed. On this dialog, you define the OLE provider type for the data and also specify the user account that is to be used to directly access the Archive Manager database for real-time reports.
4. Select Microsoft OLE Provider for SQL Server as the type data to which you are connecting.
5. Click Next.
6. Enter the server name for the Archive Manager SQL server.
7. Click Use a specific user name and password and enter a user name and password for an account that has full SQL administrator rights on the Archive Manager database server. The account that is used to connect to the Archive Manager SQL database must have the following database role memberships:
• public
• db_datareader
8. Click Select the database on the server and select the Archive Manager SQL database name.
9. Click OK.
10. If you want, you can change the value for the default Archive Mailbox Quota.
This value is used by the Archive Mailboxes Over Quota report to identify mailboxes that exceed the value that is specified
here.
11. Click OK.
To create an Archive Manager gathering task
1. Expand the Archive Manager node and select a server.
2. Right-click and select Create Task.
3. In the Template box, select Archive Manager Data and click Next.
4. Specify the date range for the data to be gathered:
• To gather the most recent data, select Most Recent and enter the number of days back that data should be gathered.
• To gather data within a specified date range, select Custom and select the start and end dates for the range.
5. Ensure that the task execution server that appears is the server on which the Archive Manager task processor is installed and click Next.
6. Specify a schedule for the gathering task and click Next. MessageStats provides two types of schedules: schedules that run
once at a specific date and time, and schedules that repeat for a defined period (such as daily, weekly, or monthly).
7. Verify the logging level for the task logs and click Next.
8. Specify the account under which the gathering task is to run and click Next.
9. Click Finish to save the gathering task.
Now you can either wait for it to run on its schedule or you can Right click on the Task and select now. I will run it now to make sure that it runs successfully.
As you can see it finished successfully. Now you are ready to start reporting on your Archive Manager enviroment.
