Usage Reports - Data Inconsistency

%3CLINGO-SUB%20id%3D%22lingo-sub-162822%22%20slang%3D%22en-US%22%3EUsage%20Reports%20-%20Data%20Inconsistency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-162822%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20struggling%20with%20the%20data%20in%20usage%20reports%20especially%20%3CEM%3ESharePoint%20Site%20Usage%20Report%3C%2FEM%3E%20and%20%3CEM%3EOneDrive%20Usage%20Report.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EWhen%20I%20export%20the%20details%20CSV%20from%20SharePoint%20Site%20Usage%2C%20it%20contains%20an%20entry%20for%20OneDrive%20Collection%20i.e.%20tenant-my.sharepoint.com.%20The%26nbsp%3Bfile-count%20number%20here%20beats%20me.%20When%20I%20try%20to%20correlate%20this%20number%20with%20the%20OneDrive%20Usage%2C%20there%20is%20no%20URL%20which%20matches%20this%20number.%20So%2C%20what%20is%20this%20OneDrive%20root%20entry%20and%20the%20number%20of%20files%20therein%20in%20the%20SharePoint%20Site%20Usage%3F%26nbsp%3B%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EYes%2C%20I%20know%20OneDrive-fB%20is%20SharePoint%2C%20but%20then%20what%20is%20the%20point%20of%20including%20that%20in%20the%20SharePoint%20Site%20Usage%20when%20there%20is%20a%20separate%20OneDrive%20Usage%20Report%3F%20I%20mean%20it%20just%20adds%20to%20the%20confusion%20and%20moreover%20inflates%20the%20number.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%222%22%3E%0A%3CLI%3EThe%20other%20confusion%20is%20about%26nbsp%3Bconflating%20System%20Files%20with%20User%20Files.%20Why%3F%20Our%20management%20doesn't%20give%20a%20**bleep**%20about%20the%20number%20of%20system%20files%20in%20each%20site.%20They%20only%20want%20user-adoption%20and%20usage%2C%20and%20hence%20only%20user%20files.%20Currently%20the%20mixed%20up%20numbers%20create%20tremendous%20confusion%20as%20this%20report%20does%20not%20match%20with%26nbsp%3Bthe%20user%20documents%20on%20any%20site.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3ECan%20anything%20be%20done%20about%20this%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%223%22%3E%0A%3CLI%3EThe%20SharePoint%20Site%20Usage%20Report%20gives%20data%20only%20for%20top-level%20site-collections%20and%20O365%20Group%20sites.%20Is%20the%20file-count%20number%20against%20the%20top-level%20site-collection%20a%20roll-up%20of%20all%20sub-sites%3F%20Anyway%2C%20this%20doesn't%20serve%20the%20purpose%20for%20our%20management%20reporting.%20We%20have%20a%20lot%20of%20sub-sites%20under%20a%20top-level%20site-collection%2C%20for%20example%20-%20we%20have%26nbsp%3Bmany%20project%20sub-sites%20under%20a%20%22Projects%22%20site-collection.%20And%2C%20we%20need%20usage%20report%20numbers%20for%20each%20of%20the%20project%2C%20which%20is%20not%20there.%20A%20rolled-up%20number%20for%20the%20site-collection%20is%20meaningless.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3ECan%20anything%20be%20done%20about%20this%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20start%3D%224%22%3E%0A%3CLI%3EAnd%20lastly%2C%20the%26nbsp%3Bsum%20of%20%22%3CU%3E%3CEM%3EActive%20File%20Count%3C%2FEM%3E%3C%2FU%3E%22%20in%20%3CEM%3ESharePoint%20Site%20Usage%20Report%3C%2FEM%3E%20and%20the%20sum%20of%20%22%3CU%3E%3CEM%3EViewed%20or%20Edited%20File%20Count%3C%2FEM%3E%3C%2FU%3E%22%20in%20%3CEM%3ESharePoint%20Activity%20Report%3C%2FEM%3E%3B%20do%20%3CSTRONG%3Enot%3C%2FSTRONG%3E%20match!%20Is%20there%20anything%20I%20am%20missing%20here%3F%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20are%20struggling%20to%20find%20value%20in%20the%20existing%20usage%20reports.%20Unless%20the%20above%20points%20are%20addressed%2C%20I%20think%20I%20will%20have%20to%26nbsp%3Bspend%20considerable%20time%20and%20effort%26nbsp%3Bwith%20PowerShell%2C%20and%20then%20spend%20more%20time%20merging%20the%20O365%20Groups%20site%20data%20with%20my%20custom%20data.%20I%20am%20certainly%20not%20too%20inclined%20to%20do%20this.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F210%22%20target%3D%22_blank%22%3E%40Anne%20Michels%3C%2FA%3E%26nbsp%3Bcan%20you%20help%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-162822%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%20center%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-169730%22%20slang%3D%22en-US%22%3ERe%3A%20Usage%20Reports%20-%20Data%20Inconsistency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-169730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F210%22%20target%3D%22_blank%22%3E%40Anne%20Michels%3C%2FA%3E%26nbsp%3BAny%20thoughts%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

I've been struggling with the data in usage reports especially SharePoint Site Usage Report and OneDrive Usage Report.

 

  1. When I export the details CSV from SharePoint Site Usage, it contains an entry for OneDrive Collection i.e. tenant-my.sharepoint.com. The file-count number here beats me. When I try to correlate this number with the OneDrive Usage, there is no URL which matches this number. So, what is this OneDrive root entry and the number of files therein in the SharePoint Site Usage? 

Yes, I know OneDrive-fB is SharePoint, but then what is the point of including that in the SharePoint Site Usage when there is a separate OneDrive Usage Report? I mean it just adds to the confusion and moreover inflates the number. 

 

 

  1. The other confusion is about conflating System Files with User Files. Why? Our management doesn't give a **bleep** about the number of system files in each site. They only want user-adoption and usage, and hence only user files. Currently the mixed up numbers create tremendous confusion as this report does not match with the user documents on any site.

Can anything be done about this?

 

 

  1. The SharePoint Site Usage Report gives data only for top-level site-collections and O365 Group sites. Is the file-count number against the top-level site-collection a roll-up of all sub-sites? Anyway, this doesn't serve the purpose for our management reporting. We have a lot of sub-sites under a top-level site-collection, for example - we have many project sub-sites under a "Projects" site-collection. And, we need usage report numbers for each of the project, which is not there. A rolled-up number for the site-collection is meaningless.

Can anything be done about this?

 

 

  1. And lastly, the sum of "Active File Count" in SharePoint Site Usage Report and the sum of "Viewed or Edited File Count" in SharePoint Activity Report; do not match! Is there anything I am missing here?

 

We are struggling to find value in the existing usage reports. Unless the above points are addressed, I think I will have to spend considerable time and effort with PowerShell, and then spend more time merging the O365 Groups site data with my custom data. I am certainly not too inclined to do this. 

 

@Anne Michels can you help?

 

1 Reply
Highlighted

@Anne Michels Any thoughts?