Microsoft Lystavlen - the Online display board

Lystavlen is the danish word for 'the display board'. This blog is all about sharing the beauty of Microsoft Online Services

Quick Tip: How to list all user profiles in SharePoint Online

Quick Tip: How to list all user profiles in SharePoint Online

  • Comments 8
  • Likes

To list the user profiles of all SharePoint Online users in your tenant you can follow these steps

  1. Navigate to the User Profiles tab in the SharePoint Administration Center and click Manage User Profiles


     

  2. In the "Find profiles" text box type i:0#.f|membership




  3. Click the Find button to see the list of all user profiles


 

Note

  • Currently there is no way to list external users (PALs)
  • In case you wonder - the "f" in the search string means we are using forms based authentication
Comments
  • Great post! thanks.

  • Cool..tip of the day :) Thanks for sharing..

  • Cool but how to export this list?

  • How would a user (non-admin) find a list of all users?

  • Nice tip, thanks.

    Is there any way you can get pass the 50 user limit in the query?

  • a non-admin user can search People and contentclass=SPSPeople AccountName:live.com since all non-anonymous external users are associated with Microsoft account.

  • Great tip thanks

  • Have had a ticket open for days with MS on how to do just this!
    Just need to export this as a csv and work out how to make it only have current users

    The issue I have is when a user leaves there profile stay and HR complain as they then still show in the org charts

    Deleting the profile on SPO will have to be an additional step in the leavers process :(
    I don't like manual processes

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment