How Can We Help?
Update user contact details
Create a CSV file with following table format
userPrincipalName | title | firstname | lastname | displayname | department | office | country | mobilephone | phonenumber | fax |
aaa1@redmondcloud.com |
Mr. |
AA Test User |
A TU1 |
AA Test User A TU1 |
IT |
Agnice |
INDIA |
9999999991 |
2222221 |
2323231 |
aaa2@redmondcloud.com |
Mr. |
AA Test User |
A TU2 |
AA Test User A TU2 |
Accounts |
Manappat |
OMAN |
9999999992 |
2222222 |
2323232 |
aaa3@redmondcloud.com |
Mr. |
AA Test User |
A TU3 |
AA Test User A TU3 |
IT |
Agnice |
INDIA |
9999999993 |
2222223 |
2323233 |
Note: “Company name” is replaced with “Office”
Open the powershell ise
Run the following command
Import-Module MSOnline
and
Connect-MsolService
Note: This will prompt you to enter the Global admin username and password.
Now run the following command.
Import-CSV updateaaausers.csv |%{Set-MsolUser -userPrincipalName $_.UserPrincipalName -title $_.title -firstname $_.firstname -lastname $_.lastname -displayname $_.displayname -department $_.department -office $_.office -country $_.country -mobilephone $_.mobilephone -phonenumber $_.phonenumber -fax $_.fax}
Kindly refer this help article, if any module needs to be installed
Troubleshooting “execution of scripts is disabled on this system.”
Set-ExecutionPolicy RemoteSigned
Bypass the error “not digitally signed”
Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass