{"id":43703,"date":"2023-11-03T13:20:16","date_gmt":"2023-11-03T13:20:16","guid":{"rendered":"https:\/\/activedirectorypro.com\/?page_id=43703"},"modified":"2023-11-03T13:22:50","modified_gmt":"2023-11-03T13:22:50","slug":"26-update-countrycode-attribute","status":"publish","type":"page","link":"https:\/\/activedirectorypro.com\/kb\/26-update-countrycode-attribute\/","title":{"rendered":"Update Country Code Attribute"},"content":{"rendered":"<div class=\"gb-container gb-container-e2617065\">\n<div class=\"gb-container gb-container-cde80c47\">\n<div class=\"gb-grid-wrapper gb-grid-wrapper-5b2c7ed3\">\n<div class=\"gb-grid-column gb-grid-column-da7227eb\"><div class=\"gb-container gb-container-da7227eb\">\n\n<h3 class=\"wp-block-heading\" style=\"font-size:18px\">User Management Guides<\/h3>\n\n\n\n<p class=\"kb\"><a href=\"https:\/\/activedirectorypro.com\/kb\/26-update-countrycode-attribute\/\" data-type=\"link\" data-id=\"https:\/\/activedirectorypro.com\/kb\/26-update-countrycode-attribute\/\">Update Country Code<\/a><br><a href=\"https:\/\/activedirectorypro.com\/kb\/27-update-proxyaddresses\/\" data-type=\"link\" data-id=\"https:\/\/activedirectorypro.com\/kb\/27-update-proxyaddresses\/\">Update ProxyAddresses<\/a><br><a href=\"https:\/\/activedirectorypro.com\/kb\/28-export-update-users\/\" data-type=\"page\" data-id=\"43762\">Export &amp; Update Users<\/a><\/p>\n\n<\/div><\/div>\n\n<div class=\"gb-grid-column gb-grid-column-b2d1d5c5\"><div class=\"gb-container gb-container-b2d1d5c5\">\n\n<p class=\"breadcrumbs\"><a href=\"https:\/\/activedirectorypro.com\/kb\/\" data-type=\"page\" data-id=\"42788\">Knowledge Base<\/a> \/ Update Country Code Attribute<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" style=\"font-size:42px\">Update Country Code Attribute<\/h1>\n\n\n\n<p>In this guide, I&#8217;ll show you how to update the Country Code attribute in Active Directory using the AD Pro Toolkit. <\/p>\n\n\n\n<p>When you change the Country\/region settings for a user account in Active Directory it will actually update three attributes. <\/p>\n\n\n\n<ul>\n<li>c<\/li>\n\n\n\n<li>co<\/li>\n\n\n\n<li>countryCode<\/li>\n<\/ul>\n\n\n\n<figure class=\"gb-block-image gb-block-image-9699c492\"><img decoding=\"async\" loading=\"lazy\" width=\"804\" height=\"404\" class=\"gb-image gb-image-9699c492\" src=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-1.webp\" srcset=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-1.webp 804w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-1-300x151.webp 300w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-1-768x386.webp 768w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-1-600x301.webp 600w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/figure>\n\n\n\n<p>You can view these attributes with the Attribute Editor.<\/p>\n\n\n\n<figure class=\"gb-block-image gb-block-image-b823255d\"><img decoding=\"async\" loading=\"lazy\" width=\"804\" height=\"404\" class=\"gb-image gb-image-b823255d\" src=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-2.webp\" srcset=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-2.webp 804w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-2-300x151.webp 300w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-2-768x386.webp 768w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-2-600x301.webp 600w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/figure>\n\n\n\n<p><strong>To bulk update the countryCode requires setting these three attributes <\/strong>for each user. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1\">Step 1: Get the country code from the ISO website<\/h2>\n\n\n\n<p>Get the <strong>c<\/strong> and <strong>countryCode <\/strong>values from the <a href=\"https:\/\/www.iso.org\/obp\/ui\/#search\">ISO country code page<\/a>. You must use these ISO 3166 country codes or the update could fail. <\/p>\n\n\n\n<figure class=\"gb-block-image gb-block-image-2fe7e9b1\"><img decoding=\"async\" loading=\"lazy\" width=\"804\" height=\"404\" class=\"gb-image gb-image-2fe7e9b1\" src=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-3.webp\" srcset=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-3.webp 804w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-3-300x151.webp 300w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-3-768x386.webp 768w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-3-600x301.webp 600w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/figure>\n\n\n\n<p>Searching the website for the United States I find &#8220;US&#8221; for the <strong>c<\/strong> attribute and &#8220;840&#8221; for the <strong>countryCode<\/strong>.  The <strong>co<\/strong> attribute can be anything so I&#8217;ll use &#8220;United States&#8221;.<\/p>\n\n\n\n<p>If any of these 3 attributes are missing the update will fail, this is also true if using PowerShell.   <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2\">Step 2: Setup CSV file<\/h2>\n\n\n\n<p>Download the provided CSV template from the user bulk updater tool. These attributes are already included in the template, you will need to add the users and values to be updated. <\/p>\n\n\n\n<figure class=\"gb-block-image gb-block-image-29c45f71\"><img decoding=\"async\" loading=\"lazy\" width=\"804\" height=\"404\" class=\"gb-image gb-image-29c45f71\" src=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-4.webp\" srcset=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-4.webp 804w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-4-300x151.webp 300w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-4-768x386.webp 768w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-4-600x301.webp 600w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/figure>\n\n\n\n<p>Above, is a screenshot of my CSV template, column A is the user accounts I want to update followed by the c, co, and countryCode attributes. Save your CSV file and move to step 3. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-3\">Step 3: Run Updater Tool<\/h2>\n\n\n\n<p>The last step is to run the Bulk Updater Tool. Select your CSV file and click the run button. <\/p>\n\n\n\n<figure class=\"gb-block-image gb-block-image-b65e5c37\"><img decoding=\"async\" loading=\"lazy\" width=\"802\" height=\"402\" class=\"gb-image gb-image-b65e5c37\" src=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2023\/03\/ad-country-codes-1.webp\" srcset=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2023\/03\/ad-country-codes-1.webp 802w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2023\/03\/ad-country-codes-1-300x150.webp 300w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2023\/03\/ad-country-codes-1-768x385.webp 768w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/figure>\n\n\n\n<p>Check the logs for errors. <\/p>\n\n\n\n<figure class=\"gb-block-image gb-block-image-26bfa413\"><img decoding=\"async\" loading=\"lazy\" width=\"804\" height=\"404\" class=\"gb-image gb-image-26bfa413\" src=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-6.webp\" srcset=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-6.webp 804w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-6-300x151.webp 300w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-6-768x386.webp 768w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-6-600x301.webp 600w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/figure>\n\n\n\n<p>Above you can see I got an error on user Mikel.Johnson. Looking at the CSV this user is missing values for the c and countryCode columns. I did this on purpose to show you that all three attributes are required by Microsoft. <\/p>\n\n\n\n<figure class=\"gb-block-image gb-block-image-573b06c1\"><img decoding=\"async\" loading=\"lazy\" width=\"804\" height=\"404\" class=\"gb-image gb-image-573b06c1\" src=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-7.webp\" srcset=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-7.webp 804w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-7-300x151.webp 300w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-7-768x386.webp 768w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2022\/02\/ad-update-country-7-600x301.webp 600w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/figure>\n\n\n\n<p>All done. That is how you bulk update the Country value in Active Directory. <\/p>\n\n\n\n<p>To verify the country code attributes have updated run the all users report and include the c, co, and countrycode columns. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"802\" height=\"402\" src=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2023\/03\/ad-country-codes-3.webp\" alt=\"\" class=\"wp-image-37376\" srcset=\"https:\/\/activedirectorypro.com\/wp-content\/uploads\/2023\/03\/ad-country-codes-3.webp 802w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2023\/03\/ad-country-codes-3-300x150.webp 300w, https:\/\/activedirectorypro.com\/wp-content\/uploads\/2023\/03\/ad-country-codes-3-768x385.webp 768w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n<\/div><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":42788,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/activedirectorypro.com\/wp-json\/wp\/v2\/pages\/43703"}],"collection":[{"href":"https:\/\/activedirectorypro.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/activedirectorypro.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/activedirectorypro.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/activedirectorypro.com\/wp-json\/wp\/v2\/comments?post=43703"}],"version-history":[{"count":3,"href":"https:\/\/activedirectorypro.com\/wp-json\/wp\/v2\/pages\/43703\/revisions"}],"predecessor-version":[{"id":43715,"href":"https:\/\/activedirectorypro.com\/wp-json\/wp\/v2\/pages\/43703\/revisions\/43715"}],"up":[{"embeddable":true,"href":"https:\/\/activedirectorypro.com\/wp-json\/wp\/v2\/pages\/42788"}],"wp:attachment":[{"href":"https:\/\/activedirectorypro.com\/wp-json\/wp\/v2\/media?parent=43703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}