Tag Archives: Excel 2010

Exchange PowerShell: How to find the mailbox sizes in Exchange 2010

Exchange PowerShellFollowing on from a previous article on how to find out mailbox sizes in Exchange 2007 found here, the syntax is a little different for Exchange 2010. Below are a few scripts that will help with Exchange 2010 reporting.

Get-Mailbox will show you mailbox name, alias, server and prohibit send quota. It’s a start, but no information on mailbox sizes.

Exchange 2010 Get-Mailbox

Using the first script from the Exchange 2007 post you need to add the -server switch, Get-MailboxStatistics -server SERVERNAME | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=”TotalItemSize(MB)”;expression={$_.TotalItemSize.Value.ToMB()}},ItemCount to get the following report.

Exchange 2010 Get-MailboxStatistics

By adding a redirect you can output the report details to a text file.

Get-MailboxStatistics -server SERVERNAME | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=”TotalItemSize(KB)”;expression={$_.TotalItemSize.Value.ToKB()}},ItemCount > c:\reports\mailbox_sizes.txt

Exchange 2010 Get-MailboxStatistics Report

Related Posts:

1. How to install Exchange 2010 (SP3) on Windows Server 2012

2. Office365 PowerShell: How to the find out mailbox sizes in Office365 (and Exchange 2016) using PowerShell

3. MSExchangeIS Event ID 9646: mapi session exceeded the maximum of 500 objects of type “objtFolderView” on Exchange Server 2010

4. Exchange PowerShell: How to enumerate and modify Distribution Group properties

5. How to install Exchange 2013 (SP1) on Windows Server 2012 R2

Finding the character length of a cell in Excel 2010

I was asked by a client to look at their directory structure and permissions to make some suggestions about how it could be improved.

I used AccessEnum (see link below) to pull out the details required and saved them as a unicode text file. After importing this into Excel I noticed some of the directory paths were huge, so wanted to find a quick and easy way of finding the path length.

I ended up using the Excel 2010 function LEN(text), where text is the string you want to find the length of.

In my case I created another column. In the cell adjacent to the directory path selected AutosumMore functions option, LEN. Typed in the cell number of the directory path cell. Then used Ctrl – D, to copy the formula down the required number of cells.

http://technet.microsoft.com/en-us/sysinternals/bb897332.aspx