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

DarraignTheSane@lemmy.world

00Lemming@lemmy.world

L3s@lemmy.world

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

submitted 7 months ago* (last edited 7 months ago) by HC4L@lemmy.world to c/sysadmin@lemmy.world

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.

you are viewing a single comment's thread
view the rest of the comments

[–] 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)