Solved

Active Directory Account Edit

Posted on 2010-08-20
3
594 Views
Last Modified: 2012-05-10
I'm currently in need of a script that will read a .csv or excel file, take information from column 4(EmployeeNumber) query active directory for the user who has that employeeNumber and then take the number from column 3 (ID) and enter it into that employee's extensionAttribute14 in Active Directory
0
Comment
Question by:dmillerpps
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Expert Comment

by:Casey Herman
ID: 33488610
I would suggest a script that modifies AD using secure LDAP.  But it will not be easy and mistakes could jack your active directory installation.  Our firm does that sort of work but it would most definitely be fee based.
0
 
LVL 35

Expert Comment

by:Joseph Daly
ID: 33488663
Ok so working on this but so far this will do it for a single user. This uses the quest powershell cmdlets and using specific variables.

get-qaduser -oa @{employeeID='6474'} | set-qaduser -oa @{extensionAttribute14='2525'}

Still playing around trying to get this into a script form for you.
0
 
LVL 35

Accepted Solution

by:
Joseph Daly earned 500 total points
ID: 33488792
Ok just tested this on two accounts in my domain and this worked correctly. Using the script below and a csv file similar to the one attached. You can relable the column headings in the CSV file whatever you like as long as you match them in the script.


import-csv "C:\test.csv" | foreach {get-qaduser -oa @{employeeid=$_.employeeid} | set-qaduser -oa @{extensionAttribute14=$_.extension}}

Open in new window

test.csv
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Split on ASP 8 53
Compatibility view list registry key 1 47
CMD VB Script: remove empty rows 12 14
Exchange 2016->2010 migration - Autodiscover SCP question. 5 29
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Last week, our Skyport webinar on “How to secure your Active Directory” (https://www.experts-exchange.com/videos/5810/Webinar-Is-Your-Active-Directory-as-Secure-as-You-Think.html?cid=Gene_Skyport) provided 218 attendees with a step-by-step guide for…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

751 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