<div>
Create a list of departments in Excel and save it as Departments.csv<br />
It should have two columns with header names ADGroup and department<a href="https://filedb.experts-exchange.com/incoming/2016/02_w09/1083349/departments.png" target="_blank" title="departments.png (4 KB)"><img alt="departments.png" class="file-block lazyload" style="max-width: 350px;" data-src="https://filedb.experts-exchange.com/incoming/2016/02_w09/1083349/departments.png" /></a>Run PowerShell or the PowerShell ISE as Administrator.<br />
Change directory to the location where the .CSV file is saved.<br />
To use your department list, import it to a variable $Departments:<br />

<pre><code class="code-1 nolinks" id="code-20-41480535-1"><span>$departments = Import-Csv .\Departments.csv</span>
</code></pre>
To see the imported content &nbsp;simply type $departments<br />
If the list looks correct, the following one-liner will do the job:<br />

<pre><code class="code-1 nolinks" id="code-20-41480535-2"><span>$departments | ForEach-Object {Get-ADGroupMember $_.ADGroup | Set-ADUser -Department $_.Department -WhatIf}</span>
</code></pre>
Then making changes I always use the &nbsp;-WhatIf switch for testing. It will give the list of objects the changes will be applied to, without actually making any changes. If the list looks good, run the same one-lines without the &nbsp;-WhatIf switch.<br />
<br />
To see the result, get the same list of the affected users int the $usr variable:<br />

<pre><code class="code-1 nolinks" id="code-20-41480535-3"><span>$usr = $departments | ForEach-Object {Get-ADGroupMember $_.ADGroup}</span>
</code></pre>
Than list their Samaccountnames and departments:<br />

<pre><code class="code-1 nolinks" id="code-20-41480535-4"><span>$usr | Get-ADUser -Properties department | select samaccountname, department</span>
</code></pre>
<br />
Get-ADUser will only return a subset of the user properties. Department is not one of them, it has to be specified using the -Properties parameter
</div>


departments.png

<div>
Thanks L7Tech,<br />
Is that possible not to use CSV file. Something like get the list of users in AD group with one cmdlet and pipe it to another cmdlet?
</div>


<div>
<div class="content wysiwyg-content">
We have Windows 2012 R2 Active Directory Domain. “Department” field for some of the users in our domain needs to be updated with the appropriate department info.<br />
<br />
Updating “Department” properties for all users in AD one by one will take long time. I need PowerShell script to do it automatically. I need PowerShell script based on Microsoft AD cmdlets not Quest cmdlets. <br />
<br />
As an example, PowerShell should get the list of all users belonging to the “HR” AD group and add/update “Department” field of each AD account with the entry of “Human Resources Staff member”<br />
<br />
Thanks in advance
</div>
</div>


We have Windows 2012 R2 Active Directory Domain. “Department” field for some of the users in our domain needs to be updated with the appropriate department info.

Updating “Department” properties for all users in AD one by one will take long time. I need PowerShell script to do it automatically. I need PowerShell script based on Microsoft AD cmdlets not Quest cmdlets. 

As an example, PowerShell should get the list of all users belonging to the “HR” AD group and add/update “Department” field of each AD account with the entry of “Human Resources Staff member”

Thanks in advance

Need PowerShell script to update “Department” properties for all users belonging to a specific AD group

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.