Chat now with support
Chat with Support

Enterprise Reporter 3.2.2 - Report Manager User Guide

Quest Enterprise Reporter Report Manager Introducing the Report Manager Running and Scheduling Reports Creating and Editing Reports Troubleshooting Issues with Enterprise Reporter

Exchange Reports

The following table outlines the Exchange reports included in the Report Library. If you are a report user, your administrator may have made some of these reports available in Published Reports. For each report, you must specify the organizations on which to report.

You can configure Enterprise Reporter to save your favorite parameter values within each report type. Your favorites can then be loaded when running reports that contain these parameters. For more information, see how To enter a parameter value .

 

Distribution Groups

 

Distribution Group Membership by Account

Shows all mail-enabled distribution groups to which the selected accounts belong. Groups include security and distribution group types. Membership filters are displayed for dynamic groups. Contains parameters to select the organizations and the accounts to be included in the report.

Distribution Group Details

Shows the detailed information of mail-enabled groups for the selected organizations. Mail-enabled groups include security and distribution group types. Membership filter information is shown when dynamic distribution groups are selected. Contains parameters to select the organizations, the distribution groups, or the type of distribution groups (static, dynamic, or unified) to be included in the report.

Distribution Groups and Members

Shows all accounts that are members of the selected mail-enabled distribution groups. Groups include security and distribution group types. If you choose to include nested groups, membership of the groups is displayed. Contains parameters to select the organizations and distribution groups to be included in the report. Also contains a parameter to include nested group memberships and options for how they are displayed in the report.

Exchange

 

Exchange Organization Overview

Shows a high-level summary of the information in your Exchange organization. You can drill to view detailed reports for each category in the report:

Note: This report includes system public folder information.

Mailboxes

 

Exchange Mailboxes Overview

Shows a high-level summary of the number of mailboxes per server in your Exchange organizations. A bar chart displays the top 10 servers that contain the most mailboxes. You can drill down through the server name to view the Exchange Server Details report. Contains a hidden parameter to include, by default, only Exchange servers running the Mailbox server role.

Mailbox Delegates

Shows the mailboxes for the selected delegates.Contains parameters to select the organizations and mailbox delegates to be included in the report. Contains a hidden parameter to include, by default, only Exchange servers running the Mailbox server role.

Mailbox Details

Shows detailed mailbox information for the selected servers. Contains parameters to select the organizations, servers, mailbox stores, and mailboxes to be included in the report. Contains a hidden parameter to include, by default, only Exchange servers running the Mailbox server role.

Mailbox Folder Details

Shows the mailbox folder information for the selected servers. Contains parameters to select the organizations, servers, mailbox stores, and mailboxes to be included in the report.

Mailboxes with Delegates

Shows the delegates for the selected mailboxes. Contains parameters to select the organizations, servers, and mailboxes to be included in the report. Contains a hidden parameter to include, by default, only Exchange servers running the Mailbox server role.

Permissions

 

Mailbox Folder Permissions

Shows the mailbox folder permissions for the selected servers. Contains parameters to select the organizations, servers, mailbox stores, and mailboxes to be included in the report.

Mailbox Permissions

Shows the mailbox permissions for the selected servers. Contains parameters to select the organizations, servers, mailboxes, and types of permissions to be included in the report. Contains a hidden parameter to include, by default, only Exchange servers running the Mailbox server role.

Mailbox Permissions for Account

Shows the mailbox permissions for an account, including permissions derived through group membership. Contains parameters to select the account, organizations, servers, mailboxes, permission inheritance, and types of permissions. Contains a hidden parameter to include, by default, only Exchange servers running the Mailbox server role.

Mailbox Permissions with Membership

Shows the permissions for the selected servers and mailboxes. If you choose to include nested groups, membership of the groups is displayed. Contains parameters to select organizations, servers, mailboxes, permission inheritance, and types of permissions. Also contains a parameter to include nested group memberships and options for how they are displayed in the report. Contains a hidden parameter to include, by default, only Exchange servers running the Mailbox server role.

Public Folder Permissions

