• Become a portal pro
• Download
• Print
• My Downloads ()

• Support
• Technical Documentation
• MessageStats 7.8.1
• MessageStats 7.8.1 - Reports User Guide

MessageStats 7.8.1 - Reports User Guide

Table of Contents  

Upgrading MessageStats Overview

MessageStats upgrade paths About task migration

Typical MessageStats Upgrade Scenarios

About SQL Security Permissions for Upgrading the Database Upgrading a Complete (Single Server) MessageStats Installation Upgrading a Distributed Installation with a Separate Database Server

1a. Upgrading the MessageStats Database on aSeparate Server 1b. Manually Upgrading the MessageStats Database on a Separate Server 2. Upgrading the MessageStats Reports and the MessageStats Server

Moving the MessageStats Database

Process to Move an Existing MessageStats Database

Backing Up the MessageStats Database Restoring the MessageStats Databaseon the Destination Server Setting Security on the New SQL Server Detaching the Database Moving the Database Files and Reattaching the Database Updating Connections to the New Server

Upgrading MessageStats After the Database is Moved

Moving and Upgrading MessageStats

About Moving a Complete MessageStats Installation

Moving a MessageStats Installation with No Installed Report Packs Moving MessageStats with at least One Installed Report Pack — No Upgrade Moving and Upgrading MessageStats with at least One Installed Report Pack

Moving Custom Reports and Report Subscriptions

Backing Up and Moving Custom and Saved Reports Backing Up and Restoring Report Subscriptions

Viewing, Creating, and Editing MessageStats Reports

Introducing MessageStats Reports

Types of Reports Report Graphs Report Fields

Using the Reports Console Using the Toolbar Buttons File Menu Commands

Sending Reports by Email Exporting Reports Setting Filter Defaults

Browsing Reports

Using the Treeview Using the Listview Using Linked Reports Viewing Report Information

Configuring Report Parts About MessageStats Reports Creating Custom Reports

Selecting a Data Source Selecting Fields Specifying the Filters to Apply Grouping the Data Specifying the Sort Order Selecting the Report Format Entering a Report Description Previewing the Report

Creating Custom Graphs

Using the MessageStats Graph Wizard Guidelines for Creating Bar Graphs Guidelines for Creating Pie Charts Guidelines for Creating XY Graphs

Editing Reports

Using the Edit Button

Using the Edit Button

Selecting Report Filters Using Quick Filters Using Save Report Settings Changing Grouping Options

Setting Security

Role-based Security File-System Based Security

Security Scenarios

Configuring Report Subscriptions

Creating and Changing Report Subscriptions

Scheduling the Subscription Service Sending the Subscription Selecting Reports for the Subscription Specifying the User Account Naming Subscriptions Changing the SMTP Mail Server or From Display Name

Performance Considerations for MessageStats Reports

Best Practices for reports

My Reports and Corporate Reports

Introduction to Corporate Exchange At A Glance About My Reports

My Exchange at a Glance

About Corporate Reports

Exchange Executive Summaries Reports

Introduction to Executive Summaries Reports

Prerequisites Executive Summary Report Descriptions

Exchange Organizations Reports

Introducing the Organizations Reports Subject Auditing Reporting Departmental Reporting Region Activity Reporting Organizational Traffic Reporting Organizational Storage Reporting

Exchange Server Reports

Introducing Server Reports About Server Activity Reports About Server Mail Traffic Reports About Delivery Times Reports About Message Sizes Reports About the Server Uptime Report

Exchange Content Analysis Reports

Introducing Content Analysis Reports About Mailbox Content Reports About Public Folder Content Reports About Mailbox Attachments Reports About Public Folder Attachments Reports

Exchange Mailboxes Reports

Introducing Mailbox Reports

Viewing Presence Information

About Size and Quotas Reports About Top Senders and Receivers Reports About Top Internet Senders and Receivers Reports About Mailbox Activity Reports About the Mailbox Profile About Mailbox Auditing Reports About Message Size Reports About Mailbox Security Reports

