$AppRegistrationId = "" $SiteURL = "" Connect-PnPOnline -Url $SiteURL -Interactive -ClientId $AppRegistrationId $SiteName = Get-PnPWeb $ReportDate = Get-Date -Format "yyyy-MM-dd" $InactivePeriod = (Get-Date).AddYears(-1) $ReportOutFile = "./" + $SiteName.Title + " - " + $ListName + " - Version Report - " + $ReportDate + ".csv" "DocName,DocURL,DocID,DocSize(Bytes),Modified,Created" | Out-File -FilePath $ReportOutFile $InactiveFiles = Get-PnPListItem -List "Documents" | Where-Object { $_["Modified"] -lt $InactivePeriod} ForEach ($File in $InactiveFiles){ $File.Id $FileInfo = $File.FieldValues.FileLeafRef + "," + $File.FieldValues.FileRef + "," + $File.Id + "," + $File.FieldValues.File_x0020_Size + "," + $File.FieldValues.Modified + "," + $File.FieldValues.Created $FileInfo | Out-File -FilePath $ReportOutFile -Append }