I want a report that shows…

license assignment by department


This heat map shows the assigned count of license types over the department the user is in. The X axis of the heat map is the license set assigned, and the Y axis is the department.

The department is limited to 100 results. All departments exceeding 100 are summarized in the ‘Other’ section. If you want more or less departments the report can be configured for this. As well you could limit the report to departments in a specific country by adding an additional filter.

What questions does this report address?

How many licenses of each type is allocated to each department?

A useful report to determine how licenses are distributed across an organisation. Also useful is your organisation is using, or considering, any kind of charge-back model.

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