bulk designation update powershell from DisplayName

Question

bulk designation update powershell from DisplayName

thili koda 1

Hi All.

I have got a CSV that includes Display name and Title only, and I need to change Title accordingly to displayName can you please help me with Powershell.

Rich Matheisen 47,901 Reputation points

2021-09-26T19:24:01.027+00:00

Before offering any advice, are you intending to use the display name to locate the user in the AD? How sure are you that there are no duplicates in the AD? There are combinations of given name and surname that are very often common!
thili koda 1 Reputation point

2021-09-28T03:58:27.347+00:00
thili koda 1 Reputation point

2021-09-28T04:03:21.87+00:00

Good day to you attached is the error I'm getting and my how my CSV looks like ...
Rich Matheisen 47,901 Reputation points

2021-09-28T14:38:44.527+00:00

Have a closer look at the -Filter string! You've placed a "back-tick" before the "$" in $($user.employeename) -- replace the back-tick with a single-quote ("'").
Rich Matheisen 47,901 Reputation points

2021-09-28T14:47:59.88+00:00

If that's now your CSV file looks, how are you able to use "employeename" property???

1 answer

Your answer

Rich Matheisen 47,901 Reputation points

2021-09-26T19:24:01.027+00:00

Before offering any advice, are you intending to use the display name to locate the user in the AD? How sure are you that there are no duplicates in the AD? There are combinations of given name and surname that are very often common!
thili koda 1 Reputation point

2021-09-28T03:58:27.347+00:00
thili koda 1 Reputation point

2021-09-28T04:03:21.87+00:00

Good day to you attached is the error I'm getting and my how my CSV looks like ...
Rich Matheisen 47,901 Reputation points

2021-09-28T14:38:44.527+00:00

Have a closer look at the -Filter string! You've placed a "back-tick" before the "$" in $($user.employeename) -- replace the back-tick with a single-quote ("'").
Rich Matheisen 47,901 Reputation points

2021-09-28T14:47:59.88+00:00

If that's now your CSV file looks, how are you able to use "employeename" property???

Answer 1

Limitless Technology 39,926

Hello @thili koda

I would try something like this:

Import-CSV -Path C:\myUsers.CSV | Foreach-Object {  
  
    $DisplayName  = $_.DisplayName  
    $title = $_.jobtitle  
    Get-ADUser -Filter {(Displayname -eq "$DisplayName")} | Set-ADUser -Title $title

Hope this helps with your query,

-----------------

--If the reply is helpful, please Upvote and Accept as answer--

thili koda 1 Reputation point

2021-09-28T10:36:13.783+00:00

added a MissingEndCurlyBrace and ran yet the code ran without any error yet nothing updated in the AD.
Rich Matheisen 47,901 Reputation points

2021-09-28T14:45:58.93+00:00
The -Filter parameter takes a string for its value, not a code block. The correct filter string would be:

"Displayname -eq '$DisplayName'"

There's till that problem of the displayname property not guaranteed to be unique.

Share via

bulk designation update powershell from DisplayName

1 answer

Your answer