1. Home
  2. Docs
  3. Public Folder Analysis To...
  4. User Guide
  5. Main Window
  6. Reports Section

Reports Section

The Reports section contains many views that can show the collected data in different ways. Use the report views to identify large folders, or ones that are very old, for example. Review the following elements for more detail

Report Generator
Report Instance
Report Views
This view will list all of the folders that were collected by the report generator. Metadata for each folder is shown such as the size, item count, and last modified date. There are many data elements for each folder, too many for this summary. Click the link below to scroll down to the Folder View detail section for more information.

Jump to Folder View
This view shows all accounts [users or groups] that have been assigned with any amount of permission to folders, including NONE. For each account, the list of related folders can also be reviewed.

Jump to Permissions View
This view will show all of the accounts that have either sent to, or created items in one or more folders. The display name and email address of each sender/author is available as well as the list of related folders for each.

Jump to Senders View
The Item Types view will list item types found across the folders collected by the report generator.
Item types are defined by a text value in Exchange, such as IPM.Appointment, which indicates the type of data contained by the item.
Since the item type is only a simple text value, it is possible to have very many different types and subtypes. It is up to an application developer to choose the item type to store and use.
Do not be surprised to see item types that are unfamiliar.

Jump to Item Types view
The attachment types view will list the file extensions and MIME types of all attachments found by the report generator as it enumerated items. An attachment in an Exchange item can be hidden or visible. Hidden attachments are often found as in-line pictures in html message bodies. As such, ‘hidden’ in this context only means whether or not the attachment shows in a mail client as a “save-able” item, not necessarily whether it is viewable.
For each attachment type, the list of folders containing items with the given type can be viewed.

Jump to Attachment Types view
The Body Patterns view will list all the body match patterns configured in the report generator, and for each one will show the folders that have matching item bodies.

Jump to Body Patterns view
The Subject Patterns view will list all the subject match patterns configured in the report generator, and for each one will show the folders that have matching item subjects.

Jump to Subject Patterns view

Folders View

The Folders View is the primary view for a report. This view will list all folders discovered during a report generation session. There are a large number of data elements that can be collected per folder, and the availability of various data elements is control by settings in the report generator configuration.
For example, if the option to collect permission information is not enabled in the report configuration, the data will be empty [or zero, for numeric info] for those related elements.

The Folders View also provides access to the Folder Live View window, which can connect to an Exchange Public Folder directly and render the items of the folder for inspection or manipulation. Click here to jump to the Folder Live View documentation page.

Folder List
Filter to Selected Folder
Highlight Large Item Counts
Highlight Large Folders Sizes
Folder Search
Folder Live View
Export Grid to CSV
Folder Types
Made for viewing
Data, and more data!
Show/Hide Folder Detail

Folder Metadata Columns

Folder PathThe full folder path. Folder names in the path that contain back\slashes will be doubled; ex: \Sales\Win\\Lost
Folder NameThe folder’s display name.
Note: folders with a back\slash or apost’rophe will be shown with red text to highlight them. These folder names are problematic for PowerShell operations and should be changed.
Item CountThe number of items found in the folder at the time the report was generated.
Folder Size 4The size of the folder as reported from the Exchange server.
Created 1The date/time that the public folder was created. This value is shown as UTC time.
Last Modified 1The date/time the folder was last modified.
Note: this value only changes if items are added/removed or if the folder is renamed or permissions changed. The value does NOT change if items in the folder are modified.
Last Item Modified 1 2The date/time of the most recently modified item in the folder.
OwnersThe number of accounts that have the Owner role permission on the folder.
Total Permissions 3The total number of accounts that have any permission (including NONE) on the folder.
Senders CountThe number of unique senders/authors found on items in this folder.
SubfoldersThe number of child folders of this folder.
Subtree CountThe number of child folders for the entire subtree of this folder.
Mail EnabledA True/False value indicating if the folder was mail-enabled.
Primary SMTPIf the folder is mail-enabled, the primary email address of the folder.
Visible in GALA True/False value indicating if the mail-enabled folder was also visible in the Global Address List.
Very Small Items 4The number of items that have a size of 100kb or less
Small Items 4The number of items in the folder that have a size between 100kb and 500kb.
Midsized Items 4The number of items that have a size between 500kb and 2MB.
Large Items 4The number of items in the folder that have a size between 2MB and 10MB.
Very Large Items 4The number of items that have a size between 10MB and 35MB.
Extremely Large Items 4The number of items in the folder that have a size greater than 35MB.
Analysis Date 1The date/time the folder was analyzed.
Modified last 24 hours 5The number of items with a modified time within the last 24 hours.
Modified last 7 days 5The number of items with a modified time within the last 7 days
Modified last 30 days 5The number of items with a modified time within the last 30 days.
Modified last 60 days 5The number of items with a modified time within the last 60 days.
Modified last 90 days 5The number of items with a modified time within the last 90 days.
Modified last 6 months 5The number of items with a modified time within the last 6 months.
Modified last 12 months 5The number of items with a modified time within the last 12 months.
Modified last 60 days 5The number of items with a modified time within the last 60 days.
Modified after 1 year 5The number of items with a modified time older than one year.
Modified after 2 years 5The number of items with a modified time older than two years.
Modified after 3 years 5The number of items with a modified time older than three years.
Modified after 5 years 5The number of items with a modified time older than five years.
Has Subject PatternsTrue if the folder contains any items that match any of the Subject Patterns configured in the report generator.
Has Body PatternsTrue if the folder contains any items that match any of the Body Patterns configured in the report generator.

