Christopher, Related question.
Trying to get some info out of Get-ADUser, by first importing a csv. The csv
has one column, called Name. This column has the display name of users.
Here's my command:
Import-csv c:\scripts\Users.csv | ForEach {Get-ADUser -Identity $_.Name
-SearchBase "top OU to start search" -SearchScope Subtree -Properties Name,Mail
| Select Name,Mail |Export-CSV c:\scripts\reports\user_mail.csv
-Notypeinformation
When I run this, I get the following error:
Get-ADUser : Parameter set cannot be resolved using the specified named
parameters.
At line:1 char:62
+ Import-Csv c:\scripts\users.csv | ForEach {Get-ADUser <<<< -Filter *
-Identity $_.Name -SearchBase "OU=Top OU to start search" -SearchScope Subtree
-Properties Name,Mail} | select Name,Mail | Export-Csv
c:\scripts\reports\user_mail.csv -NoTypeInformation
+ CategoryInfo : InvalidArgument: (:) [Get-ADUser],
ParameterBindingException
+ FullyQualifiedErrorId :
AmbiguousParameterSet,Microsoft.ActiveDirectory.Management.Commands.GetADUser
If I run a direct command:
Get-adUser -filter * -Searchbase "Top OU to start search" -Searchscope Subtree
-Properties Name,Mail | Select Name,Mail | export-csv
c:\scripts\reports\user_mail.csv -Notypeinformation
That command works. So, I'm guessing it has something to do with the $_.Name,
but I can't figure out what I'm doing wrong there.
Any advice? I'm sure this is something very simple that I'm missing, but I
can't for the life of me find it.
Thanks,
Joe Heaton
Enterprise Server Support
Information Technology Operations Branch
Data and Technology Division
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 [email protected]
Sent: Wednesday, December 04, 2013 1:14 PM
To: [email protected]
Subject: RE: [powershell] thought this would be simple
No problem.
The reason for that, is if it did read all properties by default it could get
quite messy. As there are ~60 properties (more if you have extend schema for
different things)
Christopher Catlett
Consultant | Detroit
[MCTS_2013_small]
Sogeti USA
Office 248-876-9738 |Fax 877.406.9647
26957 Northwestern Highway, Suite 130, Southfield, MI 48033-8456
www.us.sogeti.com<http://www.us.sogeti.com/>
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Heaton, Joseph@Wildlife
Sent: Wednesday, December 04, 2013 3:14 PM
To: '[email protected]'
Subject: RE: [powershell] thought this would be simple
That did it, 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]>
[mailto:[email protected]] On Behalf Of
[email protected]<mailto:[email protected]>
Sent: Wednesday, December 04, 2013 12:01 PM
To: [email protected]<mailto:[email protected]>
Subject: RE: [powershell] thought this would be simple
Get-ADUser -Filter * -Searchbase "top OU that I want to search from"
-Searchscope Subtree -Properties Surname,GivenName,Mail | select
Surname,GivenName,Mail | export-csv c:\location -NoTypeInformation
Christopher Catlett
Consultant | Detroit
[MCTS_2013_small]
Sogeti USA
Office 248-876-9738 |Fax 877.406.9647
26957 Northwestern Highway, Suite 130, Southfield, MI 48033-8456
www.us.sogeti.com<http://www.us.sogeti.com/>
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Trevor Sullivan
Sent: Wednesday, December 04, 2013 2:50 PM
To: [email protected]<mailto:[email protected]>
Subject: RE: [powershell] thought this would be simple
Joe,
Not all Active Directory object attributes are returned by default. You will
need to use the -Properties parameter on Get-ADUser to specify which Active
Directory attributes you want to include in the result.
Cheers,
Trevor Sullivan
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Heaton, Joseph@Wildlife
Sent: Wednesday, December 4, 2013 1:44 PM
To: [email protected]<mailto:[email protected]>
Subject: [powershell] thought this would be simple
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
================================================
Did you know you can also post and find answers on PowerShell in the forums?
http://www.myitforum.com/forums/default.asp?catApp=1
================================================
Did you know you can also post and find answers on PowerShell in the forums?
http://www.myitforum.com/forums/default.asp?catApp=1
================================================
Did you know you can also post and find answers on PowerShell in the forums?
http://www.myitforum.com/forums/default.asp?catApp=1
================================================
Did you know you can also post and find answers on PowerShell in the forums?
http://www.myitforum.com/forums/default.asp?catApp=1
================================================
Did you know you can also post and find answers on PowerShell in the forums?
http://www.myitforum.com/forums/default.asp?catApp=1
================================================
Did you know you can also post and find answers on PowerShell in the forums?
http://www.myitforum.com/forums/default.asp?catApp=1
<<inline: image001.jpg>>
