SOLVED

SharePoint Online Permission Review

%3CLINGO-SUB%20id%3D%22lingo-sub-1091601%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20Permission%20Review%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091601%22%20slang%3D%22en-US%22%3E%3CP%3EHey!%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20started%20to%20manage%20an%20existing%20SharePoint%20Online%20tenant%20for%20a%20pretty%20large%20company.%20They%20are%20using%20SharePoint%20Online%20as%20a%20document%20store%20with%20about%20500GB%20in%20one%20document%20library.%26nbsp%3B%20The%20previous%20IT%20had%20had%20them%20connected%20with%20WebDev%20connections%20to%20the%20site%20%2F%20doc%20library%20and%20going%20down%20though%20the%20folder%20and%20file%20structure%20there%20are%20tons%20of%20individual%20permissions%20attributed%20to%20these%20folders%20to%20allow%20or%20restrict%20access%20to%20the%20content.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20questions%20is%2C%20would%20it%20be%20possible%20to%20review%20all%20permissions%20within%20the%20site%20allowing%20me%20to%20see%2C%20which%20group%20or%20user%20has%20access%20to%20a%20certain%20folder%20%2F%20file%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIdeally%2C%20I'd%20like%20to%20try%20and%20pull%20a%20full%20permissions%20report%20and%20export%20to%20CSV%20which%20can%20be%20easily%20reviewed.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20of%20any%20tools%20or%20powershell%20scrips%20I%20could%20use%20to%20give%20me%20this%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1091601%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESecurity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1091838%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20Permission%20Review%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091838%22%20slang%3D%22en-US%22%3EUnfortunately%20in%20SPO%20we%20don't%20have%20this%20feature....you%20can%20generate%20a%20sharing%20report%20for%20a%20site%2C%20but%20this%20sharing%20report%20is%20not%20going%20to%20give%20you%20all%20the%20permissions%20applied%20on%20documents%20of%20the%20site....so%20I%20would%20recommend%20you%20to%20check%20this%20sharing%20report%20and%20then%20write%20your%20own%20permissions%20report%20using%20CSOM%20SPO%20API%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1091935%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20Permission%20Review%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091935%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F128498%22%20target%3D%22_blank%22%3E%40Enzo%20Faranda%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20writing%20a%20report%20is%20too%20daunting%20then%20purchase%20a%20good%20SharePoint%20Management%20Tool%20like%20ShareGate%2C%20that%20will%20give%20a%20report%20that%20you%20are%20looking%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1091972%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20Permission%20Review%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1091972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F128498%22%20target%3D%22_blank%22%3E%40Enzo%20Faranda%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20forgot%20to%20say%20-%20you%20can%20download%20a%20free%20trial%20of%20ShareGate%20to%20see%20if%20it%20does%20what%20you%20need%20although%20it%20does%20skip%20random%20content%20for%20trial%20purposes.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hey! 

I've started to manage an existing SharePoint Online tenant for a pretty large company. They are using SharePoint Online as a document store with about 500GB in one document library.  The previous IT had had them connected with WebDev connections to the site / doc library and going down though the folder and file structure there are tons of individual permissions attributed to these folders to allow or restrict access to the content. 

 

My questions is, would it be possible to review all permissions within the site allowing me to see, which group or user has access to a certain folder / file? 

 

Ideally, I'd like to try and pull a full permissions report and export to CSV which can be easily reviewed. 

 

Do you know of any tools or powershell scrips I could use to give me this data?

3 Replies
Unfortunately in SPO we don't have this feature....you can generate a sharing report for a site, but this sharing report is not going to give you all the permissions applied on documents of the site....so I would recommend you to check this sharing report and then write your own permissions report using CSOM SPO API

Hi @Enzo Faranda ,

 

If writing a report is too daunting then purchase a good SharePoint Management Tool like ShareGate, that will give a report that you are looking for.

 

Andy

Best Response confirmed by Enzo Faranda (Occasional Contributor)
Solution

@Enzo Faranda 

 

I forgot to say - you can download a free trial of ShareGate to see if it does what you need although it does skip random content for trial purposes.