search

pnp / script-samples

A sample gallery of scripts to manage all things Microsoft 365.
https://pnp.github.io/script-samples/
MIT License
223 stars 139 forks source link

Site object does not contain Usage property so export fails #528

Open mblennegard opened 1 year ago

mblennegard commented 1 year ago

The script at https://github.com/pnp/script-samples/tree/main/scripts/spo-export-site-usage-reports fails. When checking it seems that the Site object (stored in the $Reports variable) does not contain the Usage property.

Has something changed between PnP.PowerShell versions? I have tested with PnP.PowerShell 1.12.0 and PnP.PowerShell 2.1.1, but same thing.

ValerasNarbutas commented 1 year ago

@pkbullock i can investigate and fix if required

willobar commented 1 year ago

I am having the same issue.

reshmee011 commented 4 months ago

Usage property can be retrieved 

 foreach ($Report in $Reports) {
            try{
            $report = get-pnptenantsite -Identity $Report.Url -Detailed 
            Connect-PnPOnline -Url $Report.Url -Interactive
            $site = get-pnpsite -Includes Usage
            }
            catch{
                Write-Host "Error in getting site usage report:" $_.Exception.Message -ForegroundColor Red
            }
  <#Add desired properties to export by referencing
 $Site.Usage.Hits
}

However the value of $Site.Usage.Hits, $Site.Usage.Visits, etc.. are 0 except $Site.Usage.Storage and $Site.Usage.StoragePercentageUsed

I could not find out how to get these values, either the script can be amended to remove the usage data or comment added that the usage data are not returned for SharePoint Online.