Chat now with support
Chat mit Support

MessageStats 7.7.2 - Report Pack for Archive Manager User Guide

Setting Connections to Archive Manager

Setting Connections to Archive Manager

As part of the initial configuration for the report pack, you must set up a connection to any Archive Manager SQL database instances from which you want to retrieve data.

When you set up the initial connection to the Archive Manager SQL database, you specify a user account and password. The user account is required for those reports which require direct access the Archive Manager database. The account must have SQL administrator rights to the server that hosts the database.

To connect to an Archive Manager SQL database
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 ... beside the Archive Manager SQL Connection string box.
The Data Link Properties dialog is displayed.
On this dialog, you define the OLE DB driver 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 DB Driver 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
Select SQL Server Authentication in the drop-down list.
8
Enter a user name and password for an account that has full SQL administrator rights on the Archive Manager database server.
 
* 
NOTE: The account that is used to connect to the Archive Manager SQL database must have the following database role memberships:
•
public
•
db_datareader
9
Click Select the database and select the Archive Manager SQL database name.
 
* 
NOTE: SQL Authentication must be enabled on the server on which the Archive Manager report pack is installed and on the Archive Manager SQL server to which you are connecting.
10
Click OK.
a
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.

The Archive Manager servers to which you are connected are displayed under the Archive Manager treeview in the MessageStats console.

Changing Archive Manager Properties

If, after initial configuration, you need to modify the connection to an Archive Manager server instance, you can use the Archive Manager Server Properties page.

To access the Archive Manager Server property pages
1
Expand the Archive Manager node and select a server in the treeview.
2
Right-click and select Properties.
3
Select the tab for the properties page that you want.

Changing Archive Manager Server Properties

You can use the Archive Manager Server Properties tab to update the connection string for an Archive Manager database instance, or to change the mailbox quota that is set for Archive Manager reporting purposes.

For more information about the connection string settings for connecting to the Archive Manager database instance, see “Setting Connections to Archive Manager” on page 11.

About the Storage Quotas

The value that you specify in the Archive Mailbox Quota box is used in the Archive Mailboxes Over Quota report. The report lists the archived Exchange mailboxes for which the amount of stored data is greater than the storage quota that you specified for the Archive Manager server.

Viewing Task Membership for a Server

The Task Membership tab shows the gathering tasks to which the Archive Manager server belongs. You can review this list to determine whether you are collecting all the information that you require to produce meaningful reports.

The Task Membership page provides basic information about the task, such as the user credentials that are used to run the task, the regular schedule for the task, and the next scheduled run of the task (in both local and UTC time).

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen