Powershell – New-QADUser CmdLet not adding UserPrincipalName when called in PowerShell

active-directorypowershell

I am trying to import users into AD using a CSV file, PowerShell, and Quest's AD CmdLets. When the users are added the UserPrincipleName is not added.

Here is a sample CSV:

FirstName,LastName,DisplayName,SamAccount,UserPrincipleName,Email

FirstA,LastA,"First Last",FLastAL.ou1,FLastAL.ou1@clients.domain.local,FLastA@outemail.com
First2A,Last2A,"First2 Last",FLast2AL.ou1,FLast2AL.ou1@clients.domain.local,FLast2A@outemail.com

Here is the PowerShell snippit:

$Users = Import-Csv $UserFile
foreach ($User in $Users)
{
    New-QADUser -FirstName $User.FirstName -LastName $User.LastName -DisplayName $User.DisplayName -SamAccountName $User.SamAccount -Name $User.SamAccount -UserPrincipalName $User.UserPrincipalName -ParentContainer "OU=$OUName,OU=Customers,DC=clients,DC=domain,DC=local"
}

Best Answer

I think the problem was the fact that we are using Exchange 2007 which does not use RUS. When I used the Exchange 2007 CmdLets to do the same thing everything is working correctly.

Related Solutions

Powershell – Trapping only exceptions that occur when an active directory user already exists using the New-QADUser cmdlet

You could use the Try, Catch block like the following.

try
{
   New-ADUser "FAKEACCOUNT"
}
catch [Microsoft.ActiveDirectory.Management.ADIdentityAlreadyExistsException]
{
   #forget about it....
}
catch
{
   #PANIC!
}

Note: I'm not positive the New-QADUser cmdlet throws the same exception, but the above code works for the New-ADUser cmdlet.

This link may help you decipher the specifics of your situation: http://blogs.msdn.com/b/adpowershell/archive/2009/03/25/error-reporting-in-active-directory-powershell.aspx

Powershell – Getting AD username from first name and surname in CSV file

Add as the first line of your CSV file a row containing the column headers for your file. You then use those headers as the property names when iterating through the file.

So your file should look something like:

Firstname,Lastname
Joe,Schmoe
John,Doe
Jane,Doe

~~Then your code should work as is.~~

Also, the filter seems not to like $Name.lastname. I'm not sure exactly why, but even property expansion is not doing the trick. If you collapse this into a single string variable it work:

$names = Import-CSV C:\path\to.csv
ForEach ($Name in $Names)
{
    $nameFilter = $Name.Firstname
    Get-ADUser -Filter { GivenName -like $nameFilter }
}

Best Answer

Related Solutions

Powershell – Trapping only exceptions that occur when an active directory user already exists using the New-QADUser cmdlet

Powershell – Getting AD username from first name and surname in CSV file

Related Topic