$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 ******** }
本文链接: https://www.pstips.net/query-use-id-and-name-then-push-to-db.html
请尊重原作者和编辑的辛勤劳动,欢迎转载,并注明出处!
请尊重原作者和编辑的辛勤劳动,欢迎转载,并注明出处!