PowerShell查询域用户工号及显示名称 并更新到数据库

$ldaps=Invoke-Sqlcmd -ServerInstance 10.2.6.5 -Database SLB_LDAP -Query "SELECT ldap from slb_ldap" -Username sa -Password ********

for($i=0;$i -lt $ldaps.ldap.length;$i++){
$ldap=$ldaps.ldap[$i]
$info=Get-ADUser $ldap -Properties EmployeeNumber ,Displayname
$gin=$info.EmployeeNumber
$dis=$info.DisplayName
Invoke-Sqlcmd -ServerInstance 10.2.6.5 -Database SLB_LDAP -Query "update slb_ldap set  Name='$dis'       where LDAP = '$ldap' "  -Username sa -Password ********
Invoke-Sqlcmd -ServerInstance 10.2.6.5 -Database SLB_LDAP -Query "update slb_ldap set  Gin='$gin'  where LDAP = '$ldap' "  -Username sa -Password ********
}