Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

AD Bulk set User to Exchange Powershell 2007

Posted on 2016-10-20
9
Medium Priority
?
48 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 17

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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
LVL 17

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
 
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 17

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 2000 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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
If you have come across a situation where you need to find some EDB mailbox recovery techniques, then here you will find the same. In this article, we will take you through three techniques using which you will be able to perform EDB recovery. You …
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

972 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