this post was submitted on 19 Feb 2024
19 points (95.2% liked)

Sysadmin

7566 readers
1 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:
!lemmy@lemmy.ml
!lemmyworld@lemmy.world
!lemmy_support@lemmy.ml
!support@lemmy.world

founded 1 year ago
MODERATORS
 

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
[–] Zachariah@lemmy.world 1 points 7 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)

[–] HC4L@lemmy.world 1 points 5 months ago

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