I did the same thing using a test csv file - it worked with Powershell v2 on
Server 2008 R2 SP1.
When Posh did the autocomplete for me it put in "Properties" but "Property"
worked too.
My csv file was like this:
samaccountname
usera
userb
import-csv "c:\scripts\user list.csv" |foreach {Get-ADUser -identity
$_.samaccountname -Properties *} | select samaccountname,mail | export-csv
c:\scripts\reports\usermail.csv -NoTypeInformation
Don K
--------------------------------------------
On Thu, 10/17/13, Heaton, Joseph@Wildlife <[email protected]> wrote:
Subject: RE: [NTSysADM] RE: Powershell question
To: "[email protected]" <[email protected]>
Date: Thursday, October 17, 2013, 4:23 PM
Well, that
wasn’t a cut and paste there. I just retyped the
cmdlet in the mail message. The quotes in powershell
are whatever it puts in when you type
there…
Damien,
Powershell
2.0
Servers are
2008R2
-Joe
From: [email protected]
[mailto:[email protected]]
On Behalf Of Micheal Espinola Jr
Sent: Thursday, October 17, 2013 1:58 PM
To: [email protected]
Subject: Re: [NTSysADM] RE: Powershell
question
Personally, the
non-plaintext quotes in the OP bother me.
--
Espi
On Thu, Oct 17, 2013 at
1:22 PM, Damien Solodow <[email protected]>
wrote:
What version of Powershell are you
running?
What version are your DCs?
That script works fine on my machine.
J
I’m using PowerShell 3.0 on
Windows 7 with 2008 R2 domain controllers.
You sure the CSV doesn’t have
blank lines or the like?
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: Thursday, October 17, 2013 4:12 PM
To: [email protected]
Subject: [NTSysADM] Powershell question
I’m hoping
this is a simple question.
I have a csv with
a list of 1200 or so user names. I want to import that
into powershell, and for each one, query AD for that
user’s mail attribute. I then want to export to
a
new csv, the username and the mail attribute.
I thought it would
be fairly simple and this is what I tried:
Import-csv
“c:\scripts\user list.csv” | foreach
{get-ADuser –Identity $_.Name –Property *} |
select sAMAccountname,mail | export-csv
c:\scripts\reports\usermail.csv
–NoTypeInformation
This is the error
I get:
Get-ADUser :
Cannot convert 'System.Object[]' to the type
'Microsoft.ActiveDirectory.Management.ADUser'
required by parameter 'Identity'. Specified method
is not supported.
The csv I’m
importing has one column, titled Name, with sAMAccountnames
under 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
