🎉 Our Office 365 Reporting Tool is now available in Azure Marketplace 🚀
This website uses cookies to improve your experience. We'll assume you're ok with this. Know more.
Azure AD

How to Monitor Users License Changes Report in Microsoft 365

Keeping track of Microsoft 365 licenses can be a constant battle. Inefficient license management leads to overspending on unnecessary licenses, draining your organization's budget. If you're looking for assistance in handling license changes, don't worry. This guide will help you in managing Microsoft 365 license changes to improve cost management practices.

Using Microsoft 365 Purview Portal

Microsoft 365 Permission Required
Global Admin, Role Groups: Audit Manager or Audit Reader.
  • Login to the Microsoft 365 Purview portal.
  • Now select Changed user license from the Activities - friendly names dropdown.
  • After clicking Search, you'll be able to find all the license changes in your Microsoft 365 environment.
Using Microsoft 365 Purview Portal

Using Windows PowerShell

Microsoft 365 Permission Required
Global Admin, Role Groups: Audit Manager or Audit Reader.
  • Connect to the Exchange Online module using the below cmdlet.
  • Windows PowerShell Windows PowerShell
     Connect-ExchangeOnline
  • Now, run the below command to get the license changes in your organization.
  • Windows PowerShell Windows PowerShell
     Search-UnifiedAuditLog -StartDate MM/DD/YYYY -EndDate MM/DD/YYYY  -RecordType "AzureActiveDirectory" -Operations "Change user license" |Format-Table
Using Windows PowerShell

Boost Productivity Through Smart Microsoft 365 License Management

The AdminDroid Azure AD auditing tool provides dedicated reports on license changes with all-inclusive details to ease license optimization. Also, get notified on license assignments and revoking activities to identify and prevent any potential resource misuse.

Implement Advanced Alerting for License Changes

Learn how to use AdminDroids' user license changes default alert template to receive real-time notifications whenever Microsoft 365 licenses are assigned or revoked for a user.

Schedule Reports to Spot Unlicensed Users

Automate license changes reports with the advanced scheduler. Receive them periodically for effortless user license management.

Gain Insights from a Comprehensive License Dashboard

Use the dedicated Microsoft 365 license dashboard data to get an efficient oversight of license management.

Unlock In-Depth Details on Assigned Subscriptions

Make use of AdminDroid’s dedicated report to find the users by subscriptions, ensuring correct subscriptions are assigned to the users.

Utilize Role-Based Access for Managing Licenses

Provide granular access to Microsoft 365 users with AdminDroid's delegation feature for license monitoring activities like group or user license changes.

Retrieve License Expiry Reports in Various Formats

Export detailed license expiration reports in various formats like PDF, CSV, etc., to seamlessly integrate with existing workflows. This allows admins to easily share data for license auditing or user provisioning.

AdminDroid's Microsoft 365 license reporting tool simplifies the license management process by providing detailed reports on user and group license changes. These statistics help in identifying unused licenses, allowing admins to reallocate resources effectively and optimize licensing costs.

Explore a full range of reporting options

Important Tips

Automate license assignments with group-based licensing, eliminating manual work and ensuring everyone has the required access.

Keep track of the user license expiry date to ensure timely renewal and uninterrupted usage of Microsoft 365, maintaining seamless productivity.

Monitor users' license changes and reduce unused subscriptions to optimize the subscription costs in the organization.

Common Errors and Resolution Steps

The following are possible errors and troubleshooting hints while checking the Microsoft 365 license changes report.

Error Inherited license assignment cannot be removed from the user directly. To remove their license, you must remove them from their group.

This error happens when you assign a license to a group, but try to remove the license from the user.

Fix Remove the user from the licensed group to remove the license.

Error Your account doesn’t have permission to view or manage this page in the Microsoft 365 admin center.

This error occurs if the user does not have administrator privileges to access the admin center URL or admin center.

Fix Ensure that the user is assigned with appropriate administrator role while accessing the admin center URL.

