WatchGuard’s Threat Lab is a group of dedicated threat researchers committed to helping you stay ahead of the bad guys by providing in-depth analysis of the top security threats to your network. Check out this quarters report on the threats that shook the industry in Q4 2017.
Updating AD user fields from CSV file.
This post is related to : http://www.experts-exchange.com/Programming/Languages/Scripting/Powershell/Q_24870528.html#a34868508
Just want to verify that I am understanding the syntax changes, say I want to update the description, telephone, and office, the syntax for the lower half would read as follows;
Import-CSV $Csv | ForEach-Object {
Set-QADUser $_.DN -Description $_.description -Telephone $_.telephoneNumber -Office $_.physicalDeliveryOfficeN
}
Just want to verify that I am understanding the syntax changes, say I want to update the description, telephone, and office, the syntax for the lower half would read as follows;
Import-CSV $Csv | ForEach-Object {
Set-QADUser $_.DN -Description $_.description -Telephone $_.telephoneNumber -Office $_.physicalDeliveryOfficeN
}
Asked:
3-
3
1 Solution
Ran into a hiccup, was returned the following error:
When I converted the file to '.csv' I did receive an error message, but didn't think anything of it till now. I attached the error message file via picture. I am using Microsoft Excel 2010
excelError.jpg
$OuDomain = "dc=local,dc=testserver,dc=com" $Csv =
"c:\importfile.csv" Import-CSV $Csv | ForEach-Object { Set-QADUser $_.DN -Descr
iption $_.description -PhoneNumber $_.telephoneNumber -Office $_.physicalDeliver
yOfficeName}
Unexpected token 'Csv' in expression or statement.
At line:1 char:48
+ $OuDomain = "dc=local,dc=testserver,dc=com" $Csv <<<< = "c:\importfile.csv" I
mport-CSV $Csv | ForEach-Object { Set-QADUser $_.DN -Description $_.description
-PhoneNumber $_.telephoneNumber -Office $_.physicalDeliveryOfficeName}
+ CategoryInfo : ParserError: (Csv:String) [], ParentContainsErro
rRecordException
+ FullyQualifiedErrorId : UnexpectedToken
[PS] C:\Users\llamallamaduck\Desktop>$_.physicalDeliveryOfficeName
}
+ CategoryInfo : OpenError: (:) [Import-Csv], FileNotFoundExcepti
on
+ FullyQualifiedErrorId : FileOpenFailure,Microsoft.PowerShell.Commands.Im
portCsvCommand
When I converted the file to '.csv' I did receive an error message, but didn't think anything of it till now. I attached the error message file via picture. I am using Microsoft Excel 2010
excelError.jpg
You need some line breaks in there, are you trying to put it all on one line? PS will be quite happy spreading things out.
$OuDomain = "dc=local,dc=testserver,dc=com"
$Csv = "c:\importfile.csv"
Import-CSV $Csv | ForEach-Object {
Set-QADUser $_.DN -Description $_.description -PhoneNumber $_.telephoneNumber -Office $_.physicalDeliveryOfficeName
}
Import-CSV "c:\importfile.csv"
I have bad luck apparently.
:S
[PS] C:\Users\llamallamaduck\Desktop>$OuDomain = "dc=local,dc=testserver,dc=com"
[PS] C:\Users\llamallamaduck\Desktop>$Csv = "c:\import.csv"
[PS] C:\Users\llamallamaduck\Desktop>Import-CSV $Csv | ForEach-Object {
>> Set-QADUser $_.DN -Description $_.description -PhoneNumber $_.telephoneNumb
er -Office $_.physicalDeliveryOfficeName
>> }
>>
The term 'Set-QADUser' is not recognized as the name of a cmdlet, function, scr
ipt file, or operable program. Check the spelling of the name, or if a path was
included, verify that the path is correct and try again.
At line:2 char:14
+ Set-QADUser <<<< $_.DN -Description $_.description -PhoneNumber $_.telepho
neNumber -Office $_.physicalDeliveryOfficeName
+ CategoryInfo : ObjectNotFound: (Set-QADUser:String) [], Command
NotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
:S
Ahh not really :)
You either need to install these:
http://www.quest.com/powershell/activeroles-server.aspx
Or if you already did, you need to run this command first of all:
Add-PsSnapIn Quest.ActiveRoles.ADManage
That'll load the command and should let you execute the rest.
Chris
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
It'll be fine with that, yes.
The documentation for the CmdLet has it use PhoneNumber in place of Telephone:
Open in new window
But the parameter has an alias (TelephoneNumber) so it should work anyway.Chris