For "Servername\Mailbox Database" how can I include ALL the mailboxdatabases? Thanks

Here you go... Get-MailboxDatabase | Get-Mailbox | sort-object | Select-Object name,alias,servername,ProhibitSendQuota,IssueWarningQuota,MaxReceiveSize,MaxSendSize,DisplayName,Database,PrimarySmtpAddress,ProhibitSendReceiveQuota,@{n="Size(KB)";e = {$MBXstat = Get-MailboxStatistics $_.name; $MBXstat.totalItemsize}},@{n="Items"; e = {$MBXstat = Get-MailboxStatistics $_.name ; $MBXstat.itemcount; $MBXstat.storageLimitStatus}} | Export-Csv C:\output.csvKottees : My Blog : Please mark it as an answer if it really helps you.

Hi Karl, Thanks, but that doesnt help in this situation. it seems that your code only gives the IssueWarningQuota and ProhibitSendQuota on the individual mailboxes. I have the quotas on the mailbox store. That would have been good information to have in the initial request for help :) KarlMy Blog: http://unlockpowershell.wordpress.com My Book: Windows PowerShell 2.0 Bible My E-mail: -join ("6B61726C6D69747363686B65406D742E6E6574"-split"(?<=\G.{2})",19|%{[char][int]"0x$_"})

It either says below limit or no checking for the mailbox database, but it doesnt show what the number limit is actually set at. For example I would like, if possible, to see this: Display name - Database - TotalItemSize - ItemCount- Warning limit size on Database - Prohibit Send limitsize on Database Karl, Sorry I didnt explain it well enough.

Hi Badlands For Quota on Individual Get-Mailbox | Select-Object Displayname,Database,@{Name='TotalItemSize'; Expression={[String]::join(";",((Get-MailboxStatistics -identity $_.identity).TotalItemSize))}},@{Name='ItemCount'; Expression={[String]::join(";",((Get-MailboxStatistics -identity $_.identity).ItemCount))}},IssueWarningQuota, ProhibitSendQuota | export-csv -path "c:\mailboxsizes.csv" For Quota on Database Get-Mailbox | Select-Object Displayname,Database,@{Name='TotalItemSize'; Expression={[String]::join(";",((Get-MailboxStatistics -identity $_.identity).TotalItemSize))}},@{Name='ItemCount'; Expression={[String]::join(";",((Get-MailboxStatistics -identity $_.identity).ItemCount))}}, @{Name='IssueWarningQuota'; Expression={[String]::join(";",((Get-MailboxDatabase -identity ($_.identity).DataBase).IssueWarningQuota))}},@{Name='ProhibitSendQuota '; Expression={[String]::join(";",((Get-MailboxDatabase -identity ($_.identity).DataBase).ProhibitSendQuota))}} | export-csv -path "c:\mailboxsizes.csv" Cheers Zi FengZi Feng TechNet Community Support

Hi Badlands For Quota on Individual Get-Mailbox | Select-Object Displayname,Database,@{Name='TotalItemSize'; Expression={[String]::join(";",((Get-MailboxStatistics -identity $_.identity).TotalItemSize))}},@{Name='ItemCount'; Expression={[String]::join(";",((Get-MailboxStatistics -identity $_.identity).ItemCount))}},IssueWarningQuota, ProhibitSendQuota | export-csv -path "c:\mailboxsizes.csv" For Quota on Database Get-Mailbox | Select-Object Displayname,Database,@{Name='TotalItemSize'; Expression={[String]::join(";",((Get-MailboxStatistics -identity $_.identity).TotalItemSize))}},@{Name='ItemCount'; Expression={[String]::join(";",((Get-MailboxStatistics -identity $_.identity).ItemCount))}}, @{Name='IssueWarningQuota'; Expression={[String]::join(";",((Get-MailboxDatabase -identity ($_.identity).DataBase).IssueWarningQuota))}},@{Name='ProhibitSendQuota '; Expression={[String]::join(";",((Get-MailboxDatabase -identity ($_.identity).DataBase).ProhibitSendQuota))}} | export-csv -path "c:\mailboxsizes.csv" Cheers Zi FengZi Feng TechNet Community Support

