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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics