{"id":64,"date":"2018-05-04T11:14:05","date_gmt":"2018-05-04T10:14:05","guid":{"rendered":"http:\/\/banfi.co.uk\/blog\/?p=64"},"modified":"2018-05-04T11:15:04","modified_gmt":"2018-05-04T10:15:04","slug":"import-in-to-active-directory-from-powershell","status":"publish","type":"post","link":"https:\/\/banfi.co.uk\/blog\/2018\/05\/import-in-to-active-directory-from-powershell\/","title":{"rendered":"Import to Active Directory Users from PowerShell"},"content":{"rendered":"<p>Another quick script to Import data from a CSV back in to Active Directory on a domain controller<\/p>\n<pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\r\n# Import AD Module             \r\nImport-Module ActiveDirectory \r\n\r\n#Get Admin accountb credential\r\n\r\n$GetAdminact = Get-Credential\r\n$DomainOU = GET-ADDomain | Select-Object -ExpandProperty UsersContainer\r\n\r\n#Store the CSV in a table\r\n$Users = Import-CSV c:\\temp\\ExportADUsers\\Update.csv\r\n\r\nforeach ($User in $Users)\r\n{\r\n           \r\n#Search in specified OU and Update existing attributes            \r\n Get-ADUser -Filter &quot;SamAccountName -eq '$($User.'Logon Name')'&quot; -Properties * -SearchBase $DomainOU | Set-ADUser -GivenName $($User.'First Name') -Surname $($User.'Last Name') -DisplayName $($User.'Display Name') -Title $($User.'Directorate') -Description $($User.'Directorate') \r\n\r\nif (($User.'Account Status' -eq 'Disabled') ) {\r\n#Search in specified OU and disabled accounts as required\r\n Get-ADUser -Filter &quot;SamAccountName -eq '$($User.'Logon Name')'&quot; -Properties * -SearchBase $DomainOU | Disable-ADAccount\r\n }\r\n\r\n}\r\n\r\n&quot;Done&quot;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Another quick script to Import data from a CSV back in to Active Directory on a domain controller # Import AD Module Import-Module ActiveDirectory #Get Admin accountb credential $GetAdminact = Get-Credential $DomainOU = GET-ADDomain | Select-Object -ExpandProperty UsersContainer #Store the CSV in a table $Users = Import-CSV c:\\temp\\ExportADUsers\\Update.csv foreach ($User in $Users) { #Search in &hellip; <a href=\"https:\/\/banfi.co.uk\/blog\/2018\/05\/import-in-to-active-directory-from-powershell\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Import to Active Directory Users from PowerShell<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[15,11],"tags":[],"class_list":["post-64","post","type-post","status-publish","format-standard","hentry","category-audit","category-powershell"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":4,"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/posts\/64\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/banfi.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}