Question

Locked

Can you use Excel to manage Active Directory?

By 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

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

Clarifications

Collapse -
by zertyuiop

All Answers

Collapse -

excel passwd generator

by dr_shivan In reply to Can you use Excel to mana ...

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.

Collapse -

Reponse To Answer

by martinohansen In reply to excel passwd generator

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

Collapse -

One of the easiest ways to do this

by wokkawokka200 In reply to Can you use Excel to mana ...

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.

Collapse -

Reponse To Answer

by martinohansen In reply to One of the easiest ways t ...

Sounds good i will take a look at it!

Collapse -

i use excel for importing ad accounts

by markp24 In reply to Can you use Excel to mana ...

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.

Collapse -

Reponse To Answer

by martinohansen In reply to i use excel for importing ...

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

Back to Software Forum
8 total posts (Page 1 of 1)  

Software Forums