Yep, thanks :) I tried putting in -Properties *, and it kept giving me issues, but putting in just -Properties Surname,GivenName,Mail worked.
Thanks, Joe Heaton Enterprise Server Support CA Department of Fish and Wildlife 1807 13th Street, Suite 201 Sacramento, CA 95811 Desk: (916) 323-1284 From: [email protected] [mailto:[email protected]] On Behalf Of Damien Solodow Sent: Wednesday, December 04, 2013 11:48 AM To: [email protected] Subject: [NTSysADM] RE: Powershell command - thought it would be simple - Crosspost 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]> [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
