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??
amku03Asked:
Who is Participating?
 
AkhaterConnect With a Mentor Commented:
right you are get-mailbox -resultsize unlimited | ?{ $_.UseDatabaseQuotaDefaults -ne "true"}
0
 
MegaNuk3Commented:
try

Get-Mailbox | Where {$_.UseDatabaseRetentionDefaults -eq $False} | Select Name, UseDatabaseRetentionDefaults
0
 
AkhaterCommented:
get-mailbox | ?{ $_.UseDatabaseQuotaDefaults -ne "true"}

0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
MegaNuk3Commented:
Sorry I meant:
Get-Mailbox | Where {$_.UseDatabaseQuotaDefaults -eq $False} | Select Name, UseDatabaseQuotaDefaults
0
 
MegaNuk3Commented:
Akhater - that is a nice short command...
0
 
AkhaterCommented:
MegaNuk3 thank you but you beat me to it :)
0
 
MegaNuk3Commented:
Or export to CSV:
get-mailbox |  Where {$_.UseDatabaseQuotaDefaults -eq $False} | select name, *quota | sort name | export-csv Quotas.csv
0
 
amku03Author Commented:
I thisnk we woul dalso need parametr for Resultsize
0
 
MegaNuk3Commented:
@akhater - u at least typed UseDatabaseQuotaDefaults whereas my first post was wrong, I posted UseDatabaseRetentionDefaults
0
 
amku03Author Commented:
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!!
0
 
AkhaterCommented:
thanks a lot for the consideration but I do believe a split is more than fair here.

Cheers
0
 
MegaNuk3Commented:
no worries, Akhater is far better at PowerShell than me...
0
 
amku03Author Commented:
Not sure how to do that
0
All Courses

From novice to tech pro — start learning today.