Users will come to know about Teams add users as...Read More
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:
After logging in, navigate to “Your Products” to check your active licenses.
There it will show you the listed subscriptions.
Note: Some of them are monthly, others are yearly. You can see this based on renewal date.
As you see below it shows:
To further drill down the report, you should check its usage.
Here in the link below we see a few of the charts.
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.
In this report it can be seen how we could drill down further for per user report.
Steps to follow are as below:
After that, click on Activation and export the list.
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.
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.