Exchange Mail Contacts Reports

Introducing the Mail Contacts Reports

Exchange Distribution Groups Reports

Introducing Distribution Group Reports

Exchange Public Folders Reports

Introducing the Public Folder Reports

Exchange Storage Reports

Introducing Storage Reports

Exchange Internet Reports

Introducing Internet Reports

About Top Internet Domain Reports About Top Internet Domain Users Reports About Internet Domain Auditing Reports About the Internal Namespace Distribution Report

Exchange Inventory Reports

Introducing Inventory and Chargeback Reports About Chargeback Reports

Chargeback Report Descriptions

About Inventory Reports

Inventory Report Descriptions

Migration Reports

About the Migration Reports

Inventory Reports Capacity & Storage Reports Unused Assets Reports Mailbox Migration Progress Reports

MessageStats Gathering Reports

Introducing MessageStats Gathering Reports

MessageStats Gathering Report Descriptions

Appendix A: How to Read the Reports

What is the Definition of Physical and Logical Messages?

Reports that Show Physical Message Counts Reports that Show Logical Message Counts

How Does MessageStats Determine Internal and External Messages?

Viewed from a Server Perspective Viewed from a Mailbox Perspective Other Factors to be Considered Internal and External Messages - Frequently Asked Questions

Differences Between Messages Submitted, Delivered, and Transferred In and Out

Sample Scenario: MessageStats Counts

Why Does the Date Filter Always Group Using UTC?

Report Filter Definitions

Lotus Notes Report Pack Filters

• Viewing Topics 61 - 64 of 163

×

Using the Edit Button

Editing Reports

You can modify both the configured MessageStats Reports and any custom reports that you create using edit and grouping functionality. You can edit reports in the following ways:

•	Using the Edit button on the report listview

•	Selecting filters before rendering a report

•	Using the Quick Filter Bar at the bottom of the report

•	Using Save Report Settings to retain the filters, sort and grouping options, and any other modifications that you have made to a report, to facilitate the creation of subsequent reports with the same settings.

•	Using the column headers on the reports to change grouping and sorting options

•	Using the Edit menu on the toolbar to launch the MessageStats Reports Wizard

The following table describes the extent of editing for each type:

 

Table 9. Editing Options for Reports.

Type	Description
Edit Button	Allows you to copy the report to a different destination folder, move the report to a different location, rename or delete the report, or edit the report description.
Filters	Allows you to restrict the report content to specific information before the report is rendered.
Quick Filter Bar	Allows you to change filter options and regenerate the report. For more information, see Using Quick Filters .
Column Header	Allows you to add or remove fields in the report, and change group and sort options. For more information, see Changing Grouping OptionsChanging Grouping Options .
Edit Menu	Opens the Web Report Wizard to allow you to customize or modify an existing report.

Using the Edit Button

An Edit button is located at the right side of each folder and report in the file-based model. The commands available on the Edit button differ depending on whether the Edit button is accessed from a folder or a report.

For folders, the following commands are available:

 

Table 10. Folder-Level Edit Options.

Command	Description
Copy To	Opens a dialog box for you to define the destination of the copied folder.
Move To	Opens a dialog box for you to define the destination of the moved folder. After the report is moved to the new location, the original is deleted.
Rename	Opens a dialog box for you to rename the selected folder.
Delete	Prompts you to verify that you want to delete the folder.
Edit Description	Opens a dialog box for you to edit the description of the folder.

For reports, the following commands are available:

 

Table 11. Report-Level Edit Options.

Command	Description
Copy To	Opens a dialog box for you to define the destination of the copied report.
Move To	Opens a dialog box for you to define the destination of the moved report. After the report is moved to the new location, the original is deleted.
Rename	Opens a dialog box for you to rename the selected report.
Delete	Prompts you to verify that you want to delete the report.
Modify Report	Opens the Web Report Wizard to allow you to make any changes to the selected report, and save your custom report.

