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

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

Other recent topics Other recent topics