Public Folder Data to HTML

The more I work with PowerShell the more impressed I am with how useful of a tool it is to manage Exchange. In this blog I want to illustrate how easy it is to pull Public Folder data from your Exchange environment and export that data into a HTML format.  I think in every environment I have ever worked in or supported, Public Folders have grown out of control. This causes organizations to have to back up and replicate old and irrelevant data. Most administrators ignore cleaning up Public Folder because it is a headache to determine which Public Folders are still needed and which Public Folders can be removed. I have put together a PowerShell script that will comb all the Public Folders in your environment and report back some key attributes to help administrators keep a close eye on Public Folder size, date modified and date created. In a future post I will provided some successful steps I have used in the past to cleanup Public Folders but, for now we will look at getting information from Public Folders.

There are four tables created with this script and I will discuss each table. Another cool feature is each column is sortable to easily determine size or sort by name.

Note: To be able to use the sortable feature you will need to download the JS script form this website, http://www.kryogenix.org/code/browser/sorttable/.

Note: Some of these reports will only work with Exchange 2007 Public Folders

The first table shows the date and time when the script was run.

The second table shows Public Folder statistics. The script will filter the folders by the last time they were modified. In this example, we used the date 1/1/2008 as our reference point. Any Public Folders that were last modified before 1/1/2008 will be placed in the Over the last modified date table.  In this table we are sorting on the Total Item Size column.

The third table shows Public Folder statistics. Any Public Folders that where last modified after 1/1/2008 will be placed in the Under the last modified date table.  In this table we are sorting on the Total Item Size column.

The last table will show Public Folder information. This table will work with any version of Exchange. Here we are sorting on the Issue Warning Quota column.

The script can be found here.

Happy Exchanging!!!!