Chat now with support
Chat with Support

MessageStats 7.8.1 - Report Pack for Outlook Web Access (OWA) User Guide

Managing Your Database

•
About Database Management
•
Configuring an OWA Aging Task
•
Deleting OWA Report Data

About Database Management

During the installation of the MessageStats Report Pack for OWA, additional tables are added to the MessageStats database to store OWA-specific data. MessageStats allows you to manage the storage of OWA data.

In MessageStats, the database management functionality is extended to include database management functions specific to OWA 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.
 
* 
IMPORTANT: 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.

For detailed information about using the Database Management tool, see the MessageStats Administrator Guide.

Configuring an OWA Aging Task

You can use the Data Aging function to delete the historical data from the OWA tables in the MessageStats database. Use the Outlook Web Access Configuration option under the Data Aging node to define a regularly scheduled task that deletes old data.

To define a data aging task
1
Expand the Database Management | Data Aging nodes in the treeview.
2
Click the Outlook Web Access Configuration node.
3
Select Delete aged data.
4
Select the Age Statistics check box and select the age (in number of days) at which data is to be deleted.
5
Select a Schedule Type (daily, weekly, or monthly) to indicate how often you want to delete the data.
6
Enter the Start Date and Start Time information.
7
Select the Limit Job Execution Time check box if you want to limit the time duration for an aging job, and enter an end time.
8
Enter the recurrence interval:
•
Number of days between jobs for Daily schedules
•
Day of the week for Weekly schedules.
•
Day of the month for Monthly schedules.
9
Click Deploy.

Data Aging Job History

After you create an aging 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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating