지금 지원 담당자와 채팅
지원 담당자와 채팅

MessageStats 7.8 - Report Pack for Exchange Online User Guide

About the Exchange Online (Office 365) Report Pack Preparing for Installation Connecting and configuring for Exchange Online Creating Gathering Tasks Setting Task Default Properties Managing your Database Using the Reports Console Exchange Online Report Descriptions Report Filter Definitions About us

Reindexing the Database Tables

Previous Next


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

Previous Next


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

Previous Next


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

Previous Next


•
Introducing the Reports
•
Viewing the Exchange Online Reports
•
Types of Exchange Online Reports
•
Editing Reports
•
Configuring Report Subscriptions
관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택