Forum Discussion
Report for unique permissions for all subsites and lists and users on Sharepoint Online
I am searching for a script or a tool that generates reports by digging through our complete Sharepoint Online Sites and Subsites and doclibs within this Sites and Subsites. I have (a compliance ...
This is where investing in a third-party tool such as AvePoint or Sharegate would do the trick, as they are purpose-built for exactly that requirement (and more).
Depending on how much time you want to invest in it yourself you could use office graph with PowerShell (or another language): https://developer.microsoft.com/en-us/graph/ which is what AvePoint, ShareGate and all the others generally use to pull the information.
The other option is to use the SharePoint powershell module in conjuction with some other powershell modules like SharePoint SDK - https://www.powershellgallery.com/packages/SharePointSDK/2.1.0
You should be able to get most of the information you are after with these and a few for loops.
It will come down to a time investment vs paying a monthly fee.
