*
Quick Links|Home|Worldwide
Microsoft*
Search Microsoft.com for:
Download Center 

Search Advanced Search

SQL Server 2000 Report Pack for Microsoft Exchange

Brief Description
A set of 13 Microsoft Exchange-based reports with a sample database that lets you easily visualize and author managed reports for e-mail administration.

On This Page

Quick Details
File Name:SQLReportPackExchange.msi
Version:1.0
Date Published:6/24/2005
Language:English
Download Size:1.3 MB
Estimated Download Time: 4 min 56K

Overview

The SQL Server 2000 Report Pack for Microsoft Exchange is a set of 13 Microsoft SQL Server 2000 Reporting Services reports that work with a Microsoft Exchange sample reporting database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

This Report Pack includes the following reports:

  • Current - All Mailboxes (By Folder)
    Shows folder statistics over all folders. Tip: Be on the lookout for especially large mailboxes.
  • Current - Folder Tree Sizes (By User)
    Shows the folder tree and size of items contained within each folder of a specific user's folder. Drill down for breakdown. Tip: Find the largest folders and the largest items so you can free up space.
  • Folder Tree Sizes (All)
    Shows the folder tree and size of items contained within each folder for all user's folders since the last extraction. Drill down for breakdown. Tip: Find the largest folders and the largest items so you can free up space.
  • Outgoing - Sent E-mails for User (Plain Table)
    Compares the number of items found in users' Sent Items box. Tip: The highest send the most e-mail, which often correlates to the hardest workers.
  • Outgoing Sent E-mails for User (With Graph)
    Compares the number of items found in users' Sent Items box. Tip: The highest send the most email, which often correlates to the hardest workers.
  • Outgoing Sent E-mails for User (With Bar Chart)
    Compares the number of items found in users' Sent Items box. Drill down for breakdown. Tip: The highest send the most email, which often correlates to the hardest workers.
  • Outgoing - Busy Receivers of Our E-mail
    The top 50 people who were sent email from members of our organization.
  • Incoming - Received E-mails for User (By Date)
    Compares the number of items found in users' Sent Items box. Drill down for breakdown. Tip: The highest receive the most e-mail, they probably stress out the most.
  • Incoming - Busy Receivers of Incoming E-mail
    Shows how many emails were received into peoples' inbox.
  • Outgoing - By Keyword
    Examines the content of mail items to indicate which key phrases are being used by employees based on items in their Sent Items folders. Tip: Configure with your product names to see the e-mail activity by product.
  • Outgoing - Largest E-mail Senders
    Shows the people who sent e-mail with the largest sizes.
  • Extraction Log (All Records)
    Shows all of the Extraction Log records, including time to extract data from Exchange and store to the database for each user.
  • Extraction Log (Last Extraction)
    Shows the Extraction Log records for the most recent extraction, including time to extract data from Exchange and store to the database for each user.

Note: This software is licensed “as-is.” It is not supported, and you bear the risk of using it. Microsoft gives no express warranties, guarantees or conditions.

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000 Advanced Server; Windows 2000 Professional Edition ; Windows 2000 Server; Windows Server 2003; Windows XP Professional Edition

  • Microsoft SQL Server 2000 SP3a or later

  • Microsoft SQL Server 2000 Reporting Services SP1 or later

  • Microsoft Internet Explorer 6.0 or later

  • Microsoft Visual Studio .NET 2003 with Report Designer installed (optional)

  • Approximately 1.5 megabytes (MB) of available hard disk space to download the installation package

  • Approximately 6 MB of available hard disk space for the installed files in the target location

 Top of page

Instructions

  1. Download the file by clicking the Download link (above) and saving the file to your hard disk.

  2. Launch the SQLReportPackExchange.msi program file on your hard disk to start the setup program.

  3. Follow the instructions on the screen to complete the installation.

  4. Additional setup instructions are provided in the accompanying Readme file.


 Top of page

Additional Information

About the Author
SSW is the author of the SQL Server Report Pack for Microsoft Exchange. SSW also provides a commercial product called Exchange Reporter to help you efficiently analyze your organization's email usage. It captures all the Microsoft Exchange data into SQL Server using the SSW Exchange Extraction Service that integrates with the custom set of Reporting Services reports included. The service runs as a Windows service on the Exchange Server to seamlessly extract e-mail messages and mail folder statistics; from here different usages of Microsoft Exchange can be reported within the organization. For more information on SSW Exchange Reporter, visit the SSW website.

 Top of page

 Top of page

 Top of page


© 2006 Microsoft Corporation. All rights reserved. Terms of Use |Trademarks |Privacy Statement