Solved

Active Directory Account Edit

Posted on 2010-08-20
3
586 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
  • 2
3 Comments
 
LVL 10

Expert Comment

by:Casey Herman
Comment Utility
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
Comment Utility
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
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

[b]Ok so now I will show you how to add a user name to the description at login. [/b] First connect to your DC (Domain Controller / Active Directory Server) SET PERMISSIONS FOR SCRIPT TO UPDATE COMPUTER DESCRIPTION TO USERNAME 1. Open Active …
Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

772 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