<div>
Powershell will be your friend!<br />
<br />
<a href="http://blogs.technet.com/b/heyscriptingguy/archive/2013/03/21/use-the-powershell-ad-provider-to-modify-user-attributes.aspx" rel="ugc">http://blogs.technet.com/b/heyscriptingguy/archive/2013/03/21/use-the-powershell-ad-provider-to-modify-user-attributes.aspx</a>
</div>


Powershell will be your friend!

http://blogs.technet.com/b/heyscriptingguy/archive/2013/03/21/use-the-powershell-ad-provider-to-modify-user-attributes.aspx [http://blogs.technet.com/b/heyscriptingguy/archive/2013/03/21/use-the-powershell-ad-provider-to-modify-user-attributes.aspx]

<div>
Use the following command below for your needs...<br />
<br />
CSV file needs to be created as follows...<br />
<br />
<b>sAMAccountName &nbsp; &nbsp;City &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; State &nbsp; Description</b><br />
bsmith &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NewTown &nbsp; NY &nbsp; &nbsp; &nbsp; Accounting Dept<br />
mcooper &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Drysdale &nbsp; &nbsp; AR &nbsp; &nbsp; &nbsp; Human Resources<br />
So on....<br />
<br />
Script below...<br />

<pre><code id="code-20-39562497-1">Import-Module activedirectory
$Users2Mod = Import-Csv c:\yourCSVFileHere.csv
$Users2Mod = Foreach ($Person in $Users2Mod) {
$Person.SamAccountName
$Person.Description
$Person.State
$Person.City
Set-ADUser -Identity $Person.SamAccountName -Description $Person.Description -City $Person.City -State $Person.State
}</code></pre>
</div>


Use the following command below for your needs...

CSV file needs to be created as follows...

sAMAccountName    City             State   Description
bsmith                           NewTown   NY       Accounting Dept
mcooper                        Drysdale     AR       Human Resources
So on....

Script below...


Import-Module activedirectory
$Users2Mod = Import-Csv c:\yourCSVFileHere.csv
$Users2Mod = Foreach ($Person in $Users2Mod) {
$Person.SamAccountName
$Person.Description
$Person.State
$Person.City
Set-ADUser -Identity $Person.SamAccountName -Description $Person.Description -City $Person.City -State $Person.State
}

<div>
<div class="content wysiwyg-content">
After aquiring several companies we need to change the AD description fro all accounts. Each OU has 200-300 AD accounts and i want to change the City, State, ...etc. How do i do this in bulk instead of doing it one at a time?
</div>
</div>


After aquiring several companies we need to change the AD description fro all accounts. Each OU has 200-300 AD accounts and i want to change the City, State, ...etc. How do i do this in bulk instead of doing it one at a time?

Bulk changes in Active Directory

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.