AD attribute in user account question

Posted on 2014-07-15
Last Modified: 2014-07-25
I have 2 questions

1.) We want to use the employeeID attribute in AD but you only see that when you look at the attribute editor. Is it possible to have it show up on the general tab?

2.) we need to import from excel an 4 digit + first character of first name to the employeeID AD attribute. I found a way to do part of this via powershell.

Import-CSV "C:\Scripts\Users.csv" |

But that does not take the first character of the first name and add it to the 4 digit code found in the cvs file. Is there a way to do that via powershell or do I have to do a vbscript?
Question by:iamuser
    LVL 14

    Expert Comment

    by:Ben Hart
    We also make sure of that specific attribute for the past 5 years but have still not found a way to see it easily.  You could obviously code something as an ADUC replacement but that's about it AFAIK.

    Author Comment

    But is the field still usable if it's populated? My concern is whether another AD aware software can see the data in that attribute.
    LVL 16

    Accepted Solution

    I have never had a need to do it before, but this article suggests they have a guide on making the attribute employeeID attribute available in ADUC:

    If you want to replace the employee ID as the first letter of their given name with the number in the CSV then just do the following.

    $user.EmployeeID=$user.givenName + $_.EmployeeID

    Open in new window

    This should do the trick.

    Any software which can query AD should have no problems reading the employeeID attribute though. If it does...use other software because that is just terrible.

    Author Closing Comment

    Great thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Hi all.   The other day I had to change the passwords for a bunch of users on the fly. Because they were so many, I decided to do it in an automated way and I would like to share it with you all.   If you are not doing it directly in a Domain Co…
    Set OWA language and time zone in Exchange for individuals, all users or per database.
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now