Usage Reports

Automate and consolidate usage reports from Microsoft portals into a more useful “superview” with sapio365

Microsoft 365 usage reports include recorded events of users and groups to inform you about their last activity date, their usage frequency and other usage information that help with license assignment decisions.

Visio and Project activity reports

To access the Visio and Project activity reports in an elevated session, an app session, or a role session, the application must be assigned the Entra Reports Reader role. Until automatic assignment is integrated in the next version of sapio365, you can use sapio365 to assign this role.

In the Tenant → Roles & administrators module, add the Reports Reader role to the sapio365 application’s associated service principal (usually the same name as the app).
Return to where the elevated session, app session, or sapio365 RBAC credential is managed, and grant consent to the application’s permissions again.

See the list of available Usage Reports

You can combine multiple reports into one if they are all using the same Extra info from cache.

	Usage report	Extra info from cache
1	Copilot usage	Users
2	Copilot user count trend	none
3	Email activity	Users
4	Email app activity	Users
5	Forms activity	Users
6	Mailbox usage	Users
7	Microsoft 365 activations	Users
8	Microsoft 365 active users	Users
9	Microsoft 365 apps usage	Users
10	Microsoft 365 groups activity	Groups
11	Microsoft Graph API usage	Applications
12	OneDrive activity	Users
13	OneDrive usage	Users
14	Project activity	Users
15	SharePoint activity	Users
16	SharePoint site usage	Sites
17	Skype for Business activity	Users
18	Skype for Business device usage	Users
19	Teams device usage	Users
20	Teams team activity	Groups
21	Teams user activity	Users
22	Visio activity	Users
23	Viva Engage activity	Users
24	Viva Engage device usage	Users
25	Viva Engage groups activity	none

sapio365 lets you retrieve data from usage reports in Microsoft 365 and create your own custom reports.

Select a usage report or combine several of them to agglomerate information about users or groups.
Add more information to the report from cached data. Choose user properties for user activity reports or group properties for group activity reports.
Select the View to apply.
Choose how much data you wish to retrieve. The larger the interval, the longer it will take to retrieve the information.

There are several options available, from building your Usage Reports GridView right away to scheduling an export of the data.

Reset the selection of the reports, extra information, View to apply and time range.
Save the current settings for the selected reports, Views and options. We suggest the name of the View as the title. You'll see your saved settings on the right under ‘Saved Usage Report settings’ (10).
Schedule a report based on the current selected reports and settings. Various options are available: recurrence. email, etc. You'll see the reports you’ve scheduled listed on the right under ‘Scheduled Usage Reports’ (10).
Create a Usage Report right away.
Email the exported Usage Report right away.
See your saved and scheduled Usage Reports. Click on one and you’ll see its configuration on the left. Click on the “three dot” icon to see a list of actions you can take, including editing your configuration, or deleting a scheduled report.

Click to see the list of Views that have been published.
Watch a short video on Usage Reports. (see top of page)