How to create complete mailbox details with Organisational Unit
Hi,
Anyone knows how to create a complete mailbox statistics detail including name, alias, mailbox size, database name, OU?
Thanks
Sundar
May 9th, 2012 12:38am
Hi
only powershell script
what you want to find ?
get-mailbox somemailbox@domain.com | select name, samaccountname, alias, organizationalunit, displayname, primarysmtpaddress, database
Remigiusz
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2012 3:00am
Hi Sundar,
You can follow the below blog to Combining two commands get-mailbox and get-mailboxstatistics
http://get-exchange.blogspot.com/2009/03/did-you-ever-needed-to-supply-list-of.html
Frank Wang
TechNet Community Support
May 10th, 2012 4:42am
Hi Sundar,
You can follow the below blog to Combining two commands get-mailbox and get-mailboxstatistics
http://get-exchange.blogspot.com/2009/03/did-you-ever-needed-to-supply-list-of.html
Frank Wang
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
May 10th, 2012 4:43am
Hi Sundar,
Any updates?Frank Wang
TechNet Community Support
May 13th, 2012 10:39pm
Hi Frank,
Thanks for your reply.
I need the mailbox statistics for the whole organizational level or server level. I am running the command like below.
Get-MailboxStatistics -server 'exchmb1' | where {$_.ObjectClass eq Mailbox} | Sort-Object TotalItemSize Descending | ft DisplayName, TotalItemSize | out-file -filepath c:\windows\script\allmailbox.txt
But I need the output with Display Name, Total item size, database name, Organization Unit etc.
I am getting this output by exporting all users list from EMC and I am merging the above script output in excel sheet. Then comparing both the output by display name then eliminating the unwanted details. It takes lot of time for formating in excel
sheet. I need to get all this by running a single powershell command or script.
Thanks
Sundar
Free Windows Admin Tool Kit Click here and download it now
May 14th, 2012 1:57am
Hi
I need the mailbox statistics for the whole server level.
Sundar
May 14th, 2012 3:26pm
Try something like this (add more values as needed):
#this could be made more efficient by only getting mailboxstatistics once and storing it in a variable...
cls
$UserList = Get-mailbox -Resultsize unlimited
$MasterList = @()
foreach ($User in $UserList) {
$MyObject = New-Object PSObject -Property @{
DisplayName = ($User).DisplayName
Database = ($User).Database
ServerName = ($User).servername
ItemCount = (Get-MailboxStatistics $User).ItemCount
Lastllogontime =(Get-MailboxStatistics $User).Lastlogontime
EmailAddress = ($User).PrimarySmtpAddress
TotalItemSizeInMB = (Get-MailboxStatistics $User).Totalitemsize.value.toMB()
}
$MasterList += $MyObject
}
$MasterList | ft -AutoSize
read more on this approach: http://wp.me/pAAoj-fD
Mike Crowley | MVP
My Blog --
Planet Technologies
Free Windows Admin Tool Kit Click here and download it now
May 14th, 2012 6:19pm
Hi Frank,
I need the mailbox statistics for the whole organizational level or server level. I am running the command like below.
Get-MailboxStatistics -server 'exchmb1' | where {$_.ObjectClass eq Mailbox} | Sort-Object TotalItemSize Descending | ft DisplayName, TotalItemSize | out-file -filepath c:\windows\script\allmailbox.txt
But I need the output with Display Name, Total item size, database name, Organization Unit etc.
Hi Sundar,
The cmdlet is included in the link in my last reply. Now I post it here:
Get-Mailbox -Server servername | where {$_.RecipientTypeDetails -eq "UserMailbox"} | select name,alias,@{n="size";e = {$Mbxstat = Get-MailboxStatistics $_.name;$Mbxstat.totalitemsize}},database,organizationalunitFrank Wang
TechNet Community Support
May 14th, 2012 11:24pm