Exchange server which is shows mailbox storage limits of all mailbox users
I want a report to Exchange server which is shows mailbox storage limits of all mailbox users with (Display Name ,Email-ID,
State or province, mailbox Size (MB), Item Count). Exchange 2007
July 19th, 2010 3:50pm
I want a report to Exchange server which is shows mailbox storage limits of all mailbox users with (Display Name ,Email-ID, State
or province, mailbox Size (MB), Item Count). Exchange 2007
Hi,
This info is retreived from Mailbox server which u can easily get using following Powershell command in EMS:
get-mailboxServer
It will return u all MBX servers.
Regards,Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM)
www.HostingController.com
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2010 3:54pm
Hi,
If u want to generate a report then u can use this powershell command:
Get-MailboxStatistics -Server "Mailbox Server Name" | Select DisplayName, LastLoggedOnUserAccount, ItemCount, @{expression={$_.totalitemsize.value.ToMB()};label="Size(MB)"}
| Export-Csv c:\export\af.csv -NoTypeInformation
It will print this output into a CSV File "c:\export\af.csv".
Plz also have a look into this:
Getting Mailbox Statistics in Exchange 2007
http://www.msexchange.org/articles_tutorials/exchange-server-2007/management-administration/getting-mailbox-statistics-exchange-2007.html
Convert the Get-MailboxStatistics output from Bytes to MB or GB in Exchange 2007
http://aspoc.net/archives/2007/11/07/convert-the-get-mailboxstatistics-output-from-bytes-to-mb-or-gb-in-exchange-2007/
Regards,Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM)
www.HostingController.com
July 19th, 2010 4:01pm
Hi,
You can get this info using combination of these cmdlets : get-user and get-mailbox and get-mailboxstatistics
thanks
Thiyagu
Thiyagu | MCTS/MCITP - Exchange 2007 | MCSE 2003[Messaging] | http://www.myExchangeWorld.com. This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2010 4:06pm
Hi,
Thank for your reply
but how to get the Email-ID, State or province, these are AD objects
July 20th, 2010 9:33am
Hi,
You can do something like this :
Get-Mailbox "testusr1" | get-user | select StateorProvince,Email
thanks
ThiyaguThiyagu | MCTS/MCITP - Exchange 2007 | MCSE 2003[Messaging] | http://www.myExchangeWorld.com. This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2010 12:23pm
Hi,
You can do something like this :
Get-Mailbox "testusr1" | get-user | select StateorProvince,Email
thanks
Thiyagu
Thiyagu | MCTS/MCITP - Exchange 2007 | MCSE 2003[Messaging] | http://www.myExchangeWorld.com. This posting is provided "AS IS" with no warranties, and confers no rights.
This
get-user | select StateorProvince,Email
would not return "Email" or any thing like that. For email ID , u would have to use Get-Mailbox which returns PrimarySmtpAddress and EmailAddresses fields. I m testing a script, and willl post here soon.
Regards,Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM)
www.HostingController.com
July 20th, 2010 12:39pm
Hi,
Thank for your reply
but how to get the Email-ID, State or province, these are AD objects
Hi,
Plz try this script:
Get-Mailbox | foreach {
$UserInfo = Get-User -identity $_.Identity
$MailboxStat = Get-MailboxStatistics -identity $_.Identity
Add-Member -InputObject $_ noteProperty DisplayName $_.DisplayName
Add-Member -InputObject $_ noteProperty EmailID $_.PrimarySmtpAddress
Add-Member -InputObject $_ noteProperty StateOrProvince $UserInfo.StateOrProvince
Add-Member -InputObject $_ noteProperty TotalItems $MailboxStat.ItemCount
Add-Member -InputObject $_ noteProperty TotalSizeMB $MailboxStat.TotalItemSize.Value.ToMB() -PassThru
} | Export-Csv -Path C:\MailboxSize.csv
You can see somewhat similar script here:
http://social.technet.microsoft.com/Forums/en-US/exchangesvradmin/thread/1d95e6b4-e3cf-4bce-85af-8ce0d94d9cef
Regards,
Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM)
www.HostingController.com
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2010 1:36pm
Hi,
Sorry, there were some errors in last scripts, infact it was wrong.
Here is correct script:
Get-User -ResultSize Unlimited | Where {$_.RecipientType -eq "UserMailbox"} | Select DisplayName,StateOrProvince,Identity | foreach {
$MbxInfo = Get-Mailbox -identity $_.Identity
$MailboxStat = Get-MailboxStatistics -identity $_.Identity
Add-Member -InputObject $_ noteProperty EmailID $MbxInfo.PrimarySmtpAddress
Add-Member -InputObject $_ noteProperty TotalItems $MailboxStat.ItemCount
Add-Member -InputObject $_ noteProperty TotalSizeMB $MailboxStat.TotalItemSize.Value.ToMB() -PassThru
} | Export-Csv -Path C:\MailboxSize.csv -NoTypeInformation
Regards,Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM)
www.HostingController.com
July 20th, 2010 1:54pm