Thursday, September 25, 2008

Expanding your Active Directory by employee numbers

Microsoft’s Active Directory is a very interesting “program” in itself. Active Directory gives administrator the ability to apply policies from a central location. It’s kind of like your local users and computers, but for a whole organization. AD is very customizable. A while back I was faced with a dilemma. When reviewing termination reports there was no way of telling the difference between Bob Miller in business unit 1 and Bob Miller in business unit 2. The only difference was the employee number. You could flip a coin and go by that to see who you would delete and who would stay. With our JDE system we have the ability to run reports that would allow us to see who has a user profile by their employee number. The employee number was assigned to each employee at their hire date and was unique to each employee. Why not bring this to AD or is this even possible? After doing much research I ran across the following site that would give me a step by step walk through of what to do: Here
This of course is for entering a SSN for each account. This would work, but definitely isn’t the brightest idea. Correct me if I’m wrong, but you should be able to query something like this with a tool such as Dameware. Dameware is a very cool tool. It’s much like MMC for MS Windows, however you can do much more without going to another window or tab. Dameware has cool things like Remote Control (that works without terminal server clients), remote command line and so on. Dameware can be found online at: here Anyway; this; in theory; with a little programming, would give anyone with Domain User rights access to query Active Directory and grab SSNs with no problems. Well anyway, after setting up AD to add employee numbers to accounts I was set with the long arduous task of adding employee numbers to each account. After about a month of this I was done. With a little programming I setup Dameware to view these employee numbers when I query AD. Term reports go peachy and I can sleep at night knowing a job well done!

1 comments:

Kyle said...

yes, but can it wash your dishes? I think Bob Miller, if your talking about THE Bob Miller, would really be interested in AD if it could wash dishes for him. Cha-chinggggg $$$$$$$$$$$$$