Office 365 Licence Reports Now Available!
You can now use Cogmotive Reports 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 licences you have purchased and how many are applied. This is designed to give you a quick place to see how many licences you have bought and used.
Licence Subscription Overview Report
Licence by Service
The Licence by Service report shows each Office 365 Product (Lync, Exchange and SharePoint etc) and how many licences are applied per product. Each product pie chart shows the status of the licences. A Success Status means they user is Licenced, the Disabled status means they are not licenced for this product. Other status’s may include Error or Pending Input, which require an administrator to intervene to apply the licence correctly.
Licence by Service Report
Licence by User
This is where it gets meaty and delicious. This report allows you to see exactly which licence is applied to which user.
Licence by User report
Using Filters with the new report
This report includes the ability to filter certain elements to create a custom licence 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
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 licences 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 drop down 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 licences. Bear in mind that Shared Mailboxes don’t need a licence in Office 365, so you may be paying extra for licence’s that you don’t need.
Lastly, let’s find out if we’ve remembered to apply licences to all mailboxes created in the past week. This time choose CreationDate from the first Drop down. Then change the next drop down 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 licences applied to them.
There you have it!