Shows all folder permissions for the selected servers and public folders. Contains parameters to select the organizations, servers, public folders, accounts, and types of permissions to be included in the report. Also includes the options to exclude specific public folders and to filter inherited or explicit permissions. Contains hidden parameters to include, by default, only Exchange servers running the Mailbox server role, and to exclude, by default, system public folder information.

Public Folder Permissions for Account

Shows folder permissions, including permissions derived through group membership, for the selected account and the selected folders. Contains parameters to select the account, organizations, servers, public folders, permission inheritance, and types of permissions. Contains hidden parameters to include, by default, only Exchange servers running the Mailbox server role, and to exclude, by default, system public folder information.

Public Folder Permissions with Membership

Shows the folder permissions for the selected servers and folders. If you choose to include nested groups, membership of the groups is displayed. Contains parameters to select the organizations, servers, public folders, permission inheritance, and types of permissions. Also contains a parameter to include nested group memberships and options for how they are displayed in the report. Contains hidden parameters to include, by default, only Exchange servers running the Mailbox server role, and to exclude, by default, system public folder information.

Public Folders

 

Exchange Public Folders Overview

Shows a high-level summary of the number of public folders per server in your Exchange organizations. You can drill down through the server names to view detailed reports. Contains a hidden parameter to include, by default, only Exchange servers running the Mailbox server role. Note: This report includes system public folder information.

Public Folder Details

Shows public folder details for the selected servers. Contains parameters to select the organizations, servers, and public folders to be included in the report. Contains hidden parameters to include, by default, only Exchange servers running the Mailbox server role, and to exclude, by default, system public folder information.

Servers

 

Exchange Server Details

Shows Exchange server details. Includes computer attributes and volume information if computer discoveries have been completed for the selected servers. Contains parameters to select the organizations and servers to be included in the report. Note: The section containing the physical computer information and matching pie chart is only available if Computer discovery collections that include the selected servers have been completed.

Users and Contacts

 

Mail Contacts

Shows the details for mail contacts in the selected organizations. Contains parameters to select the organizations and mail contacts to be included in the report.

Mail-Enabled Users

Shows the details for mail-enabled users in the selected organizations. Contains parameters to select the organizations and mail-enabled users to be included in the report.

 

File Storage Analysis Reports

The following table outlines the File Storage Analysis reports included in Enterprise Reporter. If you are a report user, your administrator may have made some of these reports available in Published Reports.

These reports use information collected from discoveries running over time to assist administrators with data life cycle management by providing storage assessments that can be used for storage planning and pre-migration assessments. Detailed reports provide historical information about resources such as servers, shares, volumes, folders, files, home directories and users.

The File Storage Analysis category displays a default Category Report in the report pane. For more information on setting the parameters of this report, see Running Category Reports .

You can configure Enterprise Reporter to save your favorite parameter values within each report type. Your favorites can then be loaded when running reports that contain these parameters. For more information, see how To enter a parameter value .

See also:

See also:

Some File Storage Analysis reports include an estimated number of Days Until Critical Capacity. This estimate is calculated using the following formulae:

Where:

The calculation is restricted to the discovery runs in the last 1 year. If the last discovery run is more than a year ago, No data found is displayed in the report.

 

File Storage Analysis Overview

Shows a high-level summary of storage information for your network and highlights immediate storage needs to be addressed. The overview is based on all completed file storage analysis discoveries. You can drill down through the server name, categories, extensions and users to view more detailed reports. Contains a parameter to specify the percentage of used space that indicates critical capacity for this report.

Capacity Planning

 

Capacity Planning

Shows storage growth and highlights any areas of critical capacity across your enterprise.

NOTE: Growth trends are based on historical collections. If multiple collections are not available for comparison, growth projections are not available.

This report is useful for evaluating your enterprise when capacity planning and for assessing servers during migration projects. It serves as an integral part of storage administration activities. You can drill down through the server name and the user name to view more detailed reports. A line graph displays the total enterprise growth by displaying the total amount of used space for all servers.

Server Capacity

Shows server capacity information. You can specify the percentage of used space that determines if a server is reaching critical capacity. You can drill down through the server name to view the Server Details report.

