asked on

Powershell to identify users with mailbox quota size greater than 512 MB

We have exchange 2007 Sp1

I want to pull out the names of the users who do not have default mailbox quota set for their accounts. In oother words have a custom mailbox quota set.
Can this be done via powershell??

MegaNuk3

try

Get-Mailbox | Where {$_.UseDatabaseRetentionDefaults -eq $False} | Select Name, UseDatabaseRetentionDefaults

Akhater

get-mailbox | ?{ $_.UseDatabaseQuotaDefaults -ne "true"}

MegaNuk3

Sorry I meant:
Get-Mailbox | Where {$_.UseDatabaseQuotaDefaults -eq $False} | Select Name, UseDatabaseQuotaDefaults

MegaNuk3

Akhater - that is a nice short command...

Akhater

MegaNuk3 thank you but you beat me to it :)

MegaNuk3

Or export to CSV:
get-mailbox | Where {$_.UseDatabaseQuotaDefaults -eq $False} | select name, *quota | sort name | export-csv Quotas.csv

amku03

ASKER

I thisnk we woul dalso need parametr for Resultsize

ASKER CERTIFIED SOLUTION

Akhater

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MegaNuk3

@akhater - u at least typed UseDatabaseQuotaDefaults whereas my first post was wrong, I posted UseDatabaseRetentionDefaults

amku03

ASKER

Akhater, your command gives more detailed result and MegaNuk3 your gives result but not teh size details.
Akhater I am gonna award you points for this one for a better shell command and also to make for yesterday's question :)
Cheers!!

Akhater

thanks a lot for the consideration but I do believe a split is more than fair here.

Cheers

MegaNuk3

no worries, Akhater is far better at PowerShell than me...

amku03

ASKER

Not sure how to do that