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