Sysadmin

7640 readers

21 users here now

A community dedicated to the profession of IT Systems Administration

No generic Lemmy issue posts please! Posts about Lemmy belong in one of these communities:
[email protected]
[email protected]
[email protected]
[email protected]

founded 1 year ago

MODERATORS

[email protected]

Exporting Sharepoint Online folder permissions to Excel. (lemmy.world)

submitted 8 months ago* (last edited 8 months ago) by [email protected] to c/[email protected]

2 comments fedilink hide all child comments

Hey guys,

Because of the unclear nature of Sharepoint folder permissions we want to make an export to Excel of each folder and the appropriate rights. Explicit rights only is fine but everything together is also fine.

Having tried and tested for hours I cannot seem to find a working script. Using outdated functions, random errors, etc.

Does anyone know a working script for this? A commercial solution (that does nog charge 4000$per year) is also fine. This is becoming an expensive headache for me.

I have already tried all the usual Google hits as well as ChatGPT. None seem to work but also not work with modern authentication when connecting to Sharepoint using Powershell for example which leads me to suspect they are too old.

top 2 comments

sorted by: hot top controversial new old

[–] [email protected] 1 points 6 months ago

As a followup, the function to generate these reports was in Sharepoint Online itself. Somewhat hidden/poorly named.

[–] [email protected] 1 points 8 months ago

I don’t know how to do this within the web interface, but maybe this would work:

Sync the folders to a local machine with onedrive.

Crease a CSV with the rights using PowerShell (example: https://www.netwrix.com/how_to_export_folder_permissions.html)