NOTE: Estimated Days Until Critical Capacity indicates how many days it is expected to take for the server to reach the value set as critical capacity (a default of 80%) based on the current analysis of data increase per day. This report highlights servers that may be running out of disk space so that action can be taken. You can also use this report during server consolidation project planning to determine which servers to migrate first. A bar chart displays the top 10 servers sorted by days until critical capacity and indicates the percentage of used and free disk space.

Server Details

Shows server details with volume and share usage information for the selected servers. You can drill down through the logical disk or the share name to view detailed reports. This report is useful for determining your consolidation approach and for capacity planning. A pie chart displays the percentage of used and free disk space. Contains a parameter to select the server to be included in this report.

Server Growth

Shows server growth information for the selected server. Growth details are sorted by dates of discovery runs.

NOTE: Note: Growth trends are based on historical collections. If multiple collections are not available for comparison, growth projections are not available.

This report allows you to track the percentage of used space over time for servers and provides a snapshot of used and available space for each time the discovery was run. This report is useful for evaluating servers when planning migration projects and serves as an integral part of server administration. Contains parameters to select the server and the number of weeks/months/years to be included in the report.

Server Summary by Domain

Shows the total, used, and free disk space on each server in the selected domains. Servers are grouped by domain and sorted by server name. You can drill down through the server name to view the Server Details report. The Server Summary by Domain report is of critical importance when planning your consolidation projects since it provides the data volume information you can use to determine the scope of a consolidation project. Contains a parameter to select the domain to be included in the report.

Top Volumes

Shows top volumes sorted by used space. You can drill down through the server name and the logical disk name to view more detailed reports. A bar chart helps you visually compare the used space on the volumes. Contains a parameter to select the number of volumes to included in the report.

Volume Capacity

Shows volume capacity information. You can specify the percentage of used space that is used to determine if a volume is reaching critical capacity. You can drill down through the server name and the logical disk name to view more detailed reports. Identifying the volumes can help you create capacity projections, determine critical volumes for file cleanup or archiving activities, or plan an approach for server consolidation projects. A bar chart indicates the top 10 volumes sorted by days until critical capacity and indicates the percentage of used and free space. Contains a parameter to specify the percentage of used space that indicates critical capacity for the report.

Volume Details

Shows the volume details for the selected servers. You can also drill down through the logical disk to view a file summary for the volume. This report helps with ongoing capacity planning such as identifying volumes where disk space optimizations (cleanup, compression, or file offloading) are required. You can also use this report during server consolidation project planning to determine which servers and volumes to migrate first. A pie chart displays the percentage of used and free disk space. Contains parameters to select the servers and volumes to be included in the report.

Files and Folders

 

File Categories

Shows details on the file categories that are used to group files in Enterprise Reporter. Lists the default types of files contained in each category. A file category contains various types of files or other file categories. Contains a parameter to select the file category to be included in the report.

File Category Details

Shows the file extensions that are included in the selected category on the selected servers. Categories are sorted by size. You can drill down through a file extension to view the File Information by Extension report. This report is useful for determining exactly what type of files are using storage space when you plan for future storage allocation. A bar chart displays the top 10 file extensions in the category based on size. Contains parameters to select the server and the file category to be included in the report.

File Summary

Shows file summary information for the selected servers and volumes. You can drill down through the section titles to view more detailed reports. This report is useful for estimating migration schedules since the time needed to migrate data in large files is significantly less than the time needed to migrate the same amount of data in small files. A bar chart displays the number of files in each file size grouping. Another bar chart displays the actual space consumed by the files in each file size grouping. Contains the parameters to select the server and the volume to be included in the report.

Files by Category

Shows files grouped into pre-defined categories that are sorted by size. You can drill down through the file category name to view a detailed report of files in the category. This report is useful for identifying the files that you want to remove or migrate to a different storage location. A bar chart displays the categories sorted by size. Contains parameters to select the server and the category to be included in the report.

Folder Categories

Shows details on the folder categories that are used to group folders in Enterprise Reporter. Lists the default folder paths contained in each category and describes the types of files typically found in the folders.

Folders by Category

Shows folders grouped in pre-defined categories that are sorted by used space. This report is useful for identifying groups of folders that you want to remove or migrate to a different storage location. A bar chart displays the amount of used space per category. Contains parameters to select the server and the folder category to be included in the report.