Error Audit log search argument startDate (05/05/2024 00:00:00) is later than endDate (04/04/2024 00:00:00).

This issue occurs when the end date is earlier than the start date.

Fix Ensure that the date format is correct, and the end date should be ahead of the start date.

Error License cannot be issued to a user without a usage location specified.

This error occurs because some Microsoft services aren’t available in all locations due to local laws and regulations.

Fix To check and add a user's location, navigate to Azure AD»Users»All users»select the user»Edit properties»Usage location.

Error Set-MgUserLicense: The term Set-MgUserLicense is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

This error occurs when you execute the cmdlet 'Set-MgUserLicense' without installing and connecting to the necessary modules.

Fix You can use the below cmdlet to install the Microsoft Graph Beta module and then connect to the Microsoft Graph PowerShell.
Install-Module Microsoft.Graph
Connect-MgGraph

Frequently Asked Questions

Optimize Your Subscription Usage by Tracking Every License Change in Microsoft 365

How to use audit logs to monitor group-based licensing activity?

How to use audit logs to monitor group-based licensing activity? +

With group-based licensing, you can assign, remove, or change Office 365 licenses for a specific group of users. Monitoring these changes is essential for managing license allocation efficiently and duplicate license assignments.

Microsoft Entra audit logs allow you to identify who made changes to licenses within groups.

  • To find the group-based license changes, navigate to the Microsoft Entra admin center.
  • Go to Audit logs under the Monitoring & health section and use the filters below.
    • Category- GroupManagement
    • Service-Core Directory
    • Activity-Set group license
  • Once applied, click on a row and expand it to view the additional details.
  • Now, click the Modified Properties tab to see the old and new values for the license assignment.
entra-group

With AdminDroid, you can easily audit Microsoft 365 group license changes whenever there's a modification in the Azure AD group license.

  • This report displays details such as activity time, username, group name, group-based license assignment, etc.
  • Monitoring these changes helps you identify groups with unused licenses or features. Thus, you can remove unnecessary licenses from the group and optimize overall licensing costs.
ad-group

Hint: Filter the report based on your preferred license and save it using the Save as View feature. This eliminates the need to reapply filters each time, ensuring efficiency and convenience for future use.

How to check if a Microsoft 365 user license is directly assigned or inherited from the group?

How to check if a Microsoft 365 user license is directly assigned or inherited from the group? +

In Microsoft 365, licenses are assigned to users in two ways. They are:

  • Directly assigned: The license is assigned specifically to the user account.
  • Inherited from a group: The license is assigned to a user through their Microsoft 365 group membership. Most of the larger organizations are using group-based licensing as their preferred method to optimize their license usage.

You can determine whether the user license is directly assigned or inherited from a group by following the below steps:

  • Go to the Microsoft Entra admin center.
  • Navigate to Identity»Billing»Licenses.
  • Click on All products and select a license to get a list of users assigned with that license.
  • On this page, you can determine whether the user's license assignment is direct or inherited from a group, by checking under the Assignment Paths column.
entra-assign
  • As the results are grouped by subscription, you must check each subscription individually to see all licenses assigned to a specific user. This can be challenging and time-consuming in large organizations.

Make use of AdminDroid’s All Licensed Users report to find all the licenses assigned to a specific user along with their assignment paths.

  • In addition, you can access details such as sign-in status, license status, and more to gain deeper insights into user management within your organization.
ad-lic

Tip: To explore any report in AdminDroid, hit Ctrl + Shift + F and type fewer related keywords about the required report. This will show you the relevant reports.

How to update Microsoft 365 user licenses in bulk?

How to update Microsoft 365 user licenses in bulk? +

Implementing bulk license change in Microsoft 365 can streamline the management of user permissions and access to services. This process allows admins to change licenses for multiple users at once, saving time and ensuring consistency.