1 Date values are shown as UTC. Nearly all date values stored in Exchange are stored as UTC values.

2 The modified time of a folder only changes when data is added or removed from the folder. Modifications to existing items does not change the modified time of a folder.

3 The total permissions count includes Owners and non-owners. This count, however, does not include the DEFAULT and ANONYMOUS accounts.

4 Data sizes in Exchange 2010 and earlier do not report values in the same way as Office 365 and Exchange 2013 and later. Sizes of the same items in later versions of Exchange will report as 30 to 40% larger, and sometimes as much as 10x larger if the item is very small (1-2kb). As such, a folder in Exchange 2010 reporting as 9GB can easily exceed the 10GB limit of later versions of Exchange.

5 Note that the date ranges are based on the date/time the report was generated. For example, “Last 24 hours” equates to “the 24 hours before the report was started”.

Highlight Large Item Counts

This feature will color the certain cells in the Item Count column based on the quantity of items for each folder.
Folders with large item counts – regardless of whether it is a Public Folder or Mailbox Folder – are very taxing on an Exchange server, and can be frustrating or disruptive to end users. Consider that the exchange server, for each request to “open” a folder, must load in to memory the entire list of items of that folder. While the list would only be of a few key columns (EntryID, index number, etc), it must hold this in-memory list for the entire duration that the folder is “open”, regardless of whether a user or application is actively doing anything. In the case of a public folder, if 10 users open the same folder, that becomes 10 separate in-memory “lists” held by the server. When item counts become very large (in excess of 100,000 items) the amount of RAM needed to hold this list starts to grow non-linearly, and often ends up with some of the list in swap-file cache.

For end-users, when a folder has more than about 15,000 items, they tend to see a delay in the display of the list of items. Consider that for public folders, shared mailboxes, and shared folders, these connections are not backed by Outlook’s cached mode (aka OST file) implementation. These connections are live to the Exchange server each time. If the physical distance between the end-user and the Exchange server is more than a few dozen miles, the network latency between the client and server exacerbates the delay. This is even more prevalent with Office 365, which typically shows a 20-50ms latency. With Office 365, a folder with 15,000 items can take several seconds to render the list of items for use. The delay is long enough for most user to think that Outlook is broken. This is in contrast to Exchange on-premises and a user being at a LAN connection to the Exchange server.

The Highlight Large Item Counts feature will highlight cells with large items counts with the following criteria:

  • < 5,000: No color
  • 5,000 – 14,999: Khaki
  • 15,000 – 49,999: Gold
  • 50,000 – 99,999: Orange
  • >= 100,000: Maroon

Highlight Large Folder Sizes

Nearly identical to the coloring of the topic above [Highlight Large Item Counts], this feature will color the cells of the Folder Size column when values are greater than 1GB.

Unlike the concern mentioned above with server memory and end-user experiences, folder sizes are important to review and remediate due to support limits that exist in Exchange 2013, 2016, 2019 and Office 365. In these later versions of Exchange, Microsoft has set a “support limit” of 10GB per folder. This limit only refers to the total item size of given single folder, not the size of the entire subtree. Additionally, note that the “support” limit does not mean that a folder cannot exceed 10GB, however it is highly discouraged to allow this; if issues do arise, Microsoft has refused to provide support for such cases.

Public Folder Limits

Refer to these Microsoft articles
for official detail about limits:
Limits for public folders [Ex2019]
Limits for Public Folders [Ex2016]
Limits for Public Folders [Ex2013]

Note that Office 365 uses Exchange 2019
and inherits the limits of that version

