I want a report that shows…

a list of user base license assignment and last usage date


A table report that shows username (UPN), department, 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, Teams).

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

What questions does this report address?

Which user has which license assigned?

Licenses can be expensive and so one of the aspects of managing this cost is knowing who has which license assigned to them. This report shows you that information.

When was each main workload accessed by users?

Having a license assigned to a user, and that user making use of a workload associated with that license can be two distinct things. This report will make it clear which users access which workload.

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

If users have not accessed particular workloads in a long time, perhaps their license can be downgraded? This report will give you some information to help you make that sort of decision, saving your organization money, or allowing for advanced licensed 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, and can be used by both IT Administrators, License managers, Finance manager and Business managers. For more details around the Nova platform please click here


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

PHP Code Snippets Powered By : XYZScripts.com