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:

32-bit: http://www.microsoft.com/downloads/en/details.aspx?familyid=9ed5f4c1-7f0b-4506-a214-32093af6147a&displaylang=en

64-bit: http://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:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en

Windows PowerShell 1.0:

http://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

http://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