Tag Archives: in an ou

Windows – Reset all User Passwords in an OU

Posted on by

KB ID 0000497 

Problem

I did some bulk user imports for a client this week, and then needed to set all the passwords on these accounts. Seeing as it was a school, and each year group was in its own OU in Active Directory, I needed a way to “Bulk Reset” the passwords.

Note: Passwords can NOT be set with a CSV / CSVDE import.

Solution

1. We are going to perform this procedure while logged onto a domain controller with appropriate administrative rights.

2. Start > In the Search/run box type cmd {enter}

3. At command line issue the following command:

[box]dsquery user {LDAP path to the OU} | dsmod user -pwd the-new-password[/box]

Examples,

dsquery user OU=Intake2011,OU=Students,DC=petenetlive,DC=com | dsmod user -pwd P@ssword123

dsquery user “OU=Intake 2011,DC=petenetlive,DC=com” | dsmod user -pwd P@ssword123

Note: In the second example there is a space in the path (In the OU name Intake 2011) that’s why the path has been surrounded by quotes/speech marks. If you forget you will see an error like the one below:

Note 2: The display will only show 100 results by default (that does NOT mean anything has failed!) you will see the following though:

To see more results simply add “-limit {number}” after the LDAP path and before the pipe symbol e.g.

[box]dsquery user {LDAP path to the OU} -limit 300 | dsmod user -pwd the-new-password[/box]

Examples,

dsquery user OU=Intake2011,OU=Students,DC=petenetlive,DC=com -limit 300 | dsmod user -pwd P@ssword123

dsquery user “OU=Intake 2011,DC=petenetlive,DC=com” -limit 1500 | dsmod user -pwd P@ssword123

Related Articles, References, Credits, or External Links

NA

Bulk Importing Users with CSVDE

Posted on by

KB ID 0000498 

Problem

This is not a task I’ve had to do for ages, so when I had to do it this week, I thought I’d just do a quick Google search as a refresher. What I can remember was a simple task took me far too long to work out. So heres a quick solution for everybody else.

Solution

Before I begin, the spreadsheet below, was the hard work of John Haddock, I have only made some minor tweaks and adjustments.

1. You will need the names of the users you want to import in a spreadsheet, preferably with their first name and last names in different columns.

2. Download the CSVDE-Template spreadsheet.

3. On the first tab of the spreadsheet (Setup) enter your domain details, and the other cells as required.

4. Select the second tab (Auto-Generated-Version), and paste your users first-names into column G (Labelled gn for Given Name), and their surnames into column D (Labelled sn).

5. The rest of the fields should now “Auto fill”. To make sure all the user names are unique, look down column V (Duplicate check), and make sure all the entries say “False” if any say “true” you will need to alter the values for that user manually.

6. Once you are happy, select all the columns (Except U and V, {the yellow ones}) and copy them to the clipboard.

7. Select the third Tab (Paste-Your-CSV-Data-Here), Select the entire spreadsheet and Paste Special > Paste Values. (So the formulas DONT get pasted into the spreadsheet).

8. File > Save As > Change the “Save as type” to CSV >Save > OK > Yes.

9. Then at command line issue the following command:

10. All being well it should say “The command has completed successfully” If it does fail it handily tells you what line of the spreadsheet it failed on so you can investigate.

11. By default all the user accounts will be disabled, but you can select them all and enable them.

12. If you would like to reset all the passwords on mass, see the following article:

Windows – Reset all User Passwords in an OU

 

Related Articles, References, Credits, or External Links

NA