Windows Thread, First Name / Last Name in Technical; You could tell me more, yes....
17th September 2013, 09:37 AM #16
You could tell me more, yes.
17th September 2013, 10:42 AM #17
Well, our staff usernames are their staff codes in SIMS (i.e. initials), so there would need to be a report in SIMS that pulls out forename, surname and staff code. The Windows batch scripting process would then be:
* Output the list of usernames with no FN/SN as above to File 1;
* Output the full staff list from SIMS (using CommandReporter.exe) to File 2;
* For each staff code in File 2, check if it matches an entry in File 1;
* If it does, take the FN/SN entries in File 2 and use dsmod to enter them for that user.
Is your setup in a configuration that something like that could work with?
17th September 2013, 12:38 PM #18
- Rep Power
Very handy, I'll add that to the toolbox.
Originally Posted by Ephelyon
17th September 2013, 12:56 PM #19
My two-pence-worth (please feel free to ask for change) :
Generally try and make use of Export-CSV rather than Out-File. You can then easily pipe that back into a command, perhaps after manipulating it in excel. So I might run the commands to identify AD accounts without (say) Forename, Surname set properly, Pipe the samaccountname to a CSV file, use excel to populate surname, forename columns as appropriate and then use the modified CSV as an input to set the properties in AD.
17th September 2013, 12:57 PM #20
Perhaps even open that file in Excel in the meantime, wait for the user to edit it, then resume the script?
By Disease in forum How do you do....it?
Last Post: 19th October 2012, 10:05 PM
By Miscbrah in forum Windows Server 2008
Last Post: 2nd May 2012, 10:12 AM
By bewlay51 in forum Windows Server 2008 R2
Last Post: 5th August 2010, 08:05 AM
By TechMonkey in forum Virtual Learning Platforms
Last Post: 19th November 2009, 09:31 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)