To your 'Get-Aduser' add -properties mail DAMIEN SOLODOW Systems Engineer 317.447.6033 (office) 317.447.6014 (fax) HARRISON COLLEGE
From: [email protected] [mailto:[email protected]] On Behalf Of Heaton, Joseph@Wildlife Sent: Wednesday, December 4, 2013 2:45 PM To: NT System Admin Issues Discussion list Subject: [NTSysADM] Powershell command - thought it would be simple - Crosspost Crossposting here and in the scripting list. I need to create a simple, 3 column csv: Last Name, First Name, e-mail address Note: We are not running Exchange in-house anymore, so I can't get this through Exchange shell, which would be much, much simpler. I have to get the info directly from Active Directory. I've run the following command: Get-ADUser -Filter * -Searchbase "top OU that I want to search from" -Searchscope Subtree | select Surname,GivenName,Mail | export-csv c:\location -NoTypeInformation That only gives me the first and last name, not the Mail attribute. So, I removed the select section, and just had it output everything to the csv. There's no mail attribute, and there's only 10 attributes showing. How can I get to the mail attribute? Thanks, Joe Heaton Enterprise Server Support CA Department of Fish and Wildlife 1807 13th Street, Suite 201 Sacramento, CA 95811 Desk: (916) 323-1284
