MessageStats 7.8 - Report Pack for Exchange Online User Guide

Reindexing the Database Tables

Managing your Database > Maintaining your Database > Reindexing the Database Tables

Reindexing the Database Tables

MessageStats provides functionality to defragment your MessagesStats database and to reindex the database tables. You can increase performance by decreasing the amount of time it takes the MessageStats task processors to write information to the database.

The reindex operation applies to all the core MessageStats and report pack database tables.

Configuring Data Aging for Office 365 Data

Managing your Database > Configuring Data Aging for Office 365 Data

Configuring Data Aging for Office 365 Data

Two stored procedures are provided with the MessageStats database that can be used for aging the the Office 365 data collected by the report pack gatherings:

•

dbo.PR_BPOS_GetConnections

•

dbo.PR_BPOS_AgeStatsBefore

Use the following steps to age the Exchange Online report pack data from the MessageStats database.

To age Office 365 data from the MessageStats database

1

Connect to the MessageStats database using SQL Server Management Studio.

2

To obtain the connection GUIDs for the Office 365 connect, run the PR_BPOS_GetConnections stored procedure:

EXEC MessageStats.dbo.PR_BPOS_GetConnections

3

To age the data, specify the connection GUID of the data to be aged and enter the first day for the data to be kept in the PR_BPOS_AgeStatsBefore stored procedure.

In our example, the following command will delete any Office 365 data for Malamute Inc before January 4, 1995:

EXEC MessageStats.dbo.PR_BPOS_AgeStatsBefore '1995-01-04','4E804D91-81A5-E311-9072-415645000030'

When completed, a result set is returned with the cutoff date and the number of rows deleted:

Clearing the Database

Managing your Database > Clearing the Database

Clearing the Database

The Clear Database function allows you to delete all the information in your database. The Clear Database function also provides the option of deleting the gathering schedules that you have established.

The Clear Database function cannot be reversed. If you may need any of the information you intend to delete, create a backup of the database.

To delete all data from the database

1

Expand the Database Management | Deleting Data nodes in the treeview.

2

Select the Clear Database node.

3

Select the Include Schedules check box if you want to delete your defined gathering schedules.

4

Click Clear Database.

5

Verify that you want to delete the data.

Using the Reports Console

•

Introducing the Reports

•

Viewing the Exchange Online Reports

•

Types of Exchange Online Reports

•

Editing Reports

•

Configuring Report Subscriptions

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

MessageStats 7.8 - Report Pack for Exchange Online User Guide

Reindexing the Database Tables

Reindexing the Database Tables

Configuring Data Aging for Office 365 Data

Configuring Data Aging for Office 365 Data

To age Office 365 data from the MessageStats database

Clearing the Database

Clearing the Database

To delete all data from the database

Using the Reports Console