Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I'm going round in circles and hoping someone can point me in the right direction...

I have created a .csv file as follows SamAccountName,Name,GivenName,Surname,DisplayName,Type,Path,Logon Name,UserPrincipleName,ScriptPath,Password fredflinstone,Fred Flinstone,Fred,Flinstone,Fred Flinstone,User,"CN=users,DC=Test,DC=local",fredf@test.local,fredf@test.local,login.bat,Yabba

I go to powershell, run "import-module activedirectory" then "Import-CSV C:\Users1.csv | New-ADUser"

It successfully adds the users but the issues I have are
1: it doesn't actually put in the "Account User login name" but does put in the pre 2000 name.
2: it doesn't put in the password
3: Even if I put in the Enabled field with the value $true they are still disabled

Any help would be appreciated

share|improve this question

3 Answers 3

  1. Logon Name is not one of the parameters that New-ADUser takes. See for a list of what you can use.
  2. Password won't work this way, as it has to be a SecureString for security reasons. If you want to load the password from the cSV you'll have to turn this into a fuller script that can convery the value form the CSV into a secureString.
  3. I wonder if enabled is being set with the string "$true" instead of the boolean value,a s a result of coming thru a CSV file?
share|improve this answer
Also, it's UserPrincipalName, not UserPrincipleName. –  pk. Mar 15 '11 at 21:15
  1. You need to populate "userPrincipalName" for the "User Login Name".

  2. Get-Help Set-ADAccountPassword -examples : the first one shows you how to set an AD password.

  3. As you haven't set a password, you can't enable the account regardless.

So your script will have three calls:

Create the user (New-ADUser)
Set the password (Set-ADAccountPassword)
Enable the user (Set-ADUser)
share|improve this answer
Thanks guys. I did have the spelling for Principal incorrect in the CSV file...that was my first issue. Since then we have completed this particular job. I just did a generic password manually and let them all set them. –  Fred Mar 30 '11 at 8:38

The Above are correct, you need to have UserPrincipalName something like this if gabbing information from an CSV:

-UserPrincipalName ($_.SamAccountName + '@' + $_.DomainName)

SamAccountName and DomainName are both Columns in my CSV spreadsheet

share|improve this answer
This works nicely, but isn't required--you can still manually specify the UPN if you want to. –  SturdyErde Jun 12 at 13:50
Yes, of course just like everything to be automatic :) thanks for the comments guys, just getting started here! –  Lachie White Jun 15 at 5:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.