How to Get-AdUser Whose description is not equal to Title

Question

How to Make a PowerShell script, report every user account whose Description is not equal to Title, report the list to a CSV file for reporting. And then make the script update the user account in such a situation to match their Description field to their Title.

Answer 1

Hello,

Below a script that can help, I've tested it.
It will export a list of users before the modification and you will have a status column which will tell you if the modification was successful:

$colExportUser = @()
$users = Get-ADUser -Filter * -Properties Description,Title | Where-Object {$_.Description -ne $_.Title}

foreach($user in $users) {
    try {
        Set-ADUser -Identity $user.SamAccountName -Title $user.Description -ErrorAction Stop
        $hash = @{
            Name = $user.Name
            SamAccountName = $user.SamAccountName
            Enabled = $user.Enabled
            Description = $user.Description
            Title = $user.Title
            DistinguishedName = $user.DistinguishedName
            OperationStatus = $true
        }

        $objExportUser = New-Object PSObject -Property $hash
        $colExportUser = $colExportUser + $objExportUser
    }catch {
        $hash = @{
            Name = $user.Name
            SamAccountName = $user.SamAccountName
            Enabled = $user.Enabled
            Description = $user.Description
            Title = $user.Title
            DistinguishedName = $user.DistinguishedName
            OperationStatus = $false
        }

        $objExportUser = New-Object PSObject -Property $hash
        $colExportUser = $colExportUser + $objExportUser
    }
}

$colExportUser | Export-Csv -Delimiter ";" -Path <yourpath> -NoTypeInformation

Answer 2

Hi @Yan, Jayden ,
this should meet the first requirement:

$UserstoEdit = Get-ADUser -SearchBase "DC=domain,DC=com" -Filter {Enabled -eq $true} -Properties * | Where-Object ($_.Description -Notlike $_.Title) | Export-CSV c:\temp\aduser.csv -NoTypeInformation  
  
foreach ($SingleUser in $UserstoEdit) {  
  
    Set-ADUser $SingleUser.SamAccountName -Description $SingleUser.Title  
}  

Unfortunately I am currently not able to test and although it should be working I would encourage to test in a test environment first.

Hope that helps!

----------

If my reply was helpful please don't forget to upvote and/or accept as answer, thank you!
Regards,
Stoyan