Forum Discussion

Baron164's avatar
Baron164
Brass Contributor
Jul 25, 2022

Need help generating a uidNumber using the EmployeeID Attribute

Existing Employee's all have an EmployeeID Attribute which is anywhere from 2 to 5 numbers long. I need to take a user's existing EmployeeID number and turn it into a uidNumber that is 6 characters l...
Active Directory
User Attributes
  • farismalaeb's avatar
    farismalaeb
    Jul 26, 2022

    Baron164 

    Yes, You have some things to consider in your script.

    First $uidnum is invalid as it return the user DN "CN=User,DC=MyDC ...." not the employeeID

    Second , you need to cast the $empid to be Int not String otherwise the int conversion will fail.

    Here is an update

    Please Check and let me know

     

    $allusers = Get-ADUser -Filter "employeeID -ge 0" -Properties Name,employeeID,uidNumber

foreach ($user in $allusers)
{
    [int]$empid = (Get-ADUser $user -Property EmployeeID).EmployeeID

    if ($user.uidNumber -eq $null)
        {
            $uidnum = "1"+'{0:d5}' -f $empid
            Set-ADUser -Identity $user.SamAccountName -Replace @{uidNumber=$uidnum}
        }
        
}
farismalaeb's avatar
farismalaeb
Steel Contributor
Jul 25, 2022

Baron164 

Small quick fix

$EmployeeID=115
"1"+'{0:d5}' -f $EmployeeID

The output looks like  

100115

  • Baron164's avatar
    Baron164
    Brass Contributor
    Jul 25, 2022

    farismalaeb 

    Thanks, this is what I have so far but it's not working. 

    $allusers = Get-ADUser -Filter "employeeID -ge 0" -Properties Name,employeeID,uidNumber

foreach ($user in $allusers)
{
    $empid = Get-ADUser $user -Property EmployeeID

    if ($user.uidNumber -eq 0)
        {
            $uidnum = "1"+'{0:d5}' -f $empid | Set-ADUser $user -uidNumber $uidnum
        }
        
}



     

    • farismalaeb's avatar
      farismalaeb
      Steel Contributor
      Jul 26, 2022

      Baron164 

      Wont work like this.

      make it like this

      $allusers = Get-ADUser -Filter "employeeID -ge 0" -Properties Name,employeeID,uidNumber

foreach ($user in $allusers)
{
    $empid = Get-ADUser $user -Property EmployeeID

    if ($user.uidNumber -eq 0)
        {
            $uidnum = "1"+'{0:d5}' -f $empid 
            Set-ADUser $user -uidNumber $uidnum
        }
        
}
      • Baron164's avatar
        Baron164
        Brass Contributor
        Jul 26, 2022

        farismalaeb

        Still not working, the script runs but it doesn't do anything and doesn't give me any errors.

        In my testing environment the uidNumber attribute is "<not set>" so I don't think the $user.uidNumber -eq 0 line was working. Once I changed it, the script now appears to at least be trying to set the attribute. However I've been unable to figure out how to use set-aduser to set the uidNumber attribute.

        This is what I change it to.

        $allusers = Get-ADUser -Filter "employeeID -ge 0" -Properties Name,employeeID,uidNumber

foreach ($user in $allusers)
{
    $empid = Get-ADUser $user -Property EmployeeID

    if ($user.uidNumber -eq $null)
        {
            $uidnum = "1"+'{0:d5}' -f $empid 
            Set-ADUser -Identity $user -Replace @{uidNumber=$uidnum}
        }
        
}


        This is the error I'm getting.



Resources