MessageStats 7.8 - Report Pack for Exchange Online User Guide

Chat now with support

Selecting the Task Template Specifying Activity Date Range (for Exchange Online Activity) Specifying the Task Execution Server Scheduling the Task Enabling Task Logging Specifying Credentials for a Task

Editing Tasks Exchange Online Gathering Tasks

Setting Task Default Properties

Configuring Task Default Properties

Changing Task Credentials Changing the Schedule for a Task Enabling Task Logging Setting Task Retry Attempts About the Default Configuration

Managing your Database

About Database Management Maintaining your Database

Defragmenting the Database Reindexing the Database Tables

Configuring Data Aging for Office 365 Data Clearing the Database

Using the Reports Console

Introducing the Reports Viewing the Exchange Online Reports Types of Exchange Online Reports Editing Reports

Using the Edit Button

Using Quick Filters Changing Grouping Options

Configuring Report Subscriptions

Creating and Changing Report Subscriptions

Exchange Online Report Descriptions

Introducing the Exchange Online Reports Tenants Report Descriptions User Report Descriptions Mailbox Report Descriptions Domain Report Descriptions Mail Contacts Report Descriptions Traffic Usage Overview Top Internet Domain Users Inactive Groups by Group Top Contacts Users Group Access by Group At A Glance Distribution of Message Size by Mailboxes

Report Filter Definitions About us

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

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen

Bitte w&auml;hlen Sie Ihr Produkt aus:

Damit wir Ihnen besser helfen können, geben Sie den Grund Ihres Chats an:

Empfohlene Lösungen für Ihr 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

Bitte wählen Sie Ihr Produkt aus: