<div>
I used the script in the below link before to update attributes<br />
<br />
<a href="https://gallery.technet.microsoft.com/scriptcenter/Update-Active-Directory-2e3718ae" rel="ugc nofollow">https://gallery.technet.microsoft.com/scriptcenter/Update-Active-Directory-2e3718ae</a><br />
<br />
change the details in users,csv and run the batch file and select the attributes you want to change
</div>


<div>
You can also di it in the GUI: &nbsp;<br />
Select all 10 users (Shift click, or CTRL click), <br />
Right click then select properties<br />
Select Address Tab<br />
Click the Country/Region checkbox<br />
Select US for the dropdown.
</div>


<div>
A script as mentioned above would be better, however you could still do it in the GUI:<br />
<br />
Create a Saved query with the following search filter:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; (&amp;(objectCategory=user)(ob<wbr />jectClass=<wbr />user)(!co=<wbr />US))<br />
<br />
Then save it, select the query and let it populate.<br />
The select CTRL-A and same process as my first comment.
</div>


<div>
The above query will look for all users that don't have US as their country and only display those users. &nbsp;You can target the query and any OU you require or at the root if that is appropriate. &nbsp;Let me know if you need help creating the query or I could give you the query XML to import.
</div>


<div>
I need help in creating the query as I need to run powershell in AD DC
</div>


<div>
You can use the same filter I used in your script. &nbsp; &nbsp;Did you need me to write you a script.... give me a few minutes
</div>


<div>
<pre><code class="code-1 nolinks" id="code-20-42367910-1"><span>Import-Module ActiveDirectory</span>
<span></span>
<span>Get-ADUser -SearchBase 'ou=yourOu,dc=domain,dc=com' -Filter &quot;(&amp;(objectCategory=user)(objectClass=user)(!co=US))&quot; |</span>
<span></span>
<span>   Foreach-Object {</span>
<span></span>
<span>    Set-ADUser -identity $_ -Country &quot;US&quot;    }</span>
</code></pre>
<br />
Just replace your ou and domain name as required
</div>


<div>
AS I need to put 20 users in it
</div>


<div>
$users = Import-Csv  <br />
foreach Get-ADUser -SearchBase 'ou=yourOu,dc=domain,dc=co<wbr />m' -Filter &quot;(&amp;(objectCategory=user)(o<wbr />bjectClass<wbr />=user)(!co<wbr />=US))&quot; |<br />
<br />
&nbsp; &nbsp;Foreach-Object {<br />
<br />
&nbsp; &nbsp; Set-ADUser -identity $_ -Country &quot;US&quot; &nbsp; &nbsp;}<br />
($user in $users) {
</div>


<div>
can I omit OU as OU is not mentioned in the list
</div>


<div>
<pre><code class="code-1 nolinks" id="code-20-42368210-1"><span>$users = Import-Csv -Path &quot;C:\yourpath\userlist.csv&quot;            </span>
<span>            </span>
<span>foreach ($user in $users) {            </span>
<span> Set-ADUser -identity $user.SamAccountName -Country &quot;US&quot; </span>
<span>}</span>
</code></pre>
<br />
Try this instead. &nbsp;Adjust the path as required
</div>


<div>
As for your previous comment on the omitting the OU. &nbsp;Yes. &nbsp;You can target the searchbase to the root of your domain.<br />
<br />
So if your domain is called: &nbsp;Mydomain.Local<br />
The searchbase would be: 'dc=Mydomain,dc=local&quot;<br />
<br />
But if you really want to use a input file, then the import csv script should work.
</div>


<div>
Sorry wrote that off the cuff during a meeting, just tried that script. &nbsp;Didn't work. &nbsp;A few tweaks<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42368259-1"><span>$users = Import-Csv -Path &quot;C:\yourpath\userlist.csv&quot;                      </span>
<span>foreach ($user in $users) {            </span>
<span>Set-ADUser $user.SamAccountName -Replace @{c=&quot;us&quot;} </span>
<span>}</span>
</code></pre>
<br />
This script assumes that userlist.csv has a column titled SamAccountName
</div>


<div>
thanks a lot , I will attach the excel sheet, please confirm which columns needs to be in CSV.<br />
<br />
I will attach shortly, thanks for all input.
</div>


<div>
I am attaching the excel sheet, which are the columns I should use from this excel sheet in to csv.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w46/1210996/test.xlsx" target="_blank" class="file-inline" title="columns need to be considered into csv (4.8 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>test.xlsx</a>
</div>


test.xlsx

<div>
$users = Import-Csv -Path &quot;C:\yourpath\userlist.csv&quot;<wbr /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
foreach ($user in $users) { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
Set-ADUser $user.SamAccountName -Replace @{c=&quot;us&quot;} <br />
}<br />
<br />
Is above script different from below as below script worked by my ad engineer<br />
# Import AD Module &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
Import-Module ActiveDirectory &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
write-Host 'Starting to update AD Attributes.......' -NoNewline -ForegroundColor Yellow<br />
# Import CSV into variable $userscsv &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
$users = Import-Csv -Path C:\temp\users.csv &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
# Loop through CSV and update users if the exist in CVS file &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
foreach ($user in $users) { &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
#Search in specified OU and Update existing attributes &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp;Get-ADUser -Filter &quot;SamAccountName -eq '$($user.samaccountname)'&quot;<wbr /> -Properties * -SearchBase &quot;DC=an,DC=xx,DC=com&quot; | &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; Set-ADUser -replace @{c = &quot;$($user.c)&quot;}<br />
&nbsp;Get-ADUser -Filter &quot;SamAccountName -eq '$($user.samaccountname)'&quot;<wbr /> -Properties * -SearchBase &quot;DC=an,DC=xx,DC=com&quot; |<br />
&nbsp; Set-ADUser -replace @{co = &quot;$($user.co)&quot;} &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
}<br />
Write-Host 'done!' –
</div>


<div>
The column is blank, but the column &quot;Login Name&quot; looks like the one you need. &nbsp;That would likely be the userid they use the login to the domain right? &nbsp;<br />
<br />
So in my script the $user.SamAccountName, &quot;SamAccountName&quot; is the column you are looking for from your CSV.<br />
<br />
So you have a few choices, the simplest would be to rename the &quot;Login Name&quot; to &quot;SamAccountName&quot;. &nbsp;Then the script will enumerate through all the users within that column.
</div>


<div>
Alternately you could change the script to user the Login Name column, but it contains a space and you would need to remove the space so it would be LoginName and do the same on your spreadsheet.<br />
<br />
The code would look like this now:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42369218-1"><span>$users = Import-Csv -Path &quot;C:\yourpath\userlist.csv&quot;                      </span>
<span>foreach ($user in $users) {            </span>
<span>Set-ADUser $user.LoginName -Replace @{c=&quot;us&quot;} </span>
<span>}</span>
</code></pre>
</div>


<div>
what column should I take from excel sheet , my last question
</div>


<div>
column for what?<br />
<br />
What script are you using, mine or your AD Engineer's?<br />
<br />
Your AD Engineer's script requires three columns:<br />

<ol type="1">
<li>It is looking for a column called &quot;SamAccountName&quot; and it wants userids in that column.</li>
<li>A second called called &quot;c&quot; and it wants the two letter country code. &nbsp;In your case: &quot;US&quot;</li>
<li>A Third called called &quot;co&quot; and it wants the two letter country code. &nbsp;In your case: &quot;US&quot;</li>
</ol>
<br />
My script only requires one column:<br />

<ol type="1">
<li>It is looking for a column called &quot;SamAccountName&quot; and it wants userids in that column.</li>
</ol>
<br />
This is part of the reason why my script is so much smaller. &nbsp;It just needs the userid to know who to edit, then it just sets the country code to US.
</div>


<div>
I am running the same script for LA but users are from argentina, brazil, chile so what should I put in c and co field
</div>


<div>
So if you are using your engineers table, then you would need to reference this table:<br />
<a href="https://msdn.microsoft.com/en-us/library/ms707477(v=vs.85).aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/ms707477(v=vs.85).aspx</a><br />
<br />
So for the c and co, use the same code.<br />
<br />
So<br />
CL for Chili<br />
AR for Argentina<br />
BR for Brazil
</div>


<div>
This is also another good table<br />
<a href="https://msdn.microsoft.com/en-us/library/ee783932(v=cs.10).aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/ee783932(v=cs.10).aspx</a>
</div>


<div>
so for ex. c will be cl <br />
and co chile?
</div>


<div>
So both in C and co FILELD I should put CL for chile
</div>


<div>
Sorry,<br />
<br />
c is the country code<br />
co is the full name<br />
<br />
co = Chile<br />
c - CL
</div>


<div>
Get-ADUser : The supplied distinguishedName must belong to one of the following partition(s): <br />
'CN=Configuration,DC=xxx,D<wbr />C=com , CN=Schema,CN=Configuration<wbr />,DC=xxx,DC<wbr />=com , DC=ForestDnsZones,DC=xxx,D<wbr />C=com , <br />
At C:\temp\chile-Update-AD-at<wbr />tribute-co<wbr />unrty-from<wbr />-CSV.ps1:1<wbr />2 char:2
</div>


<div>
on this line:<br />
<br />
Get-ADUser -Filter &quot;SamAccountName -eq '$($user.samaccountname)'&quot;<wbr /> -Properti<wbr />es * -SearchBase &quot;DC=an,DC=xx,DC=com&quot; | <br />
<br />
did you replace dc=an, dc=xx, dc=com with your actual domain?<br />
<br />
i.e if your domain is an.yourco.com, then it would be:<br />
dc=an,dc=yourco,dc=com<br />
(Please don't post our actual domain)
</div>


<div>
<div class="content wysiwyg-content">
I have got a list of 20 users. where there country location is blank.<br />
<br />
I need to run a simple script on DC where i can update their country location as United States
</div>
</div>


I have got a list of 20 users. where there country location is blank.

I need to run a simple script on DC where i can update their country location as United States

ACTIVE DIRECTORY

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.