Introduction- O365 Usage Report

In this blog, we will talk about O365 Usage Reports. It is very simple to obtain the O365 Usage Reports. All you have to do is log in to the admin panel and then follow a few steps to obtain your usage report. Read the blog to understand the steps. 

Project Background

This project was all about understanding how to check your different licenses using the Admin Centre access in Microsoft to obtain the O365 Usage Report.

You can find the list of licenses under the admin center licenses section as seen below:

Licenses – Microsoft 365 admin center

O365 Usage Reports

After logging in, navigate to “Your Products” to check your active licenses.

There it will show you the listed subscriptions.

Subscriptions – Microsoft 365 admin center

Note: Some of them are monthly, others are yearly. You can see this based on renewal date.

As you see below it shows:

  1. Business standard 40- Renewed yearly
  2. Office 35 E3 15- Renewed yearly
  3. Microsoft 365 business standard 9- Renewed monthly

O365 Usage Reports

O365 Usage Report

To further drill down the report, you should check its usage.

Here in the link below we see a few of the charts.

Usage – Microsoft 365 admin center

Check the 60 Active users list where it shows the number of unique Active users per Microsoft 365 Service, and then click on view more to see the user wise report.

 

O365 Usage Reports

O365 Usage Report For Individual User

In this report it can be seen how we could drill down further for per user report.

Steps to follow are as below:

  1. Go to the Activation Tab that shows the table for User extract below
  2. Use another report called Active users

After that, click on Activation and export the list.

O365 Usage Reports

Find the active users and “Last activity date for exchange” and VLOOKUP, and add this to the report.

We have assumed here, if the user does not use the organization email that means the user is active in the system or not. Based on clients input, this license can then be saved.

O365 Usage Reports

Conclusion- O365 Usage Report

We now have the report with the User name and Activity last date for exchange.

You can easily see how people in your business are using Microsoft 365 services. For example, you can identify who is using a service a lot and reaching quotas, or who may not need a Microsoft 365 license at all, and you could get rid of the license in the next month billing accordingly to save costs.