How to get a size of Public Folder?
Hi, I am looking to retreive size for each Public Folder(including subfolders) and export that list to say a txt or excel. PDFAVAdmin does what i need except the "Total Calculated Size of Items" returns only the size of the root Public Folder size, it excludes the sub folders. Any way of doing this? Thanks alot
December 2nd, 2009 9:34pm

Using Exchange 2007/2010?Powershell: http://technet.microsoft.com/en-us/library/aa998663.aspx Get-PublicFolderStatistics
Free Windows Admin Tool Kit Click here and download it now
December 2nd, 2009 10:40pm

My Exchange is 2003. Is there anything similar for 2003? Thanks,
December 2nd, 2009 11:00pm

Sure pfdavadmin doesnt work?The pfdavadmin.doc implies you can get all that data: Content Report The Content Report option is similar to Export Properties because it writes information to a tab-delimited file. However, a Content Report iterates through all the items in each folder to gather information that cannot be read from the properties of the folder itself. You can create a report for all the public folders or any single public folder and its subfolders with information such as the following: Folder PathThe path of the folder. PR_DISPLAY_NAMEThe display name of the folder. PR_CONTENT_COUNTThe item count as shown on the folder properties. PR_MESSAGE_SIZE_EXTENDEDThe size of the folder as shown on folder properties. Works for values both under and above 5 GBs. Total Number Of ItemsThe number of objects that PFDAVAdmin found in the folder. Oldest Creation DateThe oldest creation date of any item in the folder. Oldest Modification DateThe oldest modification date of any item in the folder. Newest Creation DateThe most recent creation date of any item in the folder. Newest Modification DateThe most recent modification date of any item in the folder. Largest Item SizeThe largest item size in the folder. Total Calculated Size Of ItemsThe total of all individual item sizes added together.
Free Windows Admin Tool Kit Click here and download it now
December 2nd, 2009 11:02pm

Hi Andy, Here is what i get: PR_DISPLAY_NAME PR_MESSAGE_SIZE_EXTENDED Total Calculated Size Of Items Main projects Folder 38064 38064 Subfolder1 1833883734 1833883734 Subfolder2 14920801 14920801 Subfolder3 2774835 2774835 Subfolder4 19405040 19405040 Subfolder5 378455765 378455765 Subfolder6 1222210597 1222210597 Subfolder7 182053201 182053201 Subfolder8 23857463 23857463 Subfolder9 20081162 20081162
December 2nd, 2009 11:19pm

You can use ESM to query to the size of public folders, right-click Public Folder Instances node, and then select Export List. You can export the list in CSV type and open it via ExcelJames Luo TechNet Subscriber Support (http://technet.microsoft.com/en-us/subscriptions/ms788697.aspx) If you have any feedback on our support, please contact tngfb@microsoft.com
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2009 9:15am

Thanks for the reply, Unfortunately, ESM query reports exactly the same sizes as i posted above. It does not include the sub-folders. I mean i could sum the subfolrder sizes in excel and get my desired result that way but when you have 500+ folders, that's a lot of parsing work.
December 3rd, 2009 9:43am

To include the subfolder, please use outlook: 1. Launch outlook 2. Right-click the root node of public folders, and select Properties 3. In the General tab, click Folder Size button, theres Total size (including subfolders) field Well, this workaround is required certain manually operation as well, but, it should better than the last one James Luo TechNet Subscriber Support (http://technet.microsoft.com/en-us/subscriptions/ms788697.aspx) If you have any feedback on our support, please contact tngfb@microsoft.com
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2009 10:06am

Hi James, Yah, this is what i ended up using. Took a while to go through 500 folders!!!!!:) (what a waste of time) Such a simple task, it only seems logical to expect something like that to exist but i guess developers did not see that usable, ah well. Exchange 2007 seems to have that covered. Thanks for all your helps guys
December 3rd, 2009 9:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics