Generate-M365LicenseAssignmentReport

2.8

This script connects to Microsoft 365 services and collects detailed information about license assignments across the tenant. It produces a formatted report showing which users have been assigned which licenses, including license details and assignment status. The report can be exported to various formats for analysis and compliance purposes.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Script -Name Generate-M365LicenseAssignmentReport

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Package Details

Author(s)

  • Roy Klooster

Tags

RKSolutions Microsoft365 MicrosoftEntraID MicrosoftGraph

Functions

New-HTMLReport Install-Requirements Connect-ToMgGraph Invoke-GraphRequestWithPaging Get-LicenseIdentifiers Send-EmailWithAttachment

Dependencies

This script has no dependencies.

Release Notes

Initial release - Comprehensive Microsoft 365 license assignment report with HTML output
v1.0 -2.3 - Test phase
v2.4 - Added function Test-MgGraphConnection to check for existing connections with the proper permissions
V2.5 - removed the need of "Microsoft.Graph.Beta.Identity.DirectoryManagement","Microsoft.Graph.Beta.Users", "Microsoft.Graph.Beta.Groups".
- Powershell 7 as requirements have been fixed + faster
v2.6            - Added Interactive, ClientSecret, Certificate, Identity and AccessToken parameters to support different authentication methods.
- Added support for sending the report via email with customizable subject and body text.
v2.7            - Added last successful sign-in information for each user.
v2.8           - Add extra check for Powershell version in the install-requirement function to install the most recent graph module version when Powershell 7 is used. If Powershell 5 is used. It will force the required 2.25.0 version because of compatibility
- fixed $lastSignIn variable to be used in the report
- fixed the filtering for the license assignment types

FileList

Version History

Version Downloads Last updated
2.8 (current version) 108 6/10/2025
2.7 114 5/26/2025
2.6 56 5/22/2025
2.5 756 4/15/2025
2.4 891 4/11/2025