Import-Module ActiveDirectory

$fileImport= ‘C:\TEMP\tel.csv’
$LogFile= “c:\temp\LOG_PhoneNumHistory_$(get-date -Format “yyyyMMddHHmmss”).csv”
$Res=@()

$lst=Import-Csv -Path $fileImport -Delimiter “;”

foreach($enr in $lst){

Write-Host $enr.Account ‘ –> ‘ $enr.tel
$userAD=””
$userAD=Get-ADUser -Identity $enr.Account -Properties OfficePhone

if($userAD -eq “”){
$DataCollect = New-Object System.object
$DataCollect | Add-Member -name ‘FILESAMAccountName’ -MemberType NoteProperty -Value $enr.Account
$DataCollect | Add-Member -name ‘ADSAMAccountName’ -MemberType NoteProperty -Value “Not in directory”
$DataCollect | Add-Member -name ‘OfficePhoneOLD’ -MemberType NoteProperty -Value “”
$DataCollect | Add-Member -name ‘OfficePhoneNEW’ -MemberType NoteProperty -Value “”


}else{
$userOfficeNEW=$(“{0:+33 # ## ## ## ##}” -f [int]$enr.tel)

$DataCollect = New-Object System.object
$DataCollect | Add-Member -name ‘FILESAMAccountName’ -MemberType NoteProperty -Value $enr.Account
$DataCollect | Add-Member -name ‘ADSAMAccountName’ -MemberType NoteProperty -Value $userAD.SamAccountName
$DataCollect | Add-Member -name ‘OfficePhoneOLD’ -MemberType NoteProperty -Value $userAD.OfficePhone
$DataCollect | Add-Member -name ‘OfficePhoneNEW’ -MemberType NoteProperty -Value $userOfficeNEW

$userAD | Set-ADUser -OfficePhone $userOfficeNEW
}

$Res+=$DataCollect
}

$Res | Export-Csv $LogFile -Encoding UTF8 -Delimiter “;”