Exchange 2007 Top N Public Folders by Message Count

Microsoft.Exchange2007.Report.Mailbox.MSExchangeDatabase.TopPublicFolderMessageCount (LinkedReport)

This report shows the mailbox sizes of the top N Public Folders (default 100) in the selected Exchange 2007 Public Folder databases. One chart is displayed with the size of the top N Public Folders over time for all provided databases.

Knowledge Base article:

Summary

This report shows the size of the top N (default 100) Public Folder sizes in terms of message count of the selected Exchange Mailbox Servers.

Description:

The report shows the Public Folder sizes in terms of number of messages of the top N Public Folders (default 100) in the selected Exchange 2007 Mailbox Servers. One chart is displayed with the average message count of the top N Public Folders over the interval selected.

Parameters:

Date/Time Selection: allows defining a time period for the report with relative or fixed dates

Business hours: Allows defining one business hours time range and the weekdays it applies to. If business hours are defined this report only reports within this range.

Histogram: Allows selecting the values used for the x-axis of the report.

-	Daily by hours
-	For the chosen time range the x-axis will be one day.
-	Every x-axis unit is an hour.
-	To be able to show this histogram the values for the same hour are averaged.
-	Weekly by weekdays
-	One week is the time range of the x-axis.
-	Every unit is a weekday.
-	Monthly by days
-	One month is the x-axis time range.
-	Every unit is a numeric day of the month
-	Yearly by month
-	A year is the time range of the x-axis.
-	Every unit is a month.

Default is no (which is a historical chart)

3D Chart: Allows choosing if the report is shown in a flat or a 3D image.

Object List:

This report expects objects of type Exchange 2007 Public Folder Database.

It is also possible to use the "Add Group" button an provide a group or list of Exchange 2007 servers. The report will then display the Top N Public Folders in terms of message count for all Public Folder databases hosted on those servers.

Element properties:

Base	Microsoft.SystemCenter.DataWarehouse.Report.PerformanceTopInstance
Target	Microsoft.Exchange2007.Component.Database.PublicFolder
Accessibility	Internal
Visible	True

Source Code:

<LinkedReport ID="Microsoft.Exchange2007.Report.Mailbox.MSExchangeDatabase.TopPublicFolderMessageCount" Accessibility="Internal" Base="Report!Microsoft.SystemCenter.DataWarehouse.Report.PerformanceTopInstance" Visible="true" Target="ExLibrary!Microsoft.Exchange2007.Component.Database.PublicFolder">

  <ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="2">

    <Controls>

      <Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker" columnSpan="1">

        <ReportParameters>

          <ReportParameter name="TimeZone" binding="TimeZone">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TimeZone</Prompt>

          </ReportParameter>

          <ReportParameter name="TimeZoneName" binding="TimeZoneName"/>

          <ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>

          <ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.StartDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>

          <ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>

          <ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>

          <ReportParameter name="EndDate_BaseValue" binding="EndDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.EndDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>

          <ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>

        </ReportParameters>

      </Control>

      <Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.MonitoringObjectXmlPicker" columnSpan="1" rowSpan="2">

        <ReportParameters>

          <ReportParameter name="ObjectList">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.ObjectList</Prompt>

          </ReportParameter>

          <ReportParameter name="ManagementGroupId" binding="GroupList"/>

        </ReportParameters>

        <Properties>

          <Property name="TypeFilter">

            <Value>Microsoft.Exchange2007.Component.Database.PublicFolder</Value>

          </Property>

        </Properties>

      </Control>

      <Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.NumericUpDown" columnSpan="1" rowSpan="2">

        <ReportParameters>

          <ReportParameter name="TopCount">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TopAlgorithmParameter</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

    </Controls>

  </ParameterBlock>

  <Parameters>

    <Parameter Name="RuleId">

      <Value>$MPElement[Name="ExMailbox!Microsoft.Exchange2007.Mailbox.MSExchangeDatabase.TopPublicFolderMessageCount"]$</Value>

    </Parameter>

    <Parameter Name="TopCount">

      <Value>100</Value>

    </Parameter>

  </Parameters>

</LinkedReport>