Excel Archives - darrenjrobinson - Bespoke Identity and Access Management Solutions

February 11, 2021February 11, 2021

Getting Microsoft 365 Individual User Usage Reports with PowerShell

<img width="640" height="208" src="https://i0.wp.com/blog.darrenjrobinson.com/wp-content/uploads/2021/02/Microsoft-365-User-Usage-Report-Exported-Spreadsheet-Example-640px.png?resize=640%2C208&ssl=1" class="attachment-twentyseventeen-featured-image size-twentyseventeen-featured-image wp-post-image" alt="" srcset="https://i0.wp.com/blog.darrenjrobinson.com/wp-content/uploads/2021/02/Microsoft-365-User-Usage-Report-Exported-Spreadsheet-Example-640px.png?w=640&ssl=1 640w, https://i0.wp.com/blog.darrenjrobinson.com/wp-content/uploads/2021/02/Microsoft-365-User-Usage-Report-Exported-Spreadsheet-Example-640px.png?resize=300%2C98&ssl=1 300w" sizes="(max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px" />

The ability to obtain Individual User Usage Reports has been possible in Office365 for many years. However, they were only available from each individual service such as Teams, OneDrive, Exchange, SharePoint and Yammer. If you wanted a holistic view you needed to query each of the services API’s and collate the responses for each identity.… keep reading