How to export all users in the Administration Center to a list
How to export all users in the Administration Center to a list
SYMPTOMS
This article will help you to export all users in the Administration Center to a spread list.
RESOLUTION
Here is the action plan about how to export all users in the Administration Center to a list, currently it can be done with Online Services Migration Tool:
1.Download and install the Microsoft Online Services Migration Tool:
64-bit: https://www.microsoft.com/downloads/en/details.aspx?FamilyID=5547634C-5E49-4DBD-B6B0-457B38A75F33
Note: For Windows XP client, it may need you to install .Net framework 2.0 and Windows PowerShell 1.0 first:
.Net framework 2.0:
Windows PowerShell 1.0:
https://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx
2. Click Start->Programs->Microsoft Online Services->Migration->Migration command Shell
3. At the PowerShell prompt, type the following commands and press enter
$Admin=Get-Credential (Press enter and it will ask you the admin’s username and password)
Get-MSOnlineUser -Administrators -Credential $Admin | Select-Object Displayname, Identity >Admins.csv (Press Enter)
Get-MSOnlineUser -Enabled -Credential $Admin | Select-Object Displayname, Identity >EnabledUsers.csv (Press Enter)
Get-MSOnlineUser -Disabled -Credential $Admin | Select-Object Displayname, Identity >DisabledUsers.csv (Press Enter)
Note: These 3 commands will export 3 lists in the current folder (C:\Documents and Settings\current user\): one list for all admins, one for all enabled users and one for all disabled users in your organization.
MORE INFORMATION
https://www.microsoft.com/online/help/en-us/helphowto/f83a224b-53c5-48b4-8e72-327571c4555e.htm
APPLY TO
- Microsoft Business Productivity Online Standard
Suite
- Microsoft sharepoint online