After a large migration I'd like to review all SharePoint groups and permissions via an algorithm but before I do I need to export them.

Is there some powershell I can run to output this throughout the farm (including cases where I have multiple nested sites)?

1 Answer 1


Please check if below Powershell command helps you:

Get-SPOSite | ForEach-Object {Get-SPOUser -Site $_.Url} | Format-Table -Wrap -AutoSize | Out-File c:\UsersReport.txt -Force -Width 360 -Append

Reference - https://technet.microsoft.com/en-us/library/mt771884.aspx

Additionally you can also have a look at this article: https://www.andreasbijl.com/get-groups-with-users-from-sharepoint-online/

  • The question is about SharePoint Online. Jan 23, 2018 at 5:27
  • Updated the answer
    – Sagar
    Jan 23, 2018 at 5:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.