question

FannyJACQUET-2278 avatar image
0 Votes"
FannyJACQUET-2278 asked ·

how to get advanced statistics on the use of documents in a library in sharepoint online with powershell

Hello community !

It's all in the title :-)

I'm trying to retrieve advanced stats of document usage in a data library (in SPO) with powershell.

Can you help me please?

Very thanks.

office-sharepoint-online
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ·

Hi @FannyJACQUET-2278 ,

Per my understanding, you could try to the built-in feature: Audit log reports.

You can use the audit log reports provided with SharePoint to view the data in the audit logs for a site collection. You can sort, filter, and analyze this data to determine who has done what with sites, lists, libraries, content types, list items, and library files in the site collection.

===========================================
Go to Site settings->Site Collection Administration->audit log reports->click “Run a custom report”->set the save location, and and restrict the report to the library, and set the date range.
75276-2.jpg
And do some settings as you want:
75235-3.jpg

In the exported data, filter out the library you want.

Similar posts:
Any reports available on Document Library usage
SharePoint metric for Document library : SharePoint Online

================Update1====================

Go to the M365 Admin center>Complicance>Audit, select the library or file and user,time to export the data:
75690-3.jpg
75812-4.jpg

To go to M365 admin center, you could first go to https://YourTanentName-admin.sharepoint.com,then click:
75801-5.jpg
75811-6.jpg


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1.jpg (49.0 KiB)
2.jpg (12.4 KiB)
3.jpg (109.4 KiB)
4.jpg (47.3 KiB)
3.jpg (34.4 KiB)
4.jpg (153.3 KiB)
5.jpg (15.5 KiB)
6.jpg (33.9 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FannyJACQUET-2278 avatar image
0 Votes"
FannyJACQUET-2278 answered ·

Hi @ElsieLu-MSFT

Very thanks for your response.

But I don't have "Custom Reports" in my Audit Log report


Thanks and have a good day75371-2021-03-08-09h08-54.png



· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FannyJACQUET-2278 ,

You could also get the audit data in M365 Admin center, which is also very convenient. I have updated my answer, please kindly check the Update1 section.

Have a great day! :)

Thanks,
Elsie Lu

0 Votes 0 ·

How are things going? Is there any update?

0 Votes 0 ·
FannyJACQUET-2278 avatar image
0 Votes"
FannyJACQUET-2278 answered ·

Hello @ElsieLu-MSFT

Thanks for your help but my client wanted a script to analyse the audits.

Thanks for your help.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.