#-----------------------------------------------------------------------------------------------
# Script created by Chris Steding
#
# This script will update AD attributes for users imported from csv file
#
# csv file format:
# SamAccountName,Title,MobilePhone,OfficePhone,city,EmailAddress,Department,Office
#
# Remember to edit the -SearchBase to the correct domain name.
#-----------------------------------------------------------------------------------------------
# Import AD Module
Import-Module ActiveDirectory
write-Host 'Starting to update AD Attributes.......' -NoNewline -ForegroundColor Yellow
# Import CSV into variable $users
$users = Import-Csv -Path .\info12.csv
# Loop through CSV and update users if the exist in CVS file
foreach ($user in $users)
{
#Search in specified OU and Update existing attributes
Get-ADUser -Filter "SamAccountName -eq '$($user.samaccountname)'" |
#Set-ADUser -City $($user.City) -State $($user.State)
Set-ADUser -Description $($user.Description) -Title $($user.Title) -OfficePhone $($user.officephone) -MobilePhone $($user.mobile)
}
Write-Host 'done!' -ForegroundColor Green

没有大佬吗

耐心等待中~~~~

就是一个利用excel添加域控用户的脚本

这个脚本主要用处如下：
$users = Import-Csv -Path .\info12.csv | 本代码说明如下：
导入info12.csv 文件，此文件中包含有用户信息，同进将用户信息赋值给变量
foreach ($user in $users)
{
#Search in specified OU and Update existing attributes
Get-ADUser -Filter "SamAccountName -eq '$($user.samaccountname)'" |
#Set-ADUser -City $($user.City) -State $($user.State)
Set-ADUser -Description $($user.Description) -Title $($user.Title) -OfficePhone $($user.officephone) -MobilePhone $($user.mobile)
}
上述代码为利用Foreach循环，对每个账号遍历执行如下操作。
获取AD中账号属性信息，并设置描述、职位、电话、手机号等信息。
Set-ADUser -Description $($user.Description) -Title $($user.Title) -OfficePhone $($user.officephone) -MobilePhone $($user.mobile)
希望对你有所帮助。