Back to blog

Office 365 Licence Reports Now Available!

Sep 12, 2012 by Emma Robinson

You can now use our Office 365 License management platform to perform reconciliation tasks for your Office 365 environment. In this post, I’m going take you for a quick spin through the new Office 365 Licencing Reports we now offer.

Firstly, you’ll see 3 new reports in the Nav section under the Licence Reports section.

New Reports in Nav

Subscription Overview

This report provides a high-level overview of the Office 365 Subscriptions applied to your tenant. It shows how many licenses you have purchased and how many are applied. This is designed to give you a quick place to see how many licenses you have bought and used.

Licence Subscription Overview Report

License by Service

The Licence by Service report shows each Office 365 Product (Lync, Exchange and SharePoint etc) and how many licenses are applied per product. Each product pie chart shows the status of the licenses. A Success Status means the user is Licenced, the Disabled status means they are not licensed for this product. Other statuses may include Error or Pending Input, which require an administrator to intervene to apply for the license correctly.

License by Service Report

License by User

This is where it gets meaty and delicious. This report allows you to see exactly which license is applied to which user.

License by User report

Using Filters with the new report

This report includes the ability to filter certain elements to create a custom license report based on your needs. For example, to see a list of all the users with an E3 licence.

  1. Click the Filters button in the top right of the report
  2. Click Add Filter
  3. Select Office 365 Subscription in the Drop Down and type Office 365 (Plan E3) into the text box.
  4. Click Generate

Filter by Office 365 E3 Plan

You now have a list of everyone with an E3 plan!

Want to know how many Shared mailboxes have licenses applied to them? Easy! Follow the steps above, but instead of choosing Office 365 Subscription in the drop-down, choose RecipientType. Then change the next dropdown to Does Not Equal and type UserMailbox into the text box. Like this:

Shared Mailbox with Licences

You now have a list of all Non-User Mailboxes with licenses. Bear in mind that Shared Mailboxes don’t need a license in Office 365, so you may be paying extra for licenses that you don’t need.

Lastly, let’s find out if we’ve remembered to apply licenses to all mailboxes created in the past week. This time choose CreationDate from the first Dropdown. Then change the next dropdown to Greater Then and type a date from last week into the text box in the following format YYYY-MM-DD. Like this:

Users Added in the Last Week

You can now see the user accounts created in the past week and the licenses applied to them. There you have it!