Forum Discussion
OneDrive UsageReports
They've tried to explain this in the documentation: https://support.office.com/en-us/article/Office-365-Reports-in-the-Admin-Center-OneDrive-for-Business-activity-8bbe4bf8-221b-46d6-99a5-2fb3c8ef9353?ui=en-US&rs=en-US&ad=US
Refresh dates are 24h/48h, but data can lag sometimes. Activity is any file related activity (save, sync, modify, or share). Anne Michels can probably share more details :)
Hi Vasil,
Is there a way to get to these data from OneDrive Usage Report programaticaly? I mean thru Office Graph API or so? Its great its in admin center and your article perfectly explains everything but I would need to go to that section, export and than model data and so on... with data feed I can connect into some of custom powerBI reports we he build around OneDrive adoption.
ps: I know about out of box O365 Adoption Dashboard but we use custom reports to drive and monitor adoption.
thanks
JK
- StefanFriedMay 20, 2018Iron ContributorOf course this is possible via graph :)
- Jaroslav KarlikMay 20, 2018Brass Contributor
Hi Stefan,
thats what my thought was as well but when you browse thru documentation for that API it supports alot but the last activity on personal site (aka Onedrive) level is not there.
https://developer.microsoft.com/en-us/graph/docs/concepts/onedrive-concept-overviewsecond thought was, right it must be on user profile level, but no luck there either
https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/userone way would be to read last modify date for each file and evaluate lastest one and claim it as last activity date but thats not good for large scale environments, we keep 2PB in onedrive so it will take ages to complete.
- StefanFriedMay 23, 2018Iron Contributor
oh i see...
yes, last activity on your personal site is not covered by graph api.
honestly, i doubt that this will be added
(i'm personally waiting for other APIs (MS Teams) which are still not be available )
but for sure there is a cool powershell cmdlet which can pull this information (but i prefer APIs instead of PowerShell cmdlets)