The coloring criteria for folder sizes are as follows:

  • < 1GB: No Color
  • 1GB to 7GB: Khaki
  • 7GB to 10GB: Orange
  • > 10GB: Maroon

Exchange 2013 and later can view/manage the per-folder size limit in two ways:

  • Organization Level
  • Folder Level
Get-/Set-OrganizationConfig
# The 'Get-' command will retrieve the 2 values shown.
# New installs of Exchange and new Office 365 tenants
# default to 2GB and 1.7GB for the 2 values.
# they can be adjusted to any value, but the support limit is 10GB (and the warning then becomes 9GB).
PS:> Get-OrganizationConfig | Select DefaultPublicFolderProhibitPostQuota, DefaultPublicFolderIssueWarningQuota
# This command will set the 2 values to the support limit,
# with the warning limit at 10% less than max.
PS:> Set-OrganizationConfig -DefaultPublicFolderProhibitPostQuota 10GB -DefaultPublicFolderIssueWarningQuota 9GB
Get-/Set-PublicFolder
# The 'Get-' command will retrieve the prohibit and 
# warning limits for a specific public folder.
PS:> Get-PublicFolder -Identity \Folder\Path\To\Inspect | Select ProhibitPostQuota, IssueWarningQuota
# This will set the prohibit and warning limits
# On a specific public folder, which overrides
# the Organizational level settings.
PS:> Set-PublicFolder -Identity \Folder\Path\To\Change -ProhibitPostQuota 10GB -IssueWarningQuota 9GB

This feature allows for filtering the list of folders by a search pattern. Clicking the button will toggle the search feature, and if toggled off will clear the current search and list all folders.

Filter Options

The search filter feature uses Microsoft .NET’s Regular Expression pattern matching engine, comparing each folder path to the given pattern.
For simple searches, no wild-card characters are necessary. For example, filtering the view to all folders with the text ‘Sales’ in the folder path can be entered solely as: Sales.

Here are some common search filter examples:

PatternResult
SalesAll folder paths containing the text ‘Sales’
\\\Retail\Hardware\Bolts\Sales
\\\Retail\West Coast Sales\Widgets\Miniatures
\\\Operations\Staff\Salesmen\Field Calendar
\\Sales$All folder paths that end with \Sales
^\\\\\\Operations\\All folder paths that start with \\\Operations\
^\\\\\\Operations\\|^\\\\\\RetailAll folder paths that start with \\\Operations\ OR \\\Retail

Selected Folder Detail Panel

When a folder is selected in the list view, the    button will open with further detail about the folder, as seen below.

Folder Size Breakdown
Item Dates Breakdown
Copy Detail
Per-Folder Detail

Permissions View

The Permissions View provides access to all of the accounts found to have rights on folders, including accounts found on folders with zero rights (NONE). For each account, the list of folders can also be viewed.

Display Name
Email Address
X500 Address
Is Group
Sender Occurrences
Permission Occurrences
Owner Occurrences
Folder Rights
Permission Role
Copy to clipboard
Row Count

Senders View

The Senders View shows all email accounts that have sent to, or have been the author of items in folders.

Display Name
Email Address
X500
Is Group
Sender Occurrences
Occurrences

Item Types View

The Item Types view shows all the item types found in folders. Item type examples are IPM.Appointment (calendar items), IPM.Note (messages), and IPM.Task (task items). There are many standard and non-standard item types and the value is stored in Exchange as a simple text value. As such, there can be an infinite number of item types and 3rd party applications can use custom types in order to identify them.

Item Type List
Folder List

Attachment Types View

The Attachment Types view shows all the attachment file types found across all items in folders.
Note that an attachment can be hidden or visible. This setting determines whether the attached data can be saved as a file by an end user. Commonly, hidden attachments are used by mail clients as inline graphics in rich-text or html-based email bodies. As such, “hidden” does not necessarily mean “not visible”. Furthermore, it is then possible to see the same file extension twice in the report. This indicates that some number of items had the attachment file type hidden, while some other number of items had the file type as a visible, saveable file.

Attachment File Types List

Body Patterns View

The Body Patterns View shows the configured pattern matching value from the generator. For each pattern, the number of folders with at least one item matching the pattern is shown, and selecting a pattern will show the list of folders that have those matching items.

Ignore Case

Subject Patterns View

The Subject Patterns View shows the configured pattern matching value from the generator. For each pattern, the number of folders with at least one item matching the pattern is shown, and selecting a pattern will show the list of folders that have those matching items.

Ignore Case

Articles

How can we help?