Change users in AD

Question

Hi guys!

I'm having trouble writing a script in PowerShell. I need a script that reads a CSV with two columns, later I need to filter the field in the first column and apply a value that is inside the other column in the user attributes in AD.

I wrote this script below but it is not working:

Import-Module ActiveDirectory
$Users = "C:\Users\joao.victor\Documents\leiaute.csv"
Import-CSV $Users -Header UserPrincipalName,title | %
Get-ADUser -Filter 'Name -like ""' -SearchBase 'OU=Objetos Arquivados,OU=BHZ,OU=MG,DC=academico,DC=educacao,DC=elv,DC=intranet' -Properties * | % {Set-ADUser $_ -add @{title=$_.title}}*

Can anybody help me?

Answer 1

Okay, let's try this version. The AD filter has always been quirky. This one contains an additional bit of data validation:

Import-Module ActiveDirectory   # this probably isn't necessary any longer
$OU = 'OU=Objetos Arquivados,OU=BHZ,OU=MG,DC=academico,DC=educacao,DC=elv,DC=intranet'
$Users = "C:\Users\joao.victor\Documents\leiaute.csv"
Import-Csv $Users -Header UserPrincipalName, title | # "Header" is only necessary if the CSV doesn't have a header row
    ForEach-Object{
        if ($_.UserPrincipalName.trim().length -ge 3){
            $upn = $_.UserPrincipalName.trim()
            if ($u = Get-ADUser -Filter {UserPrincipalName -eq $upn} -SearchBase $OU){  # "UPN" is unique. Using "-like" isn't necessary
                $u | Set-ADUser -Title $_.title 
            }
            else{
                Write-Host "Could not locate user: " $upn
            }
        }
        else{
            Write-Host "The UserPrincipalName '$($_.UserPrincipalName)' is either empty or too short"
        }
    }

Answer 2

Try this:

Import-Module ActiveDirectory   # this probably isn't necessary any longer
$OU = 'OU=Objetos Arquivados,OU=BHZ,OU=MG,DC=academico,DC=educacao,DC=elv,DC=intranet'
$Users = "C:\Users\joao.victor\Documents\leiaute.csv"
Import-Csv $Users -Header UserPrincipalName, title | # "Header" is only necessary if the CSV doesn't have a header row
    ForEach-Object{
        if ($u = Get-ADUser -Filter "UserPrincipalName -eq $($_.UserPrincipalName)" -SearchBase $OU){  # "UPN" is unique. Using "-like" isn't necessary
            $u | Set-ADUser -Title $_.title 
        }
        else{
            Write-Host "Could not locate user: " $_.UserPrincipalName
        }
    }

Answer 3

Hi,

Please check to see if this works.

$Users = "C:\Users\joao.victor\Documents\leiaute.csv"  
$OU = 'OU=Objetos Arquivados,OU=BHZ,OU=MG,DC=academico,DC=educacao,DC=elv,DC=intranet'  
Import-CSV $Users -Header UserPrincipalName,title | ForEach-Object{  
    $UPN = $_.UserPrincipalName  
    Get-ADUser -Filter {UserPrincipalName -eq $UPN} -SearchBase $OU | Set-ADUser -Title $_.title  
}  

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

Are you working in a multi-domain Active Directory forest? Is there a Global Catalog server in your AD site?

Try this code and see if the exception contains the name of the server that you should be using:

Import-Module ActiveDirectory   # this probably isn't necessary any longer
$OU = 'OU=Objetos Arquivados,OU=BHZ,OU=MG,DC=academico,DC=educacao,DC=elv,DC=intranet'
$Users = "C:\Users\joao.victor\Documents\leiaute.csv"
Import-Csv $Users -Header UserPrincipalName, title | # "Header" is only necessary if the CSV doesn't have a header row
    ForEach-Object{
        if ($_.UserPrincipalName.trim().length -ge 3){
            $upn = $_.UserPrincipalName.trim()
            Try{
                $u = Get-ADUser -Filter {UserPrincipalName -eq $upn} -SearchBase $OU -ErrorAction STOP
                if ($u){
                   $u | Set-ADUser -Title $_.title
                }
                else{
                    Write-Host "Could not locate user: " $upn
                }
            }
            Catch{
                Write-Host "Finding '$upn' caused an exception. See if the referral points to the correct server for the user."
                Write-Host $_.Exception.Referral
            }
        }
        else{
            Write-Host "The UserPrincipalName '$($_.UserPrincipalName)' is either empty or too short"
        }
    }