Chat now with support
Chat with Support

Enterprise Reporter 3.5.1 - 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 Appendix: PowerShell cmdlets

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: 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

Hybrid Reports

The following table outlines the Hybrid 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.

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 .

 

Table 10. Hybrid Reports

Exchange Hybrid Migrated Mailbox Permissions with Membership

Shows the permissions for the mailboxes migrated to Microsoft 365 in an Exchange hybrid environment. If you choose to include nested groups, membership of the groups is displayed. Contains parameters to select the tenants, mailboxes, and mailbox types to be included in the report. Also includes the option to filter inherited or explicit permissions.

Exchange Hybrid Migrated Mailboxes

Shows mailboxes that have been migrated to Microsoft 365 in an Exchange hybrid environment. Contains parameters to select the tenants and mailboxes to be included in the report.

OneDrive and NTFS File and Folder Permissions for Account

Shows OneDrive and NTFS file and folder permissions for the selected synchronized domain account.

OneDrive and NTFS file and folder permissions are only available if the Azure Active Directory, OneDrive, and NTFS collections have been completed. Account information will only be available if synchronization is enabled between the OneDrive and On-premises environments at the time of collection.

Note: No wildcard support available.

Contains a parameter to select the synchronized domain account to be included in the report.

OneDrive and NTFS File and Folder Permissions for Account with Group Membership

Shows OneDrive and NTFS file and folder permissions for the selected synchronized domain account including permissions derived through group membership.

OneDrive and NTFS file and folder permissions are only available if the Azure Active Directory, OneDrive, and NTFS collections have been completed. Account information will only be available if synchronization is enabled between the OneDrive and On-premises environments at the time of collection.

Note: No wildcard support available.

Contains a parameter to select the synchronized domain account to be included in the report.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating