Get SharePoint Online usage data

[Oregonfrogger]

Hello,

I'm new here to this group and I have seen some thoughts on getting usage data from SharePoint Online. However, I have not gotten any to work, I think because Microsoft keeps changing things. What I'm looking for specifically is the following: Last activity, created, files viewed, page views, page visits, and files. Is there any discussion on creating something for PnP that will retrieve this information?

Thanks,

Darin

[Barbarur]

That seems a very general question. Not sure if you are looking for a script to retrieve that data?

Last activity and created are fields coming on all the objects (SiteProperties, List, ListItem).

For the Page analytics, you can try Get-PnPSiteAnaliticsData.

[Oregonfrogger]

Sorry about the general question. I’m looking for the information from the site properties with a script to retrieve the data. When I’m on the SharePoint Admin Center, the main view for active sites has the information that is desired. Also if I select one of the sites then select Activity I will get that same information. What I’m looking for is to have a script run daily and populate a list that can be viewed by others in the organization that don’t have access to the admin center. I could go to the admin center and export the information into a csv, but I would like to do this all in a script and avoid any manual processes. If I can get the information in red below with a script that would be what I’m looking for. ***@***.*** I looked at the Get-PnPSiteAnaliticsData and I’m not seeing the information that I’m looking for from the available data this cmdlet gives. From: Barbarur ***@***.***> Sent: Wednesday, May 29, 2024 6:09 AM To: pnp/powershell ***@***.***> Cc: Darin Colgan ***@***.***>; Author ***@***.***> Subject: Re: [pnp/powershell] Get SharePoint Online usage data (Discussion #3980) WARNING: This email is from outside of the Oregon Judicial Department. If links or files in this email are unexpected, even if from an email address you trust, please call the sender on the phone and verify them before you click. That seems a very general question. Not sure if you are looking for a script to retrieve that data? Last activity and created are fields coming on all the objects (SiteProperties, List, ListItem). For the Page analytics, you can try Get-PnPSiteAnaliticsData. — Reply to this email directly, view it on GitHub<#3980 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHTV45TQDFWFLWMHKX5E6ELZEXHP3AVCNFSM6AAAAABINOZM7SVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TKOJTGY2DK>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

[Barbarur]

I think you can start with something like this:

Get-PnPTenantSite | Export-Csv "$Env:USERPROFILE\Documents\SiteCollectionReport.csv" -NoTypeInformation

[Oregonfrogger]

[Oregonfrogger]

Unfortunately, that cmdlet doesn’t have the following information: Last Activity Created by Files viewed Page views Page visits Files From: Barbarur ***@***.***> Sent: Wednesday, May 29, 2024 7:25 AM To: pnp/powershell ***@***.***> Cc: Darin Colgan ***@***.***>; Author ***@***.***> Subject: Re: [pnp/powershell] Get SharePoint Online usage data (Discussion #3980) WARNING: This email is from outside of the Oregon Judicial Department. If links or files in this email are unexpected, even if from an email address you trust, please call the sender on the phone and verify them before you click. I think you can start with something like this: Get-PnPTenantSite | Export-Csv "$Env:USERPROFILE\Documents\SiteCollectionReport.csv" -NoTypeInformation — Reply to this email directly, view it on GitHub<#3980 (reply in thread)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHTV45WFMVHHPSGNIIXFMPTZEXQMFAVCNFSM6AAAAABINOZM7SVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TKOJUGUZTM>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>