Storage Cleanup

Shows storage areas across your enterprise where you can potentially reclaim space through data cleanup or by migrating files to different storage locations. The report is based on all completed server discoveries. You can also drill down through the server name to view more detailed reports. Note: This information is only available if NTFS discoveries have been completed with the duplicate file collection option enabled. This report is useful for assessing your current storage needs prior to migration and as a part of regular data cleanup operations. A pie chart displays the total amount of space recommended for cleanup on all servers.

Top File Extensions

Shows top file extensions sorted by size. You can drill down through any file extension to view the File Information by Extension report. A bar chart displays up to the top 10 file extensions sorted by size. Contains a parameter to select the number of file extensions to be included in the report.

Home Directories

 

Home Directory Details

Shows home directory details for the selected servers. This report can be used for planning home directory updates by identifying the users who are consuming space on the server. Contains the parameters to select the servers and the accounts to be included in the report.

Home Directory Summary

Shows home directory summary information. The report is based on all completed server discoveries. You can drill down through the server name or the number of home directories to view more detailed reports. A bar chart displays the total amount of space used by home directories on each server.

Top Home Directories

Shows top home directories sorted by size. You can drill down through the server name to view the Server Details report. This report can be used to prepare for home directory migrations, to maintain storage quotas, and for storage management activities. A bar chart displays the top home directories sorted by size. Contains a parameter to select the number of home directories to be included in the report.

Shares

 

Share Details

Shows share details for the selected servers. This report can be used during server consolidation project planning to determine which server shares to migrate first. Contains parameters to select the servers and the shares to be included in the report.

Share File Details

Shows file details for the selected shares. This report is valuable when planning for data reorganization or preparing for storage consolidation.

NOTE: Share file detail information is only available if Computer and NTFS permission discovery collections that include the selected shares have been completed.

Contains parameters to select the server and the share to be included in the report.

Share Summary

Shows share summary information. The report is based on all completed server discoveries. You can drill down through the server name or the number of shares to view more detailed reports. This report is useful for ongoing share management as well as preparing for share migration in server consolidation projects. A bar chart displays the total amount of space used by shares on each server.

Top Shares

Shows top shares sorted by size. You can drill down through the server name and the share name to view more detailed reports. This report is useful for ongoing data assessment, for planning server consolidation projects, or for determining if specific users are outside acceptable levels of disk space usage. A bar chart displays the top 10 shares sorted by size. Contains a parameter to select the number of shares to include in the report.

Users

 

Top Users

Shows the top users using the most space. This report is useful for analyzing user storage needs and for quota management activities. A bar chart displays up to the top 10 users sorted by size. Contains a parameter to select the number of users to be included in the report.

User Growth

Shows user storage growth over time. User growth details are sorted by dates of discovery runs.

NOTE: Growth trends are based on historical collections. If multiple collections are not available for comparison, growth projections are not available.

This report is useful for identifying users with the fastest growing storage needs over time. The report provides a snapshot of the amount of storage used by the user each time the discovery was run. Use the report to evaluate user storage needs when planning consolidation projects and as an integral part of user storage management activities. A line graph shows the size of storage over time for the user on the server. Contains parameters to select the user, server, and number of weeks/months/years to be included in the report.

File Categories

The following table outlines the file extensions that are grouped into each file category.

Against Policy

Files Categories from this table that violate the enterprise file storage policy.

Media Files

Wasted Space Files

All Media Files

File Categories from this table that contain image, audio, video, or internet information.

Graphic Files

Internet Files

Movie Files

Sound Files

Application Files

Files that contain executables and assemblies.

.app

.bat

.cgi

.com

.exe

.jar

.pif

.vb

.wsf

Compressed Files

Files that are compressed using ZIP compression.

.7z

.rar

.zip

.zipx

Data Files

File types used to identify formatted data.

.csv

.dat

.gbr

.sdf

.tar

.vcf

.xml

Database Files

File types used to identify database queries, data, and log files.

.accdb

.db

.dbf

.mdb

.pdb

.sql

Disk Image Files

