I've been told that before. ;)
- WJR On Thu, Oct 17, 2013 at 5:54 PM, Jonathan Link <[email protected]>wrote: > You think too much. :D > > > On Thu, Oct 17, 2013 at 6:51 PM, William Robbins <[email protected]>wrote: > >> PICNIC. >> >> >> - WJR >> >> >> On Thu, Oct 17, 2013 at 5:41 PM, Damien Solodow < >> [email protected]> wrote: >> >>> PEBKAC. >>> >>> >>> damien.solodow >>> >>> >>> >>> -------- Original message -------- >>> From: "Heaton, Joseph@Wildlife" <[email protected]> >>> Date: 10/17/2013 6:39 PM (GMT-05:00) >>> To: [email protected] >>> Subject: RE: [NTSysADM] RE: Powershell question >>> >>> >>> Thanks guys, I must have fat fingered something initially. It worked >>> fine now. >>> >>> Joe >>> >>> >>> > -----Original Message----- >>> > From: [email protected] >>> > [mailto:[email protected]<[email protected]>] >>> On Behalf Of Damien Solodow >>> > Sent: Thursday, October 17, 2013 2:38 PM >>> > To: [email protected] >>> > Subject: RE: [NTSysADM] RE: Powershell question >>> > >>> > 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]<[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]<[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]<[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 >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> >>> >> >
