SOLVED

Sharepoint File collaboration report

Copper Contributor

Is there a way to find out what documents in SharePoint (org wide) that have had multiple users editing them and or multiple users viewing them at one time. OR is there anything that can be found about all users that have edited a document without having to manually touch each document.

1 Reply
best response confirmed by JordanT370 (Copper Contributor)
Solution

Hi @JordanT370, I think you can use one of two MS Graph endpoints to get this information per file:

 

https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/listitemversion_get?view=odsp-grap...

https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/activities_list?view=odsp-graph-on...

 

If you're looking for inspiration for a PnP PowerShell script to get an entire report, you can check my blog post with an example of a script: https://michalkornet.com/2023/09/19/Report-of-SharePoint-Files-Incidents.html. It retrieves a different set of data, but you can use it as a base to get just the edit actions.

1 best response

Accepted Solutions
best response confirmed by JordanT370 (Copper Contributor)
Solution

Hi @JordanT370, I think you can use one of two MS Graph endpoints to get this information per file:

 

https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/listitemversion_get?view=odsp-grap...

https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/activities_list?view=odsp-graph-on...

 

If you're looking for inspiration for a PnP PowerShell script to get an entire report, you can check my blog post with an example of a script: https://michalkornet.com/2023/09/19/Report-of-SharePoint-Files-Incidents.html. It retrieves a different set of data, but you can use it as a base to get just the edit actions.

View solution in original post