Export list of users with specific custom Exchange 2007 Attribute
Greetings, Im looking for a way to export a list of users that currently have custom Attribute 5 populated only, and the data that resides on that attribute line. Is this possible? Thanks in advance!
February 8th, 2010 11:42pm
Fairly easy with Powershell, but you'll need either the Exchange EMS cmdlets in Exchange 2007/2010, or the Quest or MS cmdlets for AD management.What version of Exchange?
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2010 12:00am
Hello,looking to do this on Exchange 2007 sp2
February 9th, 2010 12:28am
get-mailbox -resultsize unlimited | where-object {$_.customattribute5} | select displayname,customattribute5 | export-csv attr5.csv -notype
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2010 12:33am
This is tested on Exchange 2007:
[PS] C:\>Get-Mailbox -ResultSize Unlimited | Where {$_.CustomAttribute5 -ne ''} | Select Name, Alias, PrimarySmtpAddress, CustomAttribute5 | Export-Csv -NoTypeInformation -Encoding Unicode -Path c:\temp\custom_attribute5_test.csv
The output of the .CSV file will be like this:
"Name","Alias","PrimarySmtpAddress","CustomAttribute5"
"Eva Marie Smith","xxx","xxx@domain.org","Custom Attribute 5: My daughter"
"Felicia Smith","yyy","yyy@domain.org","Custom Attribute 5: My dog"
MCTS: Messaging | MCSE: S+M | Small Business Specialist
February 9th, 2010 12:38am
Thanks to the both of you for the help, this woked out perfectly!
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2010 12:55am