Solved

AD Bulk set User to Exchange Powershell 2007

Posted on 2016-10-20
9
37 Views
Last Modified: 2016-10-26
Hi i am having problems running this script on powershell version

Name                           Value
----                           -----
CLRVersion                     2.0.50727.5485
BuildVersion                   6.1.7601.17514
PSVersion                      2.0
WSManStackVersion              2.0
PSCompatibleVersions           {1.0, 2.0}
SerializationVersion           1.1.0.1
PSRemotingProtocolVersion      2.1

Import-csv C:\Temp\input.csv | % {Set-ADUser $_.User -Office $_.Office -StreetAddress $_.StreetAddress -City $_.City -state $_.state -postalcode $_.postalcode}

i had no problem running on my machine but when i do it on the server no error it just doesnt write the values i would like to do the change in exchange powershell 2007 instead.
0
Comment
Question by:Jorge Ocampo
9 Comments
 
LVL 10

Expert Comment

by:Muhammad Mulla
ID: 41852259
Are you doing this with the AD modules imported into Powershell? Try:

Import-Module ActiveDirectory

Open in new window

0
 
LVL 14

Expert Comment

by:Todd Nelson
ID: 41852266
What type of server are you running the command from?  If the server does not have RSAT or ADDS features installed, the command won't do anything.

Remember to always precede your command with "Import-Module ActiveDirectory" in PowerShell.
0
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 41852306
import is on if i do a set-aduser to one user the command goes through
0
 
LVL 14

Expert Comment

by:Todd Nelson
ID: 41852331
You command does not look correct. Assuming there is more than one name in the CSV file, how does this command loop for each name?

Replace "%" with "ForEach-Object" and it should run fine.

Import-csv C:\Temp\input.csv | ForEach-Object {Set-ADUser $_.User -Office $_.Office -StreetAddress $_.StreetAddress -City $_.City -state $_.state -postalcode $_.postalcode}

Open in new window

0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 41852338
the following fields in csv user,office,streetaddress,city,state,postalcode
0
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 41852339
ill try replacing and see
0
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 41852358
no go would it possible to re-rewrite command for exchange powershell command instead could be because powershell 2.0 is not compatible
0
 
LVL 14

Expert Comment

by:Todd Nelson
ID: 41852373
PowerShell 2.0 is not compatible?  Provide the error you are getting.

Does it run in PowerShell instead of the Exchange Management Shell?

I have no issues running the command I provided in PowerShell or the Exchange management shell.
0
 
LVL 13

Accepted Solution

by:
Guy Lidbetter earned 500 total points
ID: 41853545
@Todd: "%" is the alias for Foreach...

@Jorge: - Please give this rewrite a shot...

Import-Module ActiveDirectory
$Userlist = Import-csv C:\Temp\input.csv
Foreach ($User in $Userlist) {
	Set-ADUser $User.User -Office $User.Office -StreetAddress $User.StreetAddress -City $User.City -state $User.state -postalcode $User.postalcode
}

Open in new window

0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In this video we show how to create a Contact in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Contact ta…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now