Here's how to change licenses to multiple users using the Microsoft 365 admin center.

  • Access the Microsoft 365 admin center and navigate to the Users »Active users page.
  • Select the names of the users you want to change licenses to and click Manage product license at the top.
  • In the Manage product licenses pane, select Assign more: Keep the existing licenses and assign more, and click Next.
  • Under Licenses, select the license(s) you want to assign to the desired users.
  • By default, all services included with the licenses are assigned to users. To restrict certain services, simply uncheck the boxes for the services you do not want the users to access.
  • Now, click Save changes, to modify licenses to multiple users.
admin-user

Assign multiple Microsoft 365 user licenses using PowerShell script

However, manually assigning licenses to each user can be time-consuming. To streamline the process, you can use the following script to assign licenses to multiple users by importing a CSV file.

$AddLicenses= @( @{SkuId = <SkuID>}, @{SkuId = <SkuID>})
$UserNames = Import-Csv -Header "UPN" $UserNamesFile
foreach ($Name in $UserNames) {
$UPN = $Name.UPN
Set-MgBetaUserLicense –UserId <UPN> -AddLicenses $AddLicenses -RemoveLicenses @()
}

How to manage guest user license changes in Microsoft 365?

How to manage guest user license changes in Microsoft 365? +

Inviting guest users to collaborate with your organization and assigning licenses to them is essential in certain cases. However, there may be instances where a misconfiguration in license assignment or extended access could compromise your organization's data. Therefore, it is crucial to monitor and manage Microsoft 365 guest user license changes.

  • Login to the Microsoft 365 Purview portal.
  • Under the Activities – friendly names drop-down, select Changed user license.
  • Now add the guest user’s UPN in the Users section.
  • After clicking Search, you'll be able to find all the license changes for the specified guest user in your Microsoft 365.

However, using these native methods to find the license changes for multiple guest users can be a tedious process.

  • To simplify this task, you can use AdminDroid’s report to track all guest user license changes.
  • In this report, you can use the "License Operation" column to find the license change details.
  • Along with the above, this report provides details on all guest user license changes, including the modified plan details, license details, etc.
ad-guest

How to remove unused licenses from Office 365?

How to remove unused licenses from Office 365? +

Neglecting the stale users will lead to severe security threats and unwanted license expenditures. Manage unused licenses in Microsoft 365 by removing licenses from the stale users, using the below methods.

Remove Microsoft 365 user licenses using PowerShell

  • Connect to Microsoft Graph PowerShell and use the below cmdlet to remove Microsoft 365 licenses from user accounts.
Connect-MgGraph
Set-MgUserLicense -UserId "<UPN>" -RemoveLicenses @("<AccountSkuId1>") -AddLicenses @{} 

How to remove the license from multiple users?

  • Navigate to Microsoft 365 admin center, and go to Users»Active users.
  • Select the desired users.
  • Now, select Manage product licenses, then Unassign all and Save changes.
admin-guest

Note: Licenses inherited from a group cannot be removed directly. To remove such group-based license assignments, you must remove the user from the group that assigned it.

How to remove the license from a group?

  • Sign in to the Microsoft Entra admin center.
  • Select the desired users.
  • Navigate to Identity»Billing»Licenses.
  • Select the name of the license plan you want to remove from the group, and click Licensed groups.
  • Now, select Remove license to remove the license from the group.
entra-lic

Remove user licenses from the Microsoft 365 admin center

  • Navigate to Users»Active users and click on the desired user.
  • Within the Licenses and apps tab, you will find a range of licenses listed under the Licenses section. Now, uncheck the license that needs to be removed.
  • Additionally, you can also remove the license of the desired application under the Apps section.
  • Once done, click Save changes to remove the license(s) from the selected users.

What happens to user data when an O365 license is removed?

  • When a user's license is removed, their Exchange data will be preserved for 30 days. Within this timeframe, admins can restore the user's data if needed. However, after the 30-day period, the data will be permanently deleted and cannot be recovered. If any retention policy or label is applied to the Exchange Online data, it will be retained until the policy expires.
  • For the files saved in OneDrive for Business, unless the user is deleted from the Microsoft 365 environment, those files will not be deleted.
  • If you have an Enterprise subscription, like Office 365 Enterprise E3 or E5, you can retain the mailbox data of deleted user accounts using inactive mailboxes by adjusting the hold duration of the mailbox.
  • Once the license is removed, the user's mailbox can't be searched using eDiscovery tools.

