Yep; works with v2 on my system as well. I'd be inclined to look at your csv file; make sure it's a good CSV and doesn't have any null lines.
DAMIEN SOLODOW Systems Engineer 317.447.6033 (office) 317.447.6014 (fax) HARRISON COLLEGE -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Don Kuhlman Sent: Thursday, October 17, 2013 5:32 PM To: [email protected] Subject: RE: [NTSysADM] RE: Powershell question 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
