Hey Folks - Happy New Year! My boss has me working on a project to import a few attributes into AD for all of our employees. They are Department, Manager, Email and Title. I started piecing together a script of the net (because I don't know
powershell that well) and then he informed me he wanted a log file to spit out what, if anything was already in AD and then show what it was changing it to. And I managed to get there... to an extent.
# Import AD Module
Import-Module ActiveDirectory
write-Host 'Starting to update AD Attributes.......' -ForegroundColor White
# Import CSV into variable $users
$users = Import-Csv -Path C:\Scripts\Powershell\users.csv
foreach ($user in $users)
{
Write-Host $user
$output = ''
$u = Get-ADUser -Filter "displayName -eq '$($user.name)'" -Properties * -SearchBase "DC=------,DC=---"
$output = "Found $($u.name) at $($u.sAMAccountName)`r`n" `
+ "Email Address: $($u.mail) --> $($user.emailaddress)`r`n" `
+ "Title: $($u.title) --> $($user.Title)`r`n" `
+ "Department: $($u.department) --> $($user.department)`r`n" `
+ "Manager: $($u.manager) --> $($user.manager)`r`n"
Set-ADUser -EmailAddress $($user.EmailAddress) -title $($user.title) -department $($user.department) -manager $($user.manager) #Comment out to test log only
$output | Out-File -FilePath "log.txt" -Append
}
Write-Host 'done!' -ForegroundColor Green
When I run my script, I get asked for an identity but I want it to be reading the display name off of the CSV file. If I comment out the Set-User line (to do a log only test) it works fine. I am not yet able to attach pictures
(I had a screen shot of my CSV) but the headings for my CSV file are as follows: name, emailaddress, title, department, manager
If I could get finished with this project I would have time to do the powershell training I so despartely need.
Thanks all,
Tom