With AdminDroid’s dedicated report for license revoking activities, find all the removed Microsoft 365 license details along with the revoked plan details.

  • This report provides insights into the licenses that have been removed, allowing you to reassign them to active users which helps in optimal usage of Microsoft 365 licenses.
ad-revoke
+

Kickstart Your Journey With
AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities

Download Now
User Help Manuals Compliance Docs
x
Delivering Reports on Time
Want a desired Microsoft 365 reports every Monday morning? Ensure automated report distribution and timely delivery with AdminDroid's Scheduling to your email anytime you need.
Delivering Reports on Time
Schedule tailored reports to execute automatically at the time you set and deliver straight to the emails you choose. In addition, you can customize report columns and add inteligent filtering to the activities just from the previous day to suit your Microsoft 365 report requirements.
Set It, Schedule It, See Results- Your Reports, Your Way, On Your Time!
Time Saving
Automation
Customization
Intelligent Filtering
Give Just the Right Access to the Right People
Grant fine-tuned access to any Microsoft 365 user with AdminDroid’s Granular Delegation and meet your organization’s security and compliance requirements.
Give Just the Right Access to the Right People
Create custom roles loaded with just the right permissions and give access to admins or normal users within AdminDroid. The result? A streamlined Microsoft 365 management experience that aligns your organization's security protocols and saves your invaluable time and effort.
Align, Define, Simplify: AdminDroid's Granular Delegation
Smart Organizational Control
Effortless M365 Management
Simplified Access
Advanced Alerts at a Glance
Receive quick notifications for malicious Microsoft 365 activities. Engage with the AdminDroid’s real-time alert policies crafted to streamline your security investigations.
Advanced Alerts at a Glance
Stay informed of critical activities like suspicious emails and high-risk logins, bulk file sharing, etc. Through creating and validating ideal alert policies, AdminDroid provides a comprehensive approach to real-time monitoring and management of potential threats within your organization.
AdminDroid Keeps You Always Vigilant, Never Vulnerable!
Proactive Protection
Real-time Monitoring
Security Intelligence
Threat Detection
Merge the Required Data to One Place
Combine multiple required columns into one comprehensive report and prioritize the information that matters most to you with AdminDroid’s Advanced Column Customization.
Merge the Required Data to One Place
This column merging capability offers a flexible way to add different columns from various reports and collate all the essential data in one place. Want to revisit the customized report? Save it as a 'View’, and your unique report is ready whenever you need it.
Merge with Ease and Save as Views!
Custom Reporting
Unique View
Desired Columns
Easy Data Interpretation
Insightful Charts and Exclusive Dashboards
Get a quick and easy overview of your tenant's activity, identify potential problems, and take action to protect your data with AdminDroid’s Charts and Dashboards.
Insightful Charts and Exclusive Dashboards
With AdminDroid charts and dashboards, visualize your Microsoft 365 tenant in ways you've never thought possible. It's not just about viewing; it's about understanding, controlling, and transforming your Microsoft 365 environment.
Explore Your Microsoft 365 Tenant in a Whole New Way!
Executive overviews
Interactive insights
Decision-making
Data Visualization
Efficient Report Exporting for Microsoft 365
Downloading your reports in the right file format shouldn’t be a hassle with AdminDroid’s Report Export. Experience seamless report exporting in various formats that cater to your needs.
Efficient Report Exporting for Microsoft 365
Navigate through diverse options and export Microsoft 365 reports flawlessly in your desired file format. Tailor your reports precisely as you need them and save them directly to your computer.
Take Control, Customize and Deliver- Your Office 365 Data, Exported in Your Way!
Easy Export
Seamless Downloading
Data Control
Manage Microsoft 365

Get AdminDroid Office 365 Reporter Now!