Office 365 Licence Reports Now Available!
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.
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.
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 User
This is where it gets meaty and delicious. This report allows you to see exactly which license is applied to which user.
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.
- Click the Filters button in the top right of the report
- Click Add Filter
- Select Office 365 Subscription in the Drop Down and type Office 365 (Plan E3) into the text box.
- Click Generate
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:
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:
You can now see the user accounts created in the past week and the licenses applied to them. There you have it!