I currently use this command to view the mailbox limits on the Exchaneg Server. I need to know what other commands to add in PowerShell so I can also view what the issue warning and prohibit send are at. thanks. Get-mailbox |Get-MailboxStatistics| select DisplayName,Database,TotalItemSize,ItemCount,storagelimitstatus | export-csv C:\mailboxsizes.csv -

use the |fl Get-Mailbox |fl Where Technology Meets Talent

You are looking for the *quota properties of the Get-Mailbox results. I'd do this: $AllMailboxes = @() $Mailboxes = Get-Mailbox -ResultSize Unlimited | Select DisplayName, Database, IssueWarningQuota, ProhibitSendQuota, ProhibitSendReceiveQuota, Alias foreach ($Mailbox in $Mailboxes){ $MailboxStats = "" |Select DisplayName,Database,IssueWarningQuota,ProhibitSendQuota,ProhibitSendReceiveQuota,TotalItemSize,ItemCount,StorageLimitStatus $Stats = Get-MailboxStatistics -Identity $Mailbox.Alias $MailboxStats.DisplayName = $Mailbox.DisplayName $MailboxStats.Database = $Mailbox.Database $MailboxStats.IssueWarningQuota = $Mailbox.IssueWarningQuota $MailboxStats.ProhibitSendQuota =$Mailbox.ProhibitSendQuota $MailboxStats.ProhibitSendReceiveQuota =$Mailbox.ProhibitSendReceiveQuota $MailboxStats.TotalItemSize = $Stats.TotalItemSize $MailboxStats.ItemCount = $Stats.ItemCount $MailboxStats.StorageLimitStatus = $Stats.StorageLimitStatus $AllMailboxes += $MailboxStats } $AllMailboxes | Export-Csv C:\mailboxsizes.csv -NoTypeInformation Karl My Blog: http://unlockpowershell.wordpress.com My Book: Windows PowerShell 2.0 Bible My E-mail: -join ("6B61726C6D69747363686B65406D742E6E6574"-split"(?<=\G.{2})",19|%{[char][int]"0x$_"})

Hi Karl, Thanks, but that doesnt help in this situation. it seems that your code only gives the IssueWarningQuota and ProhibitSendQuota on the individual mailboxes. I have the quotas on the mailbox store. The command I wrtote in my question gives me everything exactly except I just want to add the IssueWarningQuota, ProhibitSendQuota. If I add the IssueWarningQuota, ProhibitSendQuota to my command like this below it doesnt come out correctly. Get-mailbox |Get-MailboxStatistics| select DisplayName,Database,TotalItemSize,ItemCount,storagelimitstatus,IssueWarningQuota,ProhibitSendQuota | export-csv C:\mailboxsizes.csv -

Then you need to use get-mailboxdatabase as this is where the info is that you want.Sukh

So my question is then what command would I run to give me these results below: Get-mailbox |Get-MailboxStatistics| select DisplayName,Database,TotalItemSize,ItemCount,storagelimitstatus BUT, including the IssueWarningQuota and ProhibitSendQuota Thanks!!!

Try putting get-mailboxdatabase before the Get-Mailbox then | Get-Mailbox Then Select, include the IssueWarningQuota and ProhibitSendQuota Sukh

Hi Badlands Any update? CheersZi Feng TechNet Community Support

Tried that as well, guess its not possible to see results from the get-mailboxdatabase and mailbox in the same command. To see this for the mailbox: DisplayName,Database,TotalItemSize,ItemCount,storagelimitstatus and this for the mailbox database: IssueWarningQuota, ProhibitSendQuota

its possible.. give a try this.. Get-Mailbox -Database "Servername\Mailbox Database" | sort-object | Select-Object name,alias,servername,ProhibitSendQuota,IssueWarningQuota,MaxReceiveSize,MaxSendSize,DisplayName,Database,PrimarySmtpAddress,ProhibitSendReceiveQuota,@{n="Size(KB)";e = {$MBXstat = Get-MailboxStatistics $_.name; $MBXstat.totalItemsize}},@{n="Items"; e = {$MBXstat = Get-MailboxStatistics $_.name ; $MBXstat.itemcount; $MBXstat.storageLimitStatus}} | Export-Csv C:\output.csvKottees : My Blog : Please mark it as an answer if it really helps you.