Selecting Report Filters

When you select the report you want to view from the treeview, you can select filters before MessageStats renders the report. After the report is rendered, there are two ways to change the filter options:

•	Select the Show Filters bar at the beginning of the report to change multiple filters.

•	Use the Quick Filter bar at the bottom of the report to further select specific data within the resulting dataset.

If you want to save a report query with specific filters applied, select the Save Report Settings option.

To select filters for a report

1	Open the report you want to view.

2	Define a period for the report (if applicable).

3	Identify operands and criteria for the filters you want to use.

- OR -

Leave the default filter values.

4	Click Apply Filters.

To change filter settings

1	Click Show Filters at the beginning of the rendered report.

2	Delete the criteria from a filter option to remove the filter.

- OR -

Identify other operands and criteria for new filters you want to use.

3	Click Apply Filters.

Using Quick Filters

Each report can have a Quick Filter bar at the bottom of the page. This bar does not scroll with the report.

This section explains how to create a quick filter for a report. For details about the Information button, see Viewing Report Information .

When you are using the DateTime filters, time is based on UTC, not local time.

To use Quick Filters

1	Select a field from the list.

2	Select a parameter from the following list:

 

Table 12. Parameters available for the report quick filters.

Parameter	Available IN	Description
=	All	The field value equals the criteria value.
<>	All	The field value is not equal to the criteria value.
>	All	The field value is greater than the criteria value.
<	All	The field value is less than the criteria value.
<=	All	The field value is less than or equal to the criteria value.
>=	All	The field value is greater than or equal to the criteria value.
like	All	The field value is like the criteria value.
is NULL	All	There is no value for the criteria field.
is not NULL	All	There is any value except NULL for the criteria value.
between	All	The field value falls between the two criteria that you define.
is in	All	The field value is in the criteria that you define. When using the is in operator, you can multi-select in the Select a Value dialog box by holding down the CTRL key and clicking the items you want. The selected items appear in the edit box as a list separated by semi-colons.
not in	All	The field value is not in the criteria that you define.
last	Date, DateTime	This operator allows you to select a time interval in the form nn uu, where nn is a number and uu is a unit of time. (For example, Last 5 Weeks, Last 3 days, and so on). The time interval is based on the current time.
most recent	Date, DateTime	This operator queries the database for the most recent entry for the specified field and then uses that value to find all records with a matching value. The value depends on the content of the database and is independent of the current time. “Most recent” could potentially mean a time long past, and remain unchanged until the database is changed.
today	Date, DateTime	Today = from 12:00 AM to the current time.
yesterday	Date, DateTime	Yesterday = from 12:00 AM to 11:59 PM yesterday.
this week	Date, DateTime	Start = Sunday of current week, End = today.
last week	Date, DateTime	Start = Sunday of previous week, End = Saturday of previous week.
this month	Date, DateTime	Start = 1st day of current month, End = today.
last month	Date, DateTime	Start = 1st day of previous month, End = last day of previous month.
this quarter	Date, DateTime	Start = 1st day of current quarter, End = today.
last quarter	Date, DateTime	Start = 1st of previous quarter, End = last day of previous quarter.
Quarters start January 1, April 1, July 1, and October 1.
year to date	Date, DateTime	This operator selects records with dates from January 1 of the current year to the current date.
contains	Description	The field value contains the specified criteria.
does not contain	Description	The field value does not contain the specified criteria.
starts with	Description	The field value starts with the specified criteria.
ends with	Description	The field value ends with the specified criteria.
does not start with	Description	The field value does not start with the specified criteria.
does not end with	Description	The field value does not end with the specified criteria.

3	Define the filter criteria.

- OR -

Define both criteria if you have selected Between as your report parameter.

4

Click .

•  Previous
• Viewing Topics 61 - 64 of 163
• Next 

Search this document Search all documents for this product-version Search all documents for this product Search all documents

×

 Welcome to Quest Support

You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center