Chat now with support
Chat mit Support

MessageStats 7.7.2 - Report Pack for Exchange ActiveSync User Guide

Managing your Database

During the installation of the MessageStats Report Pack for Exchange ActiveSync, additional tables are added to the MessageStats database in order to store Exchange ActiveSync-specific data. MessageStats allows you to manage the storage of ActiveSync server and Exchange ActiveSync users and devices data to prevent excessively rapid growth of the MessageStats database.

In MessageStats, database management functionality is extended to include database management functions specific to Exchange ActiveSync data. Using Database Management, you can delete obsolete information and fine-tune your database.

The Database Management tool provides the following functionality:

•
Database Aging. Use this to delete historical data.
•
Database Maintenance. Use this to defragment your database and reindex database tables.
•
Delete Data. Use this to delete object and report data.

Before you modify your database, ensure that no MessageStats consoles or task processors are currently writing information to the database. If you use Database Management while a MessageStats console is writing to the database, you risk corrupting your database.

To access the Database Management tool
•
Select Database Management from the treeview in the MessageStats console.

Configuring an Aging Task

You can use the Data Aging function to delete the historical data from the Exchange ActiveSync tables in the MessageStats database. Use the Exchange ActiveSync Configuration option under the Data Aging node to define the aging task.

To define a data aging task
1
Select Database Management | Data Aging | Exchange ActiveSync Configuration nodes in the treeview.
2
Select Delete aged data.
3
Select the Age Statistics (days) check box.
4
Enter the number of days you want to retain statistical data in your database.
5
Click Configure Job.
6
Select the Schedule tab.
7
Select Daily, Weekly, or Monthly to indicate how often you want to delete the data older than your retention definitions.
Depending on the schedule type that you select, the bottom box changes to an appropriate interval selector.
8
Enter the Start Date and Start Time information.
9
Click to select the Limit Job Execution Time box if you want to limit the time duration for an aging job, and enter an end time.
10
Enter an appropriate recurrence interval:
•
Enter the number of days between jobs for Daily schedules
•
Enter the day of the week for Weekly schedules.
•
Enter the day of the month for Monthly schedules.
11
Click Deploy.

Data Aging Job History

After you create a job, the interface changes to a three-tab format:

•
The Schedule tab contains the same content as the Create Job tab contained before a job was created.
•
The Properties tab describes the properties associated with the aging job, and is updated as new information becomes available.
•
The History tab contains a log of past aging jobs.

Logging the Aging Process

Because the aging process is performed by a service, progress is recorded in the log journal for all database management activities.

For more information about Database Aging, refer to the MessageStats Administrator Guide.

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen