Questions

Can you use Excel to manage Active Directory?

+
1 Votes
Locked

Can you use Excel to manage Active Directory?

martinohansen
Can i use Excel as a list of users and then import the users to Active Directory?
A example of how Excel might look like:
http://i.imgur.com/Jzx8f.png

And also if anyone is hardcore to Excel, how do i make a random password generator?


Martin Hansen

Clarifications

zertyuiop

gliugil

+
0 Votes
dr_shivan

Paste the below into a cell and span across as many as you like.
=CHAR(RANDBETWEEN(33,126))
This will randomly generate a character from the alphanumeric+special key.
string the result and you get your random password.

+
0 Votes
martinohansen

I wont it to give me a 8 characters long password with lower case and upper case letters + numbers
I cant get =CHAR(RANDBETWEEN(33,126)) to that

+
1 Votes
waynemeat

You could put you user information in a spreadsheet like your picture and save it as a csv file. Then with LDAP in a batch, vb or powershell script you could create the accounts.

This should help get you started:
http://blogs.technet.com/b/heyscriptingguy/archive/2008/10/20/how-can-i-create-users-from-a-csv-file.aspx

There are many other examples of this method online.

+
0 Votes
martinohansen

Sounds good i will take a look at it!

+
1 Votes
markp24

Hi,

not sure if this fits what your looking for, but i have our sales system export new client account to a XLS file, then user VBscript to import and populate the system we use for our clients with the information, as well as setup a home folder, prepopulate it with required files (its a TS /Citrix type envirnment. if you want to see that let me know.

+
0 Votes
martinohansen

Im working on my exam at the moment so i would be really happy to see it!