Exch2k7 spk3 - How to use the cmd-let 'Get-Mailbox' filtered by ExtendedAttribute1 ?
Hi,
I was planning to use this cmd-let filtered by 'ExtendedAttribute1' value and then use the result to set the Quota limits.
* We have a custommer with a lot mailboxes and the databases are 'mixed', so in that case we are unable to set the quota directly to entire database.
>>>> Can anyone help me? Or share other strategies?
Get-Mailbox: Exchange 2007 Help
http://technet.microsoft.com/en-us/library/bb123685(EXCHG.80).aspxtks, Renato P
September 28th, 2011 10:06am
This is better, you export all your mailboxes with their size. Copy the output to excel. Sort by mb size in Excel. Then you need to break up your users into sets. So if you plan to have 4 quotas then you will break up your spreadsheet into four sets
of users. Then you run import-csv with each sets of users with their corresponding quota limits.
[PS] C:\temp>get-mailbox |Get-Mailboxstatistics | select-object displayname, totalitemsize,@{ expression={$_.TotalItemSize.Value.ToKB()}},ItemCount |export-csv c:\temp\mbreport.csv
Sort the users and break your list of users into sets based on your quota into each csv file, after that you run import-csv for each set of users and set the quota. If you need help with this part let me know but you should be able to figure it out if you
have a little shell experience.
James Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2011 10:46am
Hi Jamestechman,
tks for quick reply. I will chek your option and also wait other ideas.
tks, Renato P
September 28th, 2011 11:10am
If it´s impossible (until now) to filter by 'Extended Attribute1', I´m using filtered by OU like the following sample.
Get-Mailbox -OrganizationalUnit "OU=USERS,OU=COMPANY,DC=DOMAIN,DC=LOCAL" | Set-Mailbox
-IssueWarningQuota 975MB -ProhibitSendQuota 1700MB -ProhibitSendReceiveQuota 1900MB
tks, Renato P
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2011 12:21pm
Do you already have extensionattribute1 populated with a value? If so then yes you can use that.
[PS] C:\temp>Get-Mailbox -ResultSize Unlimited | Where {$_.CustomAttribute1 -eq
"Blah"} |set-mailbox -IssueWarningQuota 975MB -ProhibitSendQuota 1700MB -P
rohibitSendReceiveQuota 1900MBJames Chong MCITP | EA | EMA; MCSE | M+, S+ Security+, Project+, ITIL msexchangetips.blogspot.com
September 28th, 2011 12:47pm
Tks Jamestechman, works perfect! You are my hero!tks, Renato P
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2011 2:15pm