File types used to identify virtual disks and disk images.

.bin

.cue

.iso

.mdf

.vcd

Document Files

File types created by the Microsoft Office® suite of programs.

.doc

.docx

.indd

.mdb

.odb

.odt

.pages

.pct

.pdf

.pps

.ppt

.pptx

.rtf

.tex

.txt

.wpd

.wps

.xls

.xlsx

Email Files

File types used to identify messages and indexes created by various email programs.

.eml

.idx

.mbx

.msg

.pab

.pst

.wab

Graphic Files

File types produced by graphic software tools, digital photo software, and software that captures documents as electronic images.

.ai

.al

.al3

.al4

.al5

.bmp

.eps

.flm

.gif

.icd

.jpe

.jpg

.pcd

.pct

.pcx

.pdd

.pdf

.pdp

.pic

.png

.pnp

.ps

.psd

.pspimage

.pxr

.raw

.rle

.sct

.swf

.tga

.thm

.tif

.tiff

.vda

.vst

Movie Files

File types used to identify digital animation files, interactive audio/visual files, and media player files.

.asf

.asx

.avi

.m1v

.m4v

.mov

.mp2

.mp4

.mpa

.mpe

.mpeg

.mpg

.qt

.ram

.rm

.rmx

.rt

.smi

.swf

.viv

.vob

.wmv

Paging Files

Files used to define virtual memory settings for the server.

hiberfil.sys

pagefile.sys

Sound Files

Files types used to identify digital and audio files.

.afic

.agp

.aif

.aiff

.au

.iff

.jpa

.m3u

.m4a

.mid

.mp3

.mp4

.mpa

.pps

.ra

.snd

.wav

.wax

.wma

.wvx

System Files

File types used to identify by operating system files such as driver files and image files.

.cab

.cpl

.cur

.dll

.dmp

.drv

.ico

.lnk

.sys

Temporary Files

File types used to identify temporary files.

.bak

.dmp

.log

.tmp

~$*.*

Unknown File Extensions

File extensions that are not categorized.

 

 

Wasted Space

File Categories from this table that may be needlessly using storage space.

Temporary Files

Movie Files

Web Files

File types that identify web site files such as html files, cascading style sheet files, browser cookie files, and graphic files.

.asp

.aspx

.cer

.cfm

.csr

.css

.htm

.html

.js

.jsp

.mht

.php

.rss

.xhtml

Folder Categories

The following table outlines the folder paths that are grouped into each folder category.

 

Applications

Folders typically used to store application program files and settings.

\Applications

\Program Files

\Program Files (x86)

Exchange Data

Folders that contain Microsoft Exchange Server messaging data files.

\Exchsrvr

\Program Files\Exchsrvr

\Program Files\Microsoft\Exchange Server

Home Directories

Folders that contain user home directories.

\Home

\Users

Operating System

Folders that contain Microsoft Windows operating system files.

\Windows

\WINNT

\WINNT351

\WINNT4

\WINNT40

\WINNT5

Oracle Database Data

Folders that contain Oracle database data files.

\OraData

\OraNT

\OraWin95

Recycle Bin

Folder that temporarily stores deleted files and folders before they are permanently erased.

\$Recycle.Bin

Share Point Portal

Folders that contain Microsoft SharePoint Portal Server document management data files.

\Program Files\Common Files\Microsfot Shared\MSSearch

 

\Program Files\Common Files\Microsoft Shared\Web Storage System

 

\Program Files\SharePoint Portal Server

SQL Server

Folders that contain Microsft SQL Server files such as database engine, client components, and data files.

 

\MSSQL

\MSSQL2000

\MSSQL6

\MSSQL7

\Program Files\Microsoft SQL Server

SQL Server Database

Folders that contain Microsoft SQL Server data files.

\MSSQL\Data

\MSSQL2000\Data

\MSSQL6\Data

\MSSQL7\Data

 

\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

 

\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA

 

\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA

 

\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA

 

\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA

 

\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA

Temporary Data

Folders that are used to store temporary files.

\Temp

\Windows\Temp

\WINNT\Temp

Web

Folders that contain files used in web sites.

\InetPub

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating