{"id":57,"date":"2011-08-12T13:48:16","date_gmt":"2011-08-12T11:48:16","guid":{"rendered":"http:\/\/exchangetimes.wordpress.com\/?p=57"},"modified":"2011-08-12T13:48:16","modified_gmt":"2011-08-12T11:48:16","slug":"export-mailbox-sizes-per-server-to-csv","status":"publish","type":"post","link":"http:\/\/exchangetimes.net\/?p=57","title":{"rendered":"Export Mailbox sizes per server to csv (Exchange 2003)"},"content":{"rendered":"

If you need a rather quick way to export all the mailbox sizes on a particular server then the below link is for you.<\/p>\n

Download the script, run it\u00a0by opening\u00a0the command prompt and type cscript MSX_GetMailboxSize.vbs thenameoftheserverhostingthemailboxes>filenameyouwanttochoose.csv<\/strong><\/p>\n

Remember to add the export location to the above command if you want to save the export to a particular path ie: cscript MSX_GetMailboxSize.vbs servername>e:reports<\/strong>server1.csv<\/p>\n

Open the csv export with Excel after you ran the script. You can then manipulate the contents to the format you need as all mailbox data will be there.<\/p>\n

Fields exported to csv using this script are:<\/p>\n

Display Name
\nSizeMB
\nSizeGB
\nStorage Group
\nStore
\nTotal Items<\/p>\n

I used this to work out an average mailbox usage per server.<\/p>\n

I found the script here<\/a>. There’s also more information on this script from the source site.<\/p>\n

Hope this has been helpful.<\/p>\n","protected":false},"excerpt":{"rendered":"

If you need a rather quick way to export all the mailbox sizes on a particular server then the below link is for you. Download the script, run it\u00a0by opening\u00a0the command prompt and type cscript MSX_GetMailboxSize.vbs thenameoftheserverhostingthemailboxes>filenameyouwanttochoose.csv Remember to add the export location to the above command if you want to save the export to a particular path ie: cscript MSX_GetMailboxSize.vbs servername>e:reportsserver1.csv Open the csv export with Excel after you ran the script. You can then manipulate the contents to the format you need as all mailbox data will be there. Fields exported to csv using this script are: Display Name SizeMB SizeGB Storage Group Store Total Items I used this to work out an average mailbox usage per server. I found the script here. There’s also more information on this script from the source site. Hope this has been helpful.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[42,376,66,87,88,123],"class_list":["post-57","post","type-post","status-publish","format-standard","hentry","category-exchange-2003","tag-average-mailbox-utilisation-size","tag-exchange-2003","tag-export-mailbox-sizes-per-server","tag-mailbox-size-export","tag-mailbox-sizes","tag-scripts"],"_links":{"self":[{"href":"http:\/\/exchangetimes.net\/index.php?rest_route=\/wp\/v2\/posts\/57","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/exchangetimes.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/exchangetimes.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/exchangetimes.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/exchangetimes.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=57"}],"version-history":[{"count":0,"href":"http:\/\/exchangetimes.net\/index.php?rest_route=\/wp\/v2\/posts\/57\/revisions"}],"wp:attachment":[{"href":"http:\/\/exchangetimes.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/exchangetimes.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/exchangetimes.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}