User base license assignments and last usage date

I want a report that shows…

A list of user base license assignments and last usage date


This table report section shows username (UPN), department, and type of recipient (User, Mailbox, Disabled User), as well as the license in a boolean format (Exchange, OneDrive, SharePoint, Teams).

The report shows the last activity date for the same workloads (Exchange, OneDrive, SharePoint, and Teams).

This report can be used to identify disabled users who have licenses assigned, or users with no activity for XX days and an assigned license, or users that are not using all the capabilities of an advanced license (and could be downgraded).

What questions does this report address?

Which user has which license assigned?

Licenses can be expensive. Having visibility of who has which licenses assigned to them, you can manage this expense more effectively.

When was each main workload accessed by users?

Having a license assigned to a user and having that user utilize the workload associated with that license are two different things. A user might not be actually using the workload they have access to. This report will make it clear which users access which workloads.

Are there users I can downgrade from E5 to E3 or from E3 to E1?

If users have not accessed a workload in a long time, you might want to downgrade their license. This report shows information you can use as you decide if users have appropriate licenses. This could save your organization money or free up advanced licenses to be used in other parts of the organization.

Not signed up for Nova yet?

Nova is a reporting and management platform for Office 365. It can be used by IT administrators, license managers, finance managers, and business managers. Click here to learn more.


The report files are only accessible for members of this community site, to get the ability to download reports register for full access. If you are already registered sign in.

Get help modifying this report

This content is for members only.

Are you new to the site?

Register for full access. If you’re already registered sign in.

Leave a Comment