E14- Bulk update Phone

 

 

Name	BusinessPhone
ABC.DEF	1234-5678

 

1. [PS] C:\>$csvinfo = Import-Csv   extension.csv

2. [PS] C:\>foreach ($line in $csvinfo) {Get-User -Identity "$($line.name)" | ft Name,Phone >>c:\before_ext-1.txt }

3. [PS] C:\>foreach ($line in $csvinfo) {Get-User -Identity "$($line.name)" | Set-User -Phone "$($Line.Busine
ssPhone)"}

4. [PS] C:\>foreach ($line in $csvinfo) {Get-User -Identity "$($line.name)" | ft Name,Phone >>c:\after_ext-1.txt }

5.. excel 檢核

=IF(A2=